SAS
This section explains how to connect SAS to an Exasol database.
SAS provides SAS/ACCESS Interfaces to access an Exasol database using ODBC and JDBC.
Exasol takes no responsibility for any changes in functionality or terms of use for the third-party software described in this section. For more information, refer to the respective software vendor’s website.
Prerequisites
- 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 Database and Clusters.
- The IP address of the host where the tool is running must be in the allowed IP address list. For more information, see Network Security.
Connect SAS to Exasol via ODBC
- Download and install the Exasol ODBC driver on the SAS machine and create a DSN to your Exasol database.
- Configure the following LIBNAME statement in the SAS/ACCESS Interface for ODBC:
- 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.
LIBNAME Exasol ODBC dsn="your-exasol-dsn" SCHEMA=your_schema USER=your_exasol_user PASSWORD=your_exasol_pwd;
Connect SAS to Exasol via JDBC
- Download the Exasol JDBC driver on the SAS machine.
- Configure the following LIBNAME statement in the SAS/ACCESS Interface for JDBC:
- 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.
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;
Testing the Connection
Run the following PROC SQL procedure and verify that it returns Connection works
: