15.10 - Compatibilities - Parallel Transporter

Teradata Parallel Transporter User Guide

prodname
Parallel Transporter
vrm_release
15.10
category
User Guide
featnum
B035-2445-035K

Compatibilities

Observe the following information about job script compatibility.

  • Scripts written for the former Teradata Warehouse Builder work with Teradata PT without modification, but Teradata Warehouse Builder scripts cannot employ new Teradata PT features. Teradata recommends that all new scripts be written using the Teradata PT scripting language.
  • Scripts written for Teradata standalone utilities are incompatible with Teradata PT. Teradata recommends that existing standalone utility scripts be reworked using Teradata PT scripting language. Contact Professional Services for help.
  • Other Vendors

    ETL vendor products can be used with Teradata PT to generate scripts for load operations or to make API calls:

  • Extract, Transform, and Load (ETL) vendors add value by performing:
  • Data extractions and transformations prior to loading Teradata Database. Teradata PT provides the ability to condition, condense, and filter data from multiple sources through the Teradata PT SELECT statement.
  • Data extractions and loading, but leaving all the complex SQL processing of data to occur inside the Teradata Database itself. Like ETL vendors, Teradata PT can condition, condense, and filter data from multiple sources into files.
  • The Teradata PT API provides additional advantages for third-party ETL/ELT vendors. For more information, see the Teradata Parallel Transporter Application Programming Interface Programmer Guide.