PowerCenter
- PowerCenter 10.5.3
- All Products
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
|