topic Re: sas 94 M6 SAS/ACCESS Interface to JDBC connect apache hadoop in New SAS User

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

shursulei — Tue, 08 Oct 2019 02:19:19 GMT

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.

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

SASKiwi — Tue, 08 Oct 2019 02:47:32 GMT

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-databases.html

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

AnandVyas — Tue, 08 Oct 2019 02:56:30 GMT

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!

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

shursulei — Tue, 08 Oct 2019 03:08:48 GMT

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.

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

SASKiwi — Tue, 08 Oct 2019 03:41:23 GMT

@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.

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

shursulei — Tue, 08 Oct 2019 05:13:38 GMT

OK,Thanks