The PostgreSQL database installer is bundled with the TDM installer. Use the installer available with the TDM installer to create the database.

You must use the same PostgreSQL database and user to create two connections in Test Data Manager.

Use the PostgreSQL database to create an ODBC connection.
Use the same PostgreSQL database and database user to create a JDBC connection.

You use the connections when you create the Test Data Warehouse Service in Informatica Administrator. Enter the following properties in the Step 3 - Test Data Warehouse Properties dialog box:

Enter a name and description.
Select ODBC from the
Connection Type
list.
Choose the ODBC connection that you created as the
Target Connection
.
Choose PostgreSQL from the
Connection Database Type
list.
In the
JDBC Connection for ODBC
field, select the JDBC connection that you created. TDM uses the connection in workflows with tasks that require a JDBC connection string.