1 Reply Latest reply on Oct 7, 2021 3:55 AM by Krishna Gangwar

    Postgresql as source for DQ

    Konrad Mokrzanski Active Member

      Does DQ can connect to postgresql as the source of data to be validated and profiled it ?

        • 1. Re: Postgresql as source for DQ
          Krishna Gangwar Seasoned Veteran

          Hi Konrad Mokrzanski,

           

          Yes, you can create a connection of type JDBC to connect to PostgreSQL database. This connection then can be used as source for mappings/profiles etc. Please note you need to get the TYPE 4 JDBC driver from the database vendor and place the jar in $INFA_HOME/externaljdbcjars directory on the server machine as well as <INFA_CLINET_HOME>\clients\externaljdbcjars folder on the windows machine where Developer Client is installed. If you are using IDQ 10.4.0 version or above, you can use Informatica shipped PostgreSQL JDBC driver.

           

          So, if you are using TYPE 4 JDBC driver provided by the database vendor, you need to know Driver Class Name and JDBC connection URL. In case you are using Informatica provided JDBC driver, use the following information while creating JDBC type connection:

           

          Driver Class Name - com.informatica.jdbc.postgresql.PostgreSQLDriver

          JDBC Connection URL - jdbc:informatica:postgresql://<host>:<port>;DatabaseName=<dbname>

           

           

          Regarrds,

          Krishna