Table of Contents

Search

  1. Preface
  2. Introduction to Hadoop Integration
  3. Before You Begin
  4. Amazon EMR Integration Tasks
  5. Azure HDInsight Integration Tasks
  6. Cloudera CDH Integration Tasks
  7. Hortonworks HDP Integration Tasks
  8. MapR Integration Tasks
  9. Appendix A: Connections

Hadoop Integration Guide

Hadoop Integration Guide

Download the JDBC Drivers for Sqoop Connectivity

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.
    The DataDirect JDBC drivers that Informatica ships are not licensed for Sqoop connectivity.
  2. If you want to use MapR Connector for Teradata, perform the following steps:
    1. Download the MapR Connector for Teradata .jar file from the Teradata website.
    2. Download the
      terajdbc4.jar
      file and
      tdgssconfig.jar
      file from the following URL:
  3. 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:
  4. Copy all of 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.

0 COMMENTS

We’d like to hear from you!