topic Re: Connect from SAS to a JDBC data source in Administration and Deployment

Connect from SAS to a JDBC data source

nhvdwalt — Fri, 11 Aug 2017 11:36:07 GMT

Hi team,

How do I connect to a JDBC data source from SAS ? I have the JDBC URI and the jar file for the target database

I'm looking for something similar to SAS Access to Hadoop where you can spcify the custom URI in the libname statement.

Thanks,

Re: Connect from SAS to a JDBC data source

ChrisBrooks — Fri, 11 Aug 2017 15:21:30 GMT

It'll be vendor-specific but if you're talking about Hadoop this page could give you a start http://support.sas.com/documentation/cdl/en/acreldb/69580/HTML/default/viewer.htm#p0ly2onqqpbys8n1j9lra8qa6q20.htm

Re: Connect from SAS to a JDBC data source

nhvdwalt — Mon, 14 Aug 2017 06:50:41 GMT

Thanks Chris,

Yes, that is exactly what I need, but not under SAS/Access to Haddop, but rather just a generic JDBC connection (engine). So imagine something like SAS/Access to JDBC where you can specify your own JDBC URI in the libname. For example ....

LIBNAME mylib JDBC URI="<< my custom JDBC connection string>>";

RUN;

Re: Connect from SAS to a JDBC data source

ChrisBrooks — Mon, 14 Aug 2017 23:25:48 GMT

Sorry but I don't think you can do this without using SAS/ACCESS - try raising the question with SAS Support

Re: Connect from SAS to a JDBC data source

nhvdwalt — Tue, 15 Aug 2017 04:22:46 GMT

Thanks Chris, will do.

Re: Connect from SAS to a JDBC data source

nhvdwalt — Thu, 17 Aug 2017 12:30:19 GMT

Reply from Tech Support...

Red Hat JBoss Data Virtualization is very similar to our SAS Federation Server, I didn't find any good resource on that but looking at Red Hat documentation it can be accessed via ODBC or JDBC.

Our first choice would be using SAS\Access to ODBC because it's the more standard approach for connecting to any ODBC compliant DB.

Another option would be to connect SAS Federation server to Red Hat JBoss Data Virtualization but it's more complicated and redundant. "

@ChrisBrooks

Re: Connect from SAS to a JDBC data source

SalmanMaher — Sun, 03 Feb 2019 20:39:14 GMT

SAS has released SAS/ACCESS to JDBC with SAS 9.4m6 in 2018. See Help Center documentation for more information.