17.10 - Scripting and Teradata API Environments - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

Product
Parallel Transporter
Release Number
17.10
Release Date
June 2021
Content Type
Programming Reference
Publication ID
B035-2516-061K
Language
English (United States)

Unlike the Teradata utilities and Teradata Parallel Transporter that are driven by scripts, Teradata PT is a functional library that is part of your applications. This allows the applications to have more control during the load and export processes.

Advantages for using Teradata PT include:
  • Open standard reduces research and development costs to integrate with the database
  • Robust API facilitates easier access to key database functions
  • Better control of the runtime environment simplifies the management processes
The following figures illustrate the difference between the environments from an application enterprise overview.
  • In the existing script environment, the partner application and a Teradata utility must run as two separate jobs.
  • In the API environment, the transform, load, export, and other functions can be integrated into one application and run as one job.
Typical Utility Integration Architecture for Customer Applications

Teradata PT Integration Architecture for Customer Applications