BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
SASWayne
Quartz | Level 8

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!

1 ACCEPTED SOLUTION

Accepted Solutions
gwootton
SAS Super FREQ
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
--
Greg Wootton | Principal Systems Technical Support Engineer

View solution in original post

2 REPLIES 2
gwootton
SAS Super FREQ
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
--
Greg Wootton | Principal Systems Technical Support Engineer
SASWayne
Quartz | Level 8
That helps, thanks so much @gwootton !

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
  • 2 replies
  • 1134 views
  • 1 like
  • 2 in conversation