Upgrading from Version 10.2 (10.5.4)

10.5.4
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.5.1
- 10.5.5
- 10.5.3
- 10.5.2

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 To set the private truststore files, you must manually import the certificates. Run the keytool command in the <INFA_JDK_HOME> directory to import the private truststore certificates. For example, use the following keytool command: keytool -noprompt -importkeystore -srckeystore <source truststore file path> -srcstorepass <source truststore file password> -srcalias <alias> -srcstoretype JKS -destkeystore <destination truststore file path> -deststorepass <destination truststore file password> -keypass <private key password> -deststoretype JKS
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 To set the private truststore files, you must manually import the certificates. Run the keytool command in the <INFA_JDK_HOME> directory to import the private truststore certificates. For example, use the following keytool command: keytool -noprompt -importkeystore -srckeystore <source truststore file path> -srcstorepass <source truststore file password> -srcalias <alias> -srcstoretype JKS -destkeystore <destination truststore file path> -deststorepass <destination truststore file password> -keypass <private key password> -deststoretype JKS

Rename Saved Search

Table of Contents

Upgrading from Version 10.2 (10.5.4)

Upgrading from Version 10.2 (10.5.4)

Step 6. Configure Database Client Environment Variables on UNIX

Step 6. Configure Database Client Environment Variables on UNIX