Adding Custom JDBC Connections (Experimental)

You can use the Custom Connection dialog to add a user-defined connection for a database using a JDBC driver. You are responsible for obtaining the JDBC driver jar file and adding it to the SAS Data Management Platform java classpath. For information about setting the classpath, see Java Classpath.

The driver must be compliant with Java 8.

Note that this custom connection is an experimental feature. Experimental software is sometimes included as part of a production-release product. It is provided to customers in order to obtain feedback. All experimental features are marked Experimental in this document. The design, functionality, and syntax of experimental software might change before any production release. Experimental software has been tested prior to release, but it has not necessarily been tested to production-quality standards, so it should be used with care. Technical support for experimental features is not available.

Perform the following steps to add a user-defined connection to a database with a JDBC driver:

  1. Click the Data riser on the SAS Data Management Studio desktop.
  2. Expand the Data Connections folder.
  3. Select the New Data Connection menu in the Data Connections pane on the right. Then select Custom Connection to display the Custom Connection dialog.
  4. Enter the connection string into the Custom connection field. Specify values for the attributes that are shown in the example connection string.

    The following connection string connects to an Oracle database via a JDBC driver.
    DFJDBC=
    (DRIVER=oracle.jdbc.OracleDriver;CONN=jdbc:oracle:thin::@localhost:1521/ORACLE_DB);DFXTKDSN=Oracle JDBC;pwd=ORACLE_PWD;uid=ORACLE_UID;; DFXTYPE=JDBC

  5. Test the connection by clicking Test Connection.
  6. Click OK to save the new connection and return to the Data riser.
  7. Refresh the Data riser in order to see the new connection in the Data Connections folder in the left pane. Select View, and then select Refresh from the main menu. The new connection should appear in the Data Connections folder.
  8. To verify a connection, double-click the connection in the Data Connections folder in the left pane. If the connection works, you will be able to see tables, fields, and other attributes in the right panel.

Administrators can specify where custom connections are stored. For more information, see the User saved connection setting in the "Data Access Component Directives" topic in the SAS Data Management Studio Installation and Configuration Guide.