15.00 - 15.10 - Load and Unload Utilities - Teradata Database

Teradata Database Introduction to Teradata

Teradata Database
Release Number
Content Type
User Guide
Publication ID
English (United States)
Last Update

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…


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.

Teradata Access Modules

Access modules are adapters that allow all Teradata load and unload utilities to interface with a variety of data sources through standards‑based interfaces. These standards‑based modules let you read from a given data source as if you were reading from a flat file. The following table describes Teradata access modules.


This utility…


Named Pipes Access Module

an inter‑process communication link between a writer process, such as Teradata FastExport, and a reader process, such as Teradata FastLoad.

Teradata Access Module for JMS

a fast, asynchronous method to import and export data between Teradata Database and any JMS‑enabled messaging system. Teradata Access Module for JMS can be invoked by Teradata load and unload utilities.

Teradata OLE DB Access Module

a dynamic link library (DLL) that acts as an interface between Teradata load and export utilities and data sources for which an OLE DB provider is available. The access module quickly moves data between an OLE DB data source and Teradata Database without requiring intermediate storage.

Teradata Data Connector

a software layer between a client utility and an access module. It establishes, maintains, and monitors the connection between a client utility and an access module by being statically linked to the client and dynamically linked to the access module.

Teradata WebSphere MQ Access Module

Teradata utilities to import data using IBM WebSphere MQ message queuing middleware.