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 CDI-PC services.
Microsoft SQL Server 2014 Native Client
You must 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. 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 CDI-PC. 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:
PostgreSQL installation directory:
C:\Program Files\PostgreSQL\<version>
Command line tools installation directory:
C:\Program Files\PostgreSQL\<version>
pgAdmin4 installation directory:
C:\Program Files\PostgreSQL\<version>\pgAdmin 4
These directories are the default directories used during installation on Windows. You can choose to customize these paths.
PostgreSQL on Linux
On Linux, you need to install the appropriate PostgreSQL library packages. The package names and versions vary depending on the PostgreSQL version installed.
For example,
PostgreSQL 15 (consider version 15.x.y)
postgresql15-15.x.y-1PGDG.rhel7.x86_64
postgresql15-libs-15.x.y-1PGDG.rhel7.x86_64
PostgreSQL 17 (consider version 17.x.y)
postgresql17-17.x.y-1PGDG.rhel7.x86_64
postgresql17-libs-17.x.y-1PGDG.rhel7.x86_64
For more information about psql, see the psql client documentation: https://www.postgresql.org/docs/current/app-psql.html
ASK INFAPreview
