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

Install Database Client Software

Install Database Client Software

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.
PostgreSQL client (psql)
Install and run the PostgreSQL interactive terminal program called psql, which allows you to interactively enter, edit, and run SQL commands.
psql is a terminal-based front-end to PostgreSQL. You can type in queries interactively, issue the queries to PostgreSQL, and check the query results. Or, the input can be from a file or from command line arguments.
You can install psql client application for PostgreSQL to work only on Linux or Windows.
Install and run the required software dependency packages to build PostgreSQL, such as GCC compiler package, readline and readline-devel packages, and zlib-devel compression library package. After you install the packages from the GNU Readline library, psql remembers each command you type, and you can use arrow keys to recall and edit previous commands.
You can also run the required library files with the
yum install
commands.
PostgreSQL on Windows
On Windows, download the psql client from the following link:
You must verify that PostgreSQL libraries are present in the following directories on Windows:
  • Installation directory:
    C:\Program Files\PostgreSQL\10
  • Command line tools installation directory:
    C:\Program Files\PostgreSQL\10
  • pgAdmin4 installation directory:
    C:\Program Files\PostgreSQL\10\pgAdmin 4
PostgreSQL on Linux
On Linux, you also need to install the required postgreSQL libraries,
postgresql10-10.10-1PGDG.rhel7.x86_64
and
postgresql10-libs-10.10-1PGDG.rhel7.x86_64
For more information about psql, see the psql client documentation in the following link: https://www.postgresql.org/docs/10/app-psql.html