Table of Contents

Search

  1. About the Test Data Management Installation Guide
  2. Test Data Management Installation Overview
  3. Before You Install TDM
  4. Prepare for Application Services and Databases
  5. Create the Application Services
  6. Install the Clients
  7. TDM Installation
  8. After You Install TDM
  9. Infacmd
  10. Starting and Stopping Informatica and TDM
  11. Uninstallation
  12. Updating the DynamicSections Parameter of a DB2 Database

Installation Guide

Installation Guide

Configure Database Client Environment Variables

Configure Database Client Environment Variables

Configure database client environment variables on the machines that run the Data Integration Service, PowerCenter Integration Service, and PowerCenter Repository Service processes.
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
IBM DB2
DB2DIR
DB2INSTANCE
PATH
db2connect
Set to: <
database path
>
Set to: <
DB2InstanceName
>
Add: <
database path
>/bin
Sybase ASE
SYBASE15
SYBASE_ASE
SYBASE_OCS
PATH
isql
Set to: <
database path
>/sybase
<version>
Set to: ${SYBASE15}/ASE-
<version>
Set to: ${SYBASE15}/OCS-
<version>
Add: ${SYBASE_ASE}/bin:${SYBASE_OCS}/bin:$PATH
PostgreSQL
PGSERVICEFILE
PGHOME
PATH
LD_LIBRARY_PATH
INFA_TRUSTSTORE
Set to the location of the pg_service.conf file:
<pg_service.conf file directory>/pg_service.conf
Set to:
/usr/pgsql -10
Add to:
$PGHOME:${PATH}
Add to:
$PGHOME/lib:${LD_LIBRARY_PATH}
For default SSL domain, add to: <InstallationDirectory>/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

0 COMMENTS

We’d like to hear from you!