BookmarkSubscribeRSS Feed
cjsummers
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

5 REPLIES 5
SASKiwi
PROC Star

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.

AhmedAl_Attar
Rhodochrosite | Level 12

@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

rkbright
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? 

 

Thanks,

Richard

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 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 3926 views
  • 0 likes
  • 5 in conversation