sas 94 M6 SAS/ACCESS Interface to JDBC connect apache hadoop

[shursulei]

We want to use the SAS/ACCESS Interface to JDBC connect apache hadoop which is used hive.

Is SAS/ACCESS JDBC connection supported and how to configure and edit code to connect  apche hadoop.

[SASKiwi]

As I understand it, this interface is for connecting to relational databases which obviously excludes Hadoop.

Accessing Hadoop from SAS is primarily available with SAS/ACCESS to Hadoop - see Viya details here: https://support.sas.com/en/documentation/third-party-software-reference/viya/34/support-for-database...   

[AnandVyas]

Hi @shursulei 

Yes, JDBC is supported in 9.4 M6.

System requirements for JDBC are below. As mentioned you will have to source JDBC drivers from you HDP provider, cloudera or Hortonworks. There is no extra step or configuration required apart from the BASE installation.

SAS/ACCESS Interface to JDBC
SAS/ACCESS Interface to JDBC was new with the November 2018 release of SAS/ACCESS. Base SAS
is required for the installation of SAS/ACCESS Interface to JDBC.
SAS/ACCESS Interface to JDBC requires a Java Database Connectivity (JDBC) driver. JDBC drivers
are often available from DBMS vendors and from other third-party JDBC driver developers. 

JDBC supported features are listed here. You can use libname statement or SQL Pass-thru facility to connect. Hyperlinks for syntax and examples.

Thanks!

[shursulei]

is supported to connnect Hive's jdbc.Not the relational database? JDBC to relational database and JDBC to Hive ，Whether there is a difference between the two.

[SASKiwi]

@shursulei  - You are probably best off asking SAS Tech Support. I'm giving you answers found by searching documentation where it states that not all third-party JDBC drivers can be tested or supported. It is also likely that even if it did work some Hadoop-specific features would not be supported via the more generic JDBC method.

[shursulei]

OK,Thanks