Loading and Unloading Data

vrm_release
-NA-
created_date
February 2020
category
Fast Facts
featnum
FF-0006

Loading and Unloading Data

Teradata offers several tools to load and unload data. Use the tool that best matches your needs.

Tool Description
Teradata Parallel Transporter (TPT) Use TPT operators to batch load and unload table data from various data sources.
  • Combines the functionality of the FastLoad, MultiLoad, FastExport, and TPump protocols into a single parallel framework, using operators, to load and unload table data. Use TPT instead of the following deprecated Teradata tools: FastLoad, MultiLoad, FastExport, and TPump
  • Integrated APIs to interface with ETL tools and custom applications
  • Perform block transfers with multisession parallelism
  • Load data from multiple input source files at a high throughput
  • Multiple operators run in parallel independent of each other, further increasing throughput
Teradata Tools and Utilities Access Modules Use with TPT to load and unload data from various data sources.
  • Encapsulates the details of various data stores
  • Primary function is to provide TPT with transparent and uniform access to various data sources
  • Users can create custom access module to connect to TPT
  • Teradata provided Access Modules:
    • S3
    • Azure Blob
    • Kafka
    • JMS
    • Websphere MQ
    • Named Pipe
    • OLE DB
Basic Teradata Query (BTEQ) Enables workstation and mainframe users to submit SQL statements and BTEQ commands in batch or command-line interactive mode.
  • Formats and returns the results to the screen, a file, or a designated printer
  • Use for ad-hoc import and export of small datasets
Deprecated
Tool Description
Teradata FastLoad Deprecated – use TPT instead
Teradata MultiLoad Deprecated – use TPT instead
Teradata Parallel Data Pump (TPump) Deprecated – use TPT instead
Teradata FastExport Deprecated – use TPT instead

Teradata Vantage™ is our flagship analytic platform offering, which evolved from our industry-leading Teradata Database. Until references in content are updated to reflect this change, the term Teradata Database is synonymous with Teradata Vantage. Advanced SQL Engine is a core capability of Teradata Vantage, based on our best-in-class Teradata Database. Advanced SQL refers to the ability to run advanced analytic functions beyond that of standard SQL.