Teradata load and unload utilities offer a powerful solution for managing all your data load requirements from batch to real-time. Teradata load and unload utilities are fully parallel to provide optimal and scalable performance for getting data in and out of your Teradata Database. In addition, you can import and export data to and from host-based and client-resident data sources, including mainframe host databases, enterprise server databases or departmental data marts. The following table describes Teradata load and unload utilities.
| This utility… | Provides… |
|---|---|
| Basic Teradata Query (BTEQ) | a general-purpose, command-based tool that enables you to communicate with a Teradata Database. BTEQ provides an interactive or batch interface that allows you to submit SQL statements, import and export data, and generate reports. |
| Teradata FastExport | a means of reading large volumes of data from Teradata Database. |
| Teradata FastLoad | high-performance data loading from client files into empty tables. |
| Teradata MultiLoad | high-performance data maintenance, including inserts, updates, and deletions to existing tables. |
| Teradata Parallel Data Pump (TPump) | continuous update of tables; performs insert, update, and delete operations or a combination of those operations on multiple tables using the same source feed. |
| Teradata Parallel Transporter (Teradata PT) | a means to load data into and unload data from any accessible table in Teradata Database or from any other data stores for which an access operator or an access module exists. |
| Teradata Parallel Transporter Application Programming Interface (Teradata PT API) | a set of programming interfaces for loading and unloading data to and from Teradata Database systems. Teradata PT API enables an application to access the Teradata Database using proprietary Teradata load and export protocols. Because Teradata PT API is a functional library that is part of your client applications, it provides more control during the load and unload processes. |