15.10 - Teradata PT and the Teradata Utilities - Parallel Transporter

Teradata Parallel Transporter User Guide

prodname
Parallel Transporter
vrm_release
15.10
category
User Guide
featnum
B035-2445-035K

Teradata PT and the Teradata Utilities

Teradata PT replaces the Teradata Utilities. For example, instead of running FastLoad, Teradata PT uses the Load operator. Instead of running MultiLoad, Teradata PT uses the Update operator.

Table 1 compares Teradata PT operators with Teradata utilities.

 

Table 1: Comparison of Teradata PT Operators and Teradata Utilities 

Teradata PT Operator

Utility Equivalent

Purpose

DataConnector operator

Data Connector (PIOM)

Reads data from and writes data to flat files

DataConnector operator with WebSphere MQ© Access Module

same with Data Connector (PIOM)

Reads data from IBM WebSphere MQ

DataConnector operator with Named Pipes Access Module

same with Data Connector (PIOM)

Reads data from a named pipe

DDL operator

BTEQ

Executes DDL, DCL, and self-contained DML SQL statements

Export operator

FastExport

Exports data from Teradata Database (high-volume export)

FastExport OUTMOD Adapter operator

FastExport OUTMOD Routine

Preprocesses exported data with a FastExport OUTMOD routine before writing the data to a file

FastLoad INMOD Adapter operator

FastLoad INMOD Routine

Reads and preprocesses data from a FastLoad INMOD data source

Load operator

FastLoad

Loads an empty table (high-volume load)

MultiLoad INMOD Adapter operator

MultiLoad INMOD Routine

Reads and preprocesses data from a MultiLoad INMOD data source

ODBC operator

OLE DB Access Module

Exports data from any non-Teradata Database that has an ODBC driver

OS Command operator

Client host operating system

Executes host operating system commands

SQL Inserter operator

BTEQ

Inserts data into a Teradata table using SQL protocol

SQL Selector operator

BTEQ

Selects data from a Teradata table using SQL protocol

Stream operator

TPump

Continuously loads Teradata tables using SQL protocol

Update operator

MultiLoad

Updates, inserts, and deletes rows