08-11-2017 07:36 AM
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.
08-11-2017 11:21 AM
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#p0ly2onqqpbys8n1j9...
08-14-2017 02:50 AM
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>>";
08-17-2017 08:24 AM - edited 08-17-2017 08:30 AM
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. "
Need further help from the community? Please ask a new question.