SAS connectivity to snowflake using JDBC

[SASWayne]

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

or

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!

[gwootton · Accepted solution]

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

[SASWayne]

That helps, thanks so much @gwootton !