Configure Native Connectivity on Service Machines
To establish native connectivity between an application service and a database, install the database client software for the database that you want to access.
Native drivers are packaged with the database server and client software. Configure connectivity on the machines that need to access the databases. To ensure compatibility between the application service and the database, install a client software that is compatible with the database version and use the appropriate database client libraries.
You must install the database clients on the required machines based on the types of databases that the application services access.
To ensure compatibility between the application service and the database, use the appropriate database client libraries and install a client software that is compatible with the database version.
Install the following database client software based on the type of database that the application service accesses:
- IBM DB2 Client Application Enabler (CAE)
- Configure connectivity on the required machines by logging in to the machine as the user who starts Informatica services.
- Microsoft SQL Server 2014 Native Client
- Download the client from the following Microsoft website: http://www.microsoft.com/en-in/download/details.aspx?id=42295.
- Oracle client
- Install compatible versions of the Oracle client and Oracle database server. You must also install the same version of the Oracle client on all machines that require it. To verify compatibility, contact Oracle.
- Sybase Open Client (OCS)
- Install an Open Client version that is compatible with the Sybase ASE database server. You must also install the same version of Open Client on the machines hosting the Sybase ASE database and Informatica. To verify compatibility, contact Sybase.
Configure Database Client Environment Variables
After you configure the database environment variables, you can test the connection to the database from the database client.
Oracle database
The following table lists the database environment variables that you need to set for the Oracle database with sqlplus as the database utility:
Environment Variable | Value |
|---|
ORACLE_HOME | <Client InstallDatabasePath> |
PATH | <DatabasePath>/bin and USER_INSTALL_DIR/server/bin:$PATH |
LD_LIBRARY_PATH | $Oracle_HOME/lib and USER_INSTALL_DIR/server/bin:$LD_LIBRARY_PATH |
TNS_ADMIN | Set to the location of the tnsnames.ora file: $ORACLE_HOME/network/admin |
| |
IBM DB2 database
The following table lists the database environment variables that you need to set for the IBM DB2 database with db2connect as the database utility:
Environment Variable | Value |
|---|
DB2DIR | <database path> |
DB2INSTANCE | <DB2InstanceName> |
PATH | <database path>/bin |
PostgreSQL database
The following table lists the database environment variables that you need to set for the 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:${PATH} |
LD_LIBRARY_PATH | $PGHOME/lib:${LD_LIBRARY_PATH} |
INFA_TRUSTSTORE | For default SSL domain, add to: <InstallationDirectory>/services/shared/security For custom SSL domain, set INFA_TRUSTSTORE and INFA_TRUSTSTORE_PASSWORD |