SAS

Learn how to connect SAS to an Exasol database.

SAS provides SAS/ACCESS Interfaces to access an Exasol database using either ODBC or JDBC.

Exasol takes no responsibility for changes in functionality or terms of use for third-party tools. For more details about the compatibility and use of these tools with Exasol, refer to the respective software vendor’s website.

Prerequisites

  • You must have one of the following SAS/ACCESS interfaces licensed and installed:
    • SAS/ACCESS Interface for ODBC
    • SAS/ACCESS Interface for JDBC

  • Your Exasol database must be running and reachable from the environment where the tool is used.

Exasol SaaS

  • The IP address of the host where the tool is running must be in the allowed IP address list in Exasol SaaS. To learn how to allow traffic to your database, see Network security (SaaS).

  • To connect the tool to an Exasol SaaS cluster you will need the connection string and a personal access token (PAT) for authentication. To learn how to get the connection details, see Connect to Exasol SaaS.

Connect SAS to Exasol using ODBC

  1. Download and install the Exasol ODBC driver and create a DSN to your Exasol database.

  2. Configure the following LIBNAME statement in the SAS/ACCESS Interface for ODBC:

    LIBNAME Exasol ODBC dsn="your-exasol-dsn" SCHEMA=your_schema USER=your_exasol_user PASSWORD=your_exasol_pwd;

    For Exasol SaaS, use a valid personal access token as password.

  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 using JDBC

  1. Download the Exasol JDBC driver.

  2. Configure the following LIBNAME statement in the SAS/ACCESS Interface for JDBC:

    Copy 
    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;

    For Exasol SaaS, use the connection string to the Exasol database as URL and a valid personal access token as PASSWORD.

    See also Prerequisites.

  3. Optionally modify the DBCOMMIT, INSERTBUFF, and READBUFF settings of the LIBNAME statement to increase data transfer performance. For more information, refer to the SAS/ACCESS Interface for JDBC documentation.

Testing the connection

To test the connection to Exasol, run the following procedure and verify that it returns Connection works:

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