SAS

This section provides you with information on connecting the Exasol database with SAS via ODBC or JDBC. SAS provides SAS/ACCESS Interfaces for ODBC and JDBC to access an Exasol database.

Prerequisite

  • Make sure you have one of the following SAS/ACCESS interfaces licensed and installed:
    • SAS/ACCESS Interface for ODBC.
    • SAS/ACCESS Interface for JDBC.
  • A running Exasol SaaS database. For more information, see Manage Databases and Clusters.
  • The IP address of the client or server where the tool is running must be listed in the allowed IP address list. For more information, see Network Security.

Connect SAS to Exasol via ODBC

  1. Download and install the Exasol ODBC driver on the SAS machine and create a DSN to your Exasol database.
  2. Configure the following LIBNAME statement in the SAS/ACCESS Interface for ODBC:
    3. LIBNAME Exasol ODBC dsn="your-exasol-dsn" SCHEMA=your_schema USER=your_exasol_user PASSWORD=your_exasol_pwd;
  3. Optionally modify DBCOMMIT, INSERTBUFF, READBUFF settings of LIBNAME statement to increase data transfer performance. Additionally, refer to the SAS/ACCESS Interface for ODBC documentation for more information.

Connect SAS to Exasol via JDBC

  1. Download the Exasol JDBC driver on the SAS machine.
  2. Configure the following LIBNAME statement in the SAS/ACCESS Interface for JDBC:
    3. LIBNAME Exasol JDBC CLASSPATH="/path/to/jdbc/driver"
     class="com.exasol.jdbc.EXADriver"
     URL="jdbc:exa:your-exasol-hosts:your-exasol-port"
     USER=your_exasol_user
     PASSWORD=your_exasol_pwd
     SCHEMA=your_schema;
  3. Optionally modify DBCOMMIT, INSERTBUFF, READBUFF settings of LIBNAME statement to increase data transfer performance. Additionally, refer to the SAS/ACCESS Interface for JDBC documentation for more information.

Testing the Connection

Run the following PROC SQL procedure and check if "Connection works" is returned:

proc sql;
select 'Connection works' from dual;
quit;