Installation Guide for Informatica Data Quality (Modernization)

Back Next

Set the database client environment variables

Set environment variables depending on the type of database you use.

The following table lists the environment variables for an IBM DB2 database:

The following table lists the environment variables for an Oracle database:

Environment variable	Value
ORACLE_HOME	<Client install database path>
TNS_ADMIN	Set to the location of the tnsnames.ora file:$ORACLE_HOME/network/admin
PATH	<user installation directory>/server/bin:$ORACLE_HOME/bin:$PATH
LD_LIBRARY_PATH	<user installation directory>/server/bin:$Oracle_HOME/lib:$LD_LIBRARY_PATH
INFA_TRUSTSTORE	Set INFA_TRUSTSTORE and INFA_TRUSTSTORE_PASSWORD

The following table lists the environment variables for a Microsoft SQL Server database:

Environment variable	Value
ODBCHOME	<User installation directory>/ODBC7.1
ODBCINI	$ODBCHOME/odbc.ini
ODBCINST	$ODBCHOME/odbcinst.ini
PATH	$ODBCHOME/bin:$PATH
LD_LIBRARY_PATH	<user installation directory>/server/bin:$ODBCHOME/lib:$LD_LIBRARY_PATH
INFA_TRUSTSTORE	Set INFA_TRUSTSTORE and INFA_TRUSTSTORE_PASSWORD

The following table lists the environment variables for a PostgreSQL database:

Environment Variable	Value
PGSERVICEFILE	Set to the location of the pg_service.conf file: <pg_service.conf file directory>/pg_service.conf
PGHOME	/usr/pgsql -10
PATH	$PGHOME/bin:${PATH}
LD_LIBRARY_PATH	$PGHOME/lib:${LD_LIBRARY_PATH}
INFA_TRUSTSTORE	Set INFA_TRUSTSTORE and INFA_TRUSTSTORE_PASSWORD
POSTGRES_ODBC	Set the value to 1 for the PostgreSQL ODBC connection. You can set it for all the repositories in the domain or for any PostgreSQL repository that uses an ODBC connection.
USE_LIBPQ	Set the value to YES.

The following table lists the environment variables for an Sybase database:

Environment Variable	Value
SYBASE15	<database path>/sybase<version> >
SYBASE_ASE	${SYBASE15}/ASE-<version>
SYBASE_OCS	${SYBASE15}/OCS-<version>
PATH	${SYBASE}/bin:${SYBASE}/${SYBASE_OCS}/bin:${SYBASE}/${SYBASE_ASE}/bin:${SYBASE}/${SYBASE_FTS}/bin:${PATH}
SYBASE_FTS	FTS-16_0
LD_LIBRARY_PATH	${LD_LIBRARY_PATH}:${SYBASE}/${SYBASE_OCS}/lib:${SYBASE}/${SYBASE_ASE}/lib:${SYBASE}/${SYBASE_FTS}/lib