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.
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$PATHUSER_INSTALL_DIR/ODBC7.1:$PATHUSER_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 |