SAS JDBC connection string - to a specific SAS library.

SAS JDBC connection string - to a specific SAS library.

This article provides information on how to set up a database connection URL to connect to a SAS data source, in addition to how to connect to a specific SAS library.

You will need to the do the following to set up the SAS data source for information services:
1. Enable the SAS data source template. 
2. Put the SAS JDBC drivers (sas.intrnet.javatools.jar and sas.core.jar) in the tomcat/lib directory SAS (SAS/SHARE server):
[API]:[DBDriver]://[Hostname]:[Port];SID=[SID]

Example:
jdbc:sharenet://mySAS.example.com:8500

Example: connection to a specific SAS library
jdbc:sharenet://mySASserver.company.com:8500?&librefs=MYDATA '/company/sasdata/mydata'
jdbc:sharenet://sas.example.com:5000?librefs=users 'spotfire.user'

SAS (SAS Workspace Server):
[API]:[DBDriver]://[Hostname]:[Port]:SID

Example: connection to a specific SAS library
jdbc:sasiom://mySAS.example.com:9000?sasFetchSize=2000&librefs=_data_ '~/SpotfireFiles' http://support.sas.com/rnd/web/intrnet/java/jdbc/spec.html
http://support.sas.com/documentation/cdl/en/jdbcref/63713/HTML/default/viewer.htm#p1a7nrsg36gaf8n1j33tfwf7nsj7.htm