Architecting, installing and maintaining your SAS environment

Using a JDBC connection on a SAS Server

Reply
Occasional Contributor
Posts: 12

Using a JDBC connection on a SAS Server

Good afternoon everyone,

We currently have a server setup for SAS 9.4 and have a variety of data sources being used with it (Oracle, SQL, Teradata, etc.). We have used ODBC in the past for testing purposes, but it appears our organization is now planning on testing JDBC based connections with data lakes. Is there some specific documentation or advice this community can offer with regards to setting up a JDBC connection in the SAS management console (if that is even an option?). Any guidance or advice you might be able to provide in this matter would be greatly appreciated.

 

Thank you

Valued Guide
Posts: 559
Super User
Posts: 3,857

Re: Using a JDBC connection on a SAS Server

Posted in reply to cjsummers

With SAS you essentially have three widely-used methodologies to connect to external databases:

 

  • Custom SAS/ACCESS products like SAS/ACCESS to Oracle
  • SAS/ACCESS to ODBC which allows you access any ODBC-compliant database
  • SAS/ACCESS to OLEDB which allows you access any OLEDB-compliant database

 

Note, there is no SAS/ACCESS to JDBC product at this time for connecting to external relational databases. There is some JDBC functionality in SAS for purposes like accessing SPD tables, as @SuryaKiran points out. So while it may be possible to build a DIY solution, I would not recommend going down this path.

 

If you have working ODBC connections why waste time and money switching to unsupported DIY JDBC-type connections? As far as I can see there are no advantages in doing this but a whole bunch of disadvantages, not the least being lack of support if you run into problems.

Super Contributor
Posts: 276

Re: Using a JDBC connection on a SAS Server

@cjsummers

 

Just to add one additional option to what @SASKiwi had mentioned already.

- Using the Java Object (Data Step Component Object)

This allows you to utilize the features of your existing Java Class(es) within the SAS Data Step, with some restrictions. If you can find a way to overcome these restrictions or create a work around for them, then you should be set.

 

 

Hope this helps,

Ahmed

Super Contributor
Posts: 276

Re: Using a JDBC connection on a SAS Server

Posted in reply to AhmedAl_Attar
Occasional Contributor
Posts: 10

Re: Using a JDBC connection on a SAS Server

Posted in reply to cjsummers

Hi cjsummers,

 

what do you mean by data lake? I've learned that the term has different meaning depending on who you ask. Are you using S3? What type of bulk storage container are you using? 

 

Thanks,

Richard

Ask a Question
Discussion stats
  • 5 replies
  • 165 views
  • 0 likes
  • 5 in conversation