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 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
Install the Microsoft SQL Server 2014 Native Client for the existing mappings to work.
Install compatible versions of the Oracle client and Oracle database server. Install the same version of the Oracle client on all machines that require it. To verify compatibility, contact Oracle.
PostgreSQL Client (psql)
Install and run psql, a terminal-based front-end to PostgreSQL that allows you to interactively enter, edit, and run SQL commands.
Install and run the software dependency packages to build PostgreSQL, such as GCC compiler package, readline and readline-devel packages, and zlib-devel compression library package.
You can also run the required library files with the
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.
ASK INFAPreview
