BookmarkSubscribeRSS Feed
Fluorite | Level 6

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


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.

Rhodochrosite | Level 12



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,


Obsidian | Level 7

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? 




suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

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.

Discussion stats
  • 5 replies
  • 5 in conversation