Use a JDBC connection to connect to the PostgreSQL database.

Informatica installs a DataDirect JDBC driver for PostgreSQL that you can use to connect to the database. Find the driver in the

clients/DeveloperClient/infacmd

installation directory, and copy the driver to the

clients/externaljdbcjars

directory .

Specify the database schema name. Do not leave the schema name blank.

If the database uses the default PostgreSQL schema name of

public

, you can specify

public

as the schema name.

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