Integration Guide

Back Next

Verify JDBC Drivers for Sqoop Connectivity

Verify that you have the JDBC drivers to access JDBC-compliant databases in the Hadoop environment. You might need separate drivers for metadata import and for run-time processing.

Perform this task in the following situations:
You are integrating for the first time. You upgraded from version 10.2.1 or earlier.

You download drivers based on design-time and run-time requirements:

Design-time.
To import metadata, you can use the DataDirect drivers packaged with the Informatica installer if they are available. If they are not available, use any Type 4 JDBC driver that the database vendor recommends.

Run-time.
To run mappings, use any Type 4 JDBC driver that the database vendor recommends. Some distributions support other drivers to use Sqoop connectors. You cannot use the DataDirect drivers for run-time processing.

Amazon EMR Integration Tasks

Verify Design-time Drivers

Verify Run-time Drivers

Azure HDInsight Integration Tasks

Verify Design-time Drivers

Verify Run-time Drivers

Cloudera CDH Integration Tasks

Verify Design-time Drivers

Verify Run-time Drivers

Hortonworks HDP Integration Tasks

Verify Design-time Drivers

Verify Run-time Drivers