Teradata load and unload utilities manage your data load requirements from batch to real-time. They are fully parallel to provide optimal and scalable performance for getting data in and out of your database. 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.
| Utility | Description |
|---|---|
| Basic Teradata Query (BTEQ) | General-purpose, command-based tool that enables you to communicate with a database. You can use its interactive or batch interface to submit SQL statements, import and export data, and generate reports. |
| Teradata FastExport | Reads large volumes of data from Vantage. |
| Teradata FastLoad | Quickly loads from client files into empty tables. |
| Teradata MultiLoad | Maintains data, including inserts, updates, and deletions to existing tables. |
| Teradata Parallel Data Pump (TPump) | Continuously updates 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) | Loads data into and unloads data from any accessible table in Vantage or from any other data store that has an access operator or access module. |
| Teradata Parallel Transporter Application Programming Interface (Teradata PT API) | Set of programming interfaces for loading and unloading data to and from Vantage systems. Enables an application to access Vantage using proprietary Teradata load and export protocols. Functional library that is part of your client applications, providing more control during load and unload processes. |