8 Replies Latest reply on Jul 8, 2021 11:06 PM by David Lopez Cruz

    Creating PostgreSQL source/target definitions manually

    Ali Z New Member

      We just upgraded Informatica PowerCenter to 10.4.1 and enabled the postgresql plugin.

      Now I can create PostgreSQL connections but I don't know how to create source/target definitions without using the "PowerExchange for PostgreSQL.." option.

      I don't want to create definitions using "PowerExchange for PostgreSQL.." because I don't have access to the database from the client, only from the server, so I have to create the definitions manually.

      I tried to create ODBC definitions, but I could not assign a postgresql connection to them.

       

      Any help would be appreciated!