Download the JDBC Drivers for Sqoop Connectivity
To configure Sqoop connectivity for relational databases, you must download JDBC driver jar files.
- 1. Download any Type 4 JDBC driver that the database vendor recommends for Sqoop connectivity.
- 2. Copy the jar files to the following directory on the machine where the Data Integration Service runs: <Informatica installation directory>\externaljdbcjars
At run time, the Data Integration Service copies the jar files to the Hadoop distribution cache so that the jar files are accessible to all nodes in the cluster.
Note: The DataDirect JDBC drivers that Informatica ships are not licensed for Sqoop connectivity.