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
  9. Appendix B: Managing Distribution Packages

Configuration Guide

Configuration Guide

PostgreSQL Database Requirements

PostgreSQL Database Requirements

You can create a Test Data Management repository on a PostgreSQL database.
Use the following guidelines when you create a Test Data Management repository on PostgreSQL:

Configuration parameters

On the database, set the configuration parameters.
The following table lists the minimum and recommended values for the configuration parameters that you must set:
Parameter
Minimum Value
Recommended Value
max_connections
200
4000
shared_buffers
2 GB
16 GB
max_locks_per_transaction
1024
1024
max_wal_size
1 GB
8 GB
checkpoint_timeout
5 minutes
30 minutes
For information about configuring the database, see the documentation for the database system.

Disk Space

Ensure that PostgreSQL has sufficient disk space for the data files. By default, the data files are present in the following location:
<PostgreSQL installation directory>/data

Privileges

Verify that the database user account has CONNECT, CREATE TABLE, and CREATE VIEW privileges.

Database Schema Name

Specify the database schema name when you use PostgreSQL as the database.
Test Data Management creates a default storage connection and creates storage tables for the connection on the Test Data Management repository database. The storage connection and tables are required for expression masking and substitution masking with repeatable values.
Test Data Management creates a connection with the following details:
  • Name of the connection:
    TDM_CONNECTION
  • Connection type:
    JDBC
To use the storage connection created on a PostgreSQL database, you must add an entry to the following file:
<Informatica installation directory>/ODBC7.1/odbc.ini
The following code includes a sample entry:
[TDM_534_B465_1] Driver=/home/ora11g/Informatica/105_B465/ODBC7.1/lib/DWpsql27.so Description=DataDirect 7.1 PostgreSQL Wire Protocol Database=TDM_534_B465_1 HostName=<host name> PortNumber=5432 Workarounds2=2

0 COMMENTS

We’d like to hear from you!