Administration Guide > Configuring TDV Data Connections > Using the ODBC Driver on UNIX > Connecting SAS System to TDV ODBC
 
Connecting SAS System to TDV ODBC
The SAS system must be installed and functional, for example in the following location:
/opt/sas
 
For more information, see the installation instructions for the SAS System for Unix.
To configure the connection between the TDV server through ODBC from SAS
1. Make sure that the SAS System is installed and has write access to SAS environment sasenv_local configuration script.
2. Adjust the SAS environment script sasenv_local by adding the necessary environment variables. The script is ltypically ocated at:
/opt/sas/SASFoundation/9.3/bin/sasenv_local
 
Make sure to set the following environment variables:
Variable
Description
COMPOSITE_HOME
COMPOSITE_HOME=/usr/local/composite/
export COMPOSITE_HOME
ODBCHOME
ODBCHOME=/usr/local/unixODBC
export ODBCHOME
ODBCINI
ODBCINI=/usr/local/unixODBC/etc/odbc.ini
export ODBCINI
ODBCINSTINI
ODBCINSTINI=/usr/local/unixODBC/etc/odbcinst.ini
export ODBCINSTINI
3. Test the SAS/Access to ODBC connectivity using the Composite data source by running the following command:
libname comptest odbc datasrc=COMPDEV;
 
Your results should be similar to:
NOTE: Libref COMPTEST was successfully assigned as follows:
      Engine:        ODBC
      Physical Name: COMPDEV