topic SAS connectivity to snowflake using JDBC in Administration and Deployment

SAS connectivity to snowflake using JDBC

SASWayne — Fri, 29 Jul 2022 08:54:45 GMT

Hello Folks,

I'm connecting SAS and Snowflake using JDBC. We have licensing for SAS/ACCESS to JDBC. The steps would be -

1. install JAVA or OpenJDK

2. Put the JDBC driver for Snowflake (JAR file) in the compute server

3. Setup Snowflake DB server, libraries, authdomain etc. in metadata and use them

4. use the libname, where driverclass=snowflake-jdbc-driverclass-string classpath=path-to-jar-file-in-server url="jdbc:snowflake:url" and other usual options.

are the above steps correct?

I'm also getting confused with SAS Driver for JDBC. Could someone help me with what it is about? Do I need to use it for SAS and Snowflake connection using JDBC?

Thanks in advance!

Re: SAS connectivity to snowflake using JDBC

gwootton — Fri, 29 Jul 2022 19:14:17 GMT

Your SAS session would probably use the SAS Private Java Runtime Environment to run Java, so I think you would only need that driver in your classpath. This SGF paper might be helpful:

Accessing Your Favorite Database with SAS® and JDBC
https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2019/3358-2019.pdf

The SAS Driver for JDBC is used to connect to SAS (e.g. SAS/SHARE server, IOM servers), rather than from it.

Connection Properties for the SAS Drivers
https://go.documentation.sas.com/doc/en/jdbcref/9.4/n095zfveym3gt5n1mdv4kioo6vb5.htm

Re: SAS connectivity to snowflake using JDBC

SASWayne — Tue, 02 Aug 2022 08:09:29 GMT

That helps, thanks so much @gwootton !