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

Prerequisites

Prerequisites

Before you use PowerExchange for Teradata Parallel Transporter API, you must perform the following tasks:
  1. Install the Informatica services.
  2. Install the Informatica clients. When you install the Informatica clients, the Developer tool is installed.
  3. Create a Data Integration Service and a Model Repository Service in the Informatica domain.
  4. To run mappings in the native environment, perform the following steps:
    • Install Teradata Parallel Transporter on the node that runs the Data Integration Service. You must update the Teradata Parallel Transporter installation to the latest patch.
    • Install the Teradata JDBC driver. You can download the latest version of the Teradata JDBC driver from the following URL: http://downloads.teradata.com/download/connectivity/jdbc-driver
    • To import metadata from Teradata tables, copy the Teradata JDBC jars to the following directory on the node where you installed the Developer tool:
      <Informatica installation directory>/clients/externaljdbcjars
    • Update the CLASSPATH environment variable to include the Teradata JDBC jars.
    • To run partitioned mappings, copy the Teradata JDBC jars to the following directory on the node that runs the Data Integration Service:
      <Informatica installation directory>/externaljdbcjars
  5. To run mappings on the Hive engine without using TDCH, perform the following steps:
    • Install Informatica Big Data Management on every node of the Hadoop cluster.
    • Install Teradata Parallel Transporter on every node of the Hadoop cluster. You must update the Teradata Parallel Transporter installation to the latest patch.
    • To run partitioned mappings, copy the Teradata JDBC jars to the following directory on the node that runs the Data Integration Service:
      <Informatica installation directory>/externaljdbcjars
    • Update the CLASSPATH environment variable to include the Teradata JDBC jars.
  6. To run Teradata mappings on the Blaze engine, perform the following steps:
    • Install Informatica Big Data Management on every node of the Hadoop cluster.
    • Specify the Data Integration Service user name in the
      Impersonation User Name
      field of the Hadoop connection.


Updated October 05, 2018