Teradata Parallel Transporter
Encyclopedia
Teradata Parallel Transporter (TPT) is a Teradata
load
utility, typically used in data warehousing.
multi-function load environment. It provides 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. Dozens of files can be loaded using a single script. TPT utilizes system resources efficiently by allowing distribution of the workload across CPUs, eliminating bottlenecks in data loading process.
Each user can create a job (that is, a string of TPT 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.
It was designed to use the different Teradata Load and Unload Utilities under a single infrastructure. So, based on the protocols of fastload, multiload, tpump and fastexport, new "operators" were developed and they are named as Load, Update, Stream and Export respectively. Apart from the four operators, there are more operators like Selecto, Inserter, Dataconnector, and ODBC.
Teradata Parallel Transporter is available with Informatica as well.
Teradata
Teradata Corporation is a vendor specializing in data warehousing and analytic applications. Its products are commonly used by companies to manage data warehouses for analytics and business intelligence purposes. Teradata was formerly a division of NCR Corporation, with the spinoff from NCR on...
load
Load
Load may refer to:*Structural load, forces which are applied to a structure*Cargo*The load of a mutual fund *The genetic load of a population*The parasite load of an organism...
utility, typically used in data warehousing.
Teradata Parallel Transporter
Teradata Parallel Transporter (TPT) is a parallelParallel computing
Parallel computing is a form of computation in which many calculations are carried out simultaneously, operating on the principle that large problems can often be divided into smaller ones, which are then solved concurrently . There are several different forms of parallel computing: bit-level,...
multi-function load environment. It provides 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. Dozens of files can be loaded using a single script. TPT utilizes system resources efficiently by allowing distribution of the workload across CPUs, eliminating bottlenecks in data loading process.
Each user can create a job (that is, a string of TPT 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.
It was designed to use the different Teradata Load and Unload Utilities under a single infrastructure. So, based on the protocols of fastload, multiload, tpump and fastexport, new "operators" were developed and they are named as Load, Update, Stream and Export respectively. Apart from the four operators, there are more operators like Selecto, Inserter, Dataconnector, and ODBC.
Teradata Parallel Transporter is available with Informatica as well.
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, FastExportFastExportFastExport is a computer program released by the company Teradata. The program is the reverse of the Teradata FastLoad. FastExport is a utility that exports large data sets from Teradata tables or views to a client system for processing, generating large reports, or for loading data into a smaller...
, and TPumpTPumpTPump is a Teradata utility designed to continuously move data from data sources into Teradata tables without locking the affected table. TPump provides near-real-time data into data warehouses. TPump can be used to insert, update, upsert, and delete data in the Teradata Database...
Supported 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