Configuration Guide

10.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0

Back Next

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.

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:; https://www.enterprisedb.com/downloads/postgres-postgresql-downloads; 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

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

Install Database Client Software

Install Database Client Software