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
- 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 check if "Connection works" is returned: