Table of Contents

Search

  1. Preface
  2. Part 1: Installation Getting Started
  3. Part 2: Before You Install the Services
  4. Part 3: Run the Services Installer
  5. Part 4: After You Install the Services
  6. Part 5: Informatica Client Installation
  7. Part 6: Uninstallation
  8. Appendix A: Starting and Stopping Informatica Services
  9. Appendix B: Connecting to Databases from UNIX or Linux
  10. Appendix C: Connecting to Databases from Windows
  11. Appendix D: Updating the DynamicSections Parameter of a DB2 Database

Installation for PowerCenter and Data Quality

Installation for PowerCenter and Data Quality

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