05-18-2018 03:39 PM
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.
05-18-2018 03:47 PM
Here are some documentations that might help:
05-18-2018 07:26 PM
With SAS you essentially have three widely-used methodologies to connect to external databases:
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.
05-20-2018 12:52 AM
Just to add one additional option to what @SASKiwi had mentioned already.
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,
05-20-2018 01:03 AM
05-18-2018 07:50 PM
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?