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
