Table of Contents

Search

  1. About the Test Data Management Configuration Guide
  2. Test Data Management Configuration Overview
  3. Before You Configure Test Data Management
  4. Prepare for Application Services and Databases
  5. Create the Application Services
  6. Configure Test Data Management
  7. Starting and Stopping Informatica Services
  8. Appendix A: Infacmd

Configuration Guide

Configuration Guide

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.
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

0 COMMENTS

We’d like to hear from you!