Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Teradata Parallel Transporter API
  3. PowerExchange for Teradata Parallel Transporter API Configuration
  4. PowerExchange for Teradata Parallel Transporter Connections
  5. PowerExchange for Teradata Parallel Transporter API Data Objects
  6. PowerExchange for Teradata Parallel Transporter API Mappings
  7. Teradata Parallel Transporter API Run-time Processing
  8. Data Type Reference

PowerExchange for Teradata Parallel Transporter API User Guide

PowerExchange for Teradata Parallel Transporter API User Guide

Installing and Configuring Teradata Connector for Hadoop

Installing and Configuring Teradata Connector for Hadoop

Install and configure TDCH to run a Teradata mapping on the Hive engine.
  1. Go to the Teradata Developer Exchange website: http://developer.teradata.com/
  2. Download the Teradata Connector for Hadoop Command Line Edition installation package that is relevant for the Hadoop distribution that you use. For example,
    teradata-connector-1.4.3-hadoop2.x.noarch.rpm
    .
  3. Place the
    teradata-connector.rpm
    on all the nodes of the Hadoop cluster, and install the TDCH installation package.
    The rpm package installs TDCH in the following directory:
    /usr/lib/tdch/<version number folder>
  4. Access the following directory on the machine where you installed the Informatica services:
    <Informatica installation directory>\services\shared\hadoop\<Hadoop Distribution Name>\infaConf\
  5. Find the file named
    hadoopEnv.properties
    .
  6. Make the following changes in the
    hadoopEnv.properties
    file:
    1. Set the HADOOP_CLASSPATH to include the paths of the TDCH JAR files and the
      hive-site.xml
      file as follows:
      infapdo.env.entry.hadoop_classpath=HADOOP_CLASSPATH=<Path of the dependent TDCH JAR files and the directory where the hive-site.xml file is stored>
      For example:
      infapdo.env.entry.hadoop_classpath=HADOOP_CLASSPATH=/opt/cloudera/parcels/CDH/lib/hive/conf:/opt/cloudera/parcels/CDH/lib/hive/lib/*:/usr/lib/tdch/1.5/lib/*:$HADOOP_CLASSPATH
    2. Set the INFA_MAPRED_CLASSPATH variable to include the paths of the TDCH JAR files and the
      hive-site.xml
      file.
      For example, set the INFA_MAPRED_CLASSPATH as follows:
      infapdo.env.entry.mapred_classpath=INFA_MAPRED_CLASSPATH=<Path of the dependent TDCH JAR files and the directory where the hive-site.xml file is stored>


Updated October 05, 2018