Teradata Parallel Transporter

Teradata Parallel Transporter (TPT) is a Teradata utility.

Teradata Parallel Transporter

Teradata Parallel Transporter, a parallel multi-function load environment, simplifies building and maintaining a data warehouse by providing flexible, scalable access to data sources from a single interface using a single SQL-like scripting language or an open API. It provides a completely parallel environment that is faster, easier to use, and much more extensible than other tools available on the market. Dozens of files can be loaded using a single script, making development and maintenance easier. What’s more, Teradata Parallel Transporter efficiently utilizes system resources by allowing easy distribution of the workload across CPUs, eliminating bottlenecks in data loading process.

Each user simply creates a job – a string of Teradata Parallel Transporter commands – that allows them to perform operations, such as heterogeneous data access, data integrity checks, data merging, and data loads in batch or near-real-time.

Teradata Parallel Transporter provides a set of open APIs that enables integration of third-party tools or custom applications, enabling you to leverage your investment in transformation tools and parallelism of the Teradata Parallel Transporter infrastructure.

The idea was to use the different Teradata Load and Unload Utilities under a single infrastructure. So, the based on the protocols of fastload, multiload, tpump and fastexport, new "operators" were developed and they are named as Load, Update, Stream and Export operators respectively. Apart from the four operators, there are more operators like Selector, Inserter, Dataconnector, and recently gaining heavy popularity is ODBC operator, which is used to pull data out of other databases and load them to teradata using ODBC connectivity.

Features

* Single infrastructure for all loading needs using single scripting language
* Integrated API to interface with ETL tools and custom programs
* Completely parallel
* Combines functionality of Teradata FastLoad, MultiLoad, FastExport, and TPump

upported Platforms

* NCR UNIX SVR4 MP-RAS
* IBM z/OS (MVS)
* Microsoft Windows 2000, XP, Vista and Server 2003
* Sun Solaris SPARC
* HP-UX
* IBM AIX
* Red Hat Linux
* SUSE Linux Enterprise Server from Novell

External links

* [http://www.teradata.com/t/page/94244/index.html/ Teradata Load & Unload Utilities]