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.
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.