Integration Guide

10.5.3
- 10.5.5
- 10.5.4.1
- 10.5.4
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2 HotFix 1
- 10.2.2 Service Pack 1
- 10.2.2
- 10.2.1

Back Next

Verify Run-time Drivers

Verify run-time drivers for mappings that access JDBC-compliant databases in the Hadoop environment. Use any Type 4 JDBC driver that the database vendor recommends.

Download Type 4 JDBC drivers associated with the JCBC-compliant databases that you want to access.

To use Sqoop TDCH MapR Connector for Teradata, download the following files:

sqoop-connector-tdch-1.1-mapr-1707.jar

from https://repository.mapr.com/nexus/content/groups/mapr-public/org/apache/sqoop/connector/sqoop-connector-tdch/

terajdbc4.jar

and

tdgssconfig.jar

from http://downloads.teradata.com/download/connectivity/jdbc-driver

The MapR Connector for Teradata .jar file from the Teradata website.

To optimize the Sqoop mapping performance on the Spark engine while writing data to an HDFS complex file target of the Parquet format, download the following .jar files:

parquet-hadoop-bundle-1.6.0.jar

from https://repo1.maven.org/maven2/com/twitter/parquet-hadoop-bundle/1.6.0/

parquet-avro-1.6.0.jar

from https://repo1.maven.org/maven2/com/twitter/parquet-avro/1.6.0/

parquet-column-1.5.0.jar

from https://repo1.maven.org/maven2/com/twitter/parquet-column/1.5.0/

Copy all of the .jar files to the following directory on the machine where the Data Integration Service runs:

<Informatica installation directory>\externaljdbcjars

Changes take effect after you recycle the Data Integration Service. 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.

Rename Saved Search

Table of Contents

Integration Guide

Integration Guide

Verify Run-time Drivers

Verify Run-time Drivers