1.2 TPT Operators and Compatiblities

TPT operators and Existing Utility Equivalents:

Following Table shows TPT operators and Utility equivalents:

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	Data Connector (PIOM)	Reads data from IBM WebSphere MQ
DataConnector operator with Named Pipes Access Module	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)
Load operator	FastLoad	Loads an empty table (high-volume load)
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
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
MultiLoad INMOD Adapter Operator	MultiLoad INMOD Routine	Reads and preprocesses data from a MultiLoad INMOD data source

Teradata Parallel Transporter Compatibilities:

1. Scripts written for Teradata Warehouse Builder Does work with Teradata PT without modification. But new modifications in TPT cannot be applied.

2. Scripts written for Teradata Stand Alone utilities are not compatible with TPT. They need to be rewritten.