17.00 - Scripting and Teradata API Environments - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

prodname
Parallel Transporter
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2516-220K

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