Connections > JDBC V2 connection properties > Prerequisites
  

Prerequisites

Before you create a JDBC V2 connection to read from or write to databases that support the JDBC Type 4 driver, complete the prerequisites.

Install the Type 4 JDBC driver

To read from or write to JDBC V2 objects, you need to install the Type 4 JDBC driver on the Secure Agent machine.
  1. 1Download the latest Type 4 JDBC driver version that your database supports from the third-party vendor site.
    2. If you want to use JDBC V2 Connector to connect to Aurora PostgreSQL, download the Aurora PostgreSQL driver. Informatica has certified Aurora PostgreSQL driver 42.2.6 for JDBC V2 Connector.
  2. 2Install the Type 4 JDBC driver for the database on the Secure Agent machine and perform the following tasks:
    1. aNavigate to the following directory on the Secure Agent machine:
      2. <Secure Agent installation directory>/ext/connectors/thirdparty/
    2. bCreate a folder and add the driver based on the type of mapping that you want to configure.
      3. For mappings, add the driver in the following folder:
      informatica.jdbc_v2/common
      For mappings in advanced mode, add the driver in the following folders:
      informatica.jdbc_v2/common
      informatica.jdbc_v2/spark
  3. 3Restart the Secure Agent.
    4. If you update the driver on the Secure Agent machine while the mapping in advanced mode runs, you need to restart the Secure Agent.