SAS
Cinchy’s JDBC Driver can be used with the SAS/ACCESS Interface to JDBC Driver capability to connect to your Cinchy instance. This section will discuss configuration and connection to your Cinchy data experience.
Prerequisite
Cinchy's JDBC Driver must be moved to the "/opt/Cinchy/client/JDBC" directory in the SAS server before attempting to configure.
Configuration
To configure SAS, you only need Cinchy’s JDBC driver that is accessible from your SAS session.
Argument | Description |
Classpath | This option specifies the class path to your JDBC JAR files. |
Class | This option specifies the class name for the JDBC driver to use for your connection. Here, we use JDBC driver class for Cinchy, org.cinchy.jdbc.Driver. |
URL | This option specifies the JDBC connection string to use to connect to your data source. The Cinchy JDBC connection string used here is: |
The SAS/ACCESS Interface to JDBC LIBNAME statement allows you to assign a library reference to your data source. This feature lets you reference a table directly in a DATA Step or in a PROC Step. This example shows the basic LIBNAME statement to connect to Cinchy.
libname libCinchy jdbc classpath = "/opt/Cinchy/client/JDBC"
class = "org.cinchy.jdbc.Driver"
URL = "jdbc:cinchy://<<Cinchy SSO URL>>/identity/connect/token?client_secret=<<GUID>>;client_id=<<ClientID>>;username=<<Username>>;password=<<PASSWORD>>;grant_type=password;scope=js_api;";
For more information on the parameters please see here.
Last updated