Architecting, installing and maintaining your SAS environment

Connect from SAS to a JDBC data source

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 91
Accepted Solution

Connect from SAS to a JDBC data source

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,


Accepted Solutions
Solution
Tuesday
Regular Contributor
Posts: 187

Re: Connect from SAS to a JDBC data source

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

View solution in original post


All Replies
Regular Contributor
Posts: 187

Re: Connect from SAS to a JDBC data source

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

Frequent Contributor
Posts: 91

Re: Connect from SAS to a JDBC data source

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;

 

Solution
Tuesday
Regular Contributor
Posts: 187

Re: Connect from SAS to a JDBC data source

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

Frequent Contributor
Posts: 91

Re: Connect from SAS to a JDBC data source

Thanks Chris, will do.

Frequent Contributor
Posts: 91

Re: Connect from SAS to a JDBC data source

[ Edited ]

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 234 views
  • 0 likes
  • 2 in conversation