Upgrading from Version 10.1 (10.4.1)

Back Next

Step 6. Configure Database Client Environment Variables on UNIX

Configure database client environment variables on the machines that run the PowerCenter Integration Service process.

After you configure the database environment variables, you can test the connection to the database from the database client.

The following table lists the database environment variables you need to set:

Database	Environment Variable Name	Database Utility	Value
Oracle	ORACLE_HOME PATH LD_LIBRARY_PATH TNS_ADMIN INFA_TRUSTSTORE	sqlplus	Set to: <Client InstallDatabasePath > Add: <DatabasePath >/bin and USER_INSTALL_DIR/server/bin:$PATH Set to: $Oracle_HOME/lib and USER_INSTALL_DIR/server/bin:$LD_LIBRARY_PATH Set to location of the tnsnames.ora file: $ORACLE_HOME/network/admin For default SSL domain, add to: USER_INSTALL_DIR/services/shared/security For custom SSL domain, set INFA_TRUSTSTORE and INFA_TRUSTSTORE_PASSWORD
SQL Server	ODBCHOME ODBCINI ODBCINST PATH LD_LIBRARY_PATH INFA_TRUSTSTORE		Set to: USER_INSTALL_DIR/ODBC7.1 Set to: $ODBCHOME/odbc.ini Set to: $ODBCHOME/odbcinst.ini Add to: /opt/mssql-tools/bin:$PATH$PATH USER_INSTALL_DIR/ODBC7.1:$PATH USER_INSTALL_DIR/server/bin:$PATH Add to: $ODBCHOME/lib USER_INSTALL_DIR/server/bin:$LD_LIBRARY_PATH For default SSL domain, add to: USER_INSTALL_DIR/services/shared/security For custom SSL domain, set INFA_TRUSTSTORE and INFA_TRUSTSTORE_PASSWORD