Scripting and Teradata API Environments - Parallel Transporter

Teradata Parallel Transporter Application Programming Interface

Product
Parallel Transporter
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2516
lifecycle
previous
Product Category
Teradata Tools and Utilities

Scripting and Teradata API Environments

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.

The advantages for using Teradata PT are:

  • Open standard reduces research and development costs to integrate with the Teradata Database
  • Robust API facilitates easier access to key Teradata Database functions
  • Better control of the runtime environment simplifies the management processes
  • Figure 1 and Figure 2 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.
  • Figure 1: Typical Utility Integration Architecture for Customer Applications
    Figure 2: Teradata PT Integration Architecture for Customer Applications