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,
Sorry but I don't think you can do this without using SAS/ACCESS - try raising the question with SAS Support
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...
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;
Sorry but I don't think you can do this without using SAS/ACCESS - try raising the question with SAS Support
Thanks Chris, will do.
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. "
SAS has released SAS/ACCESS to JDBC with SAS 9.4m6 in 2018. See Help Center documentation for more information.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.
Find more tutorials on the SAS Users YouTube channel.