15.10 - Scripting and Teradata API Environments - Parallel Transporter

Teradata Parallel Transporter Application Programming Interface

Parallel Transporter
Programming Reference

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