Defining Producer Operators|TPT - Defining Producer Operators - Parallel Transporter

Teradata® Parallel Transporter User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Parallel Transporter
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-08-25
dita:mapPath
uzp1645128359760.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
Product Category
Teradata Tools and Utilities

Producer operators “produce” a data stream after reading data from a database or an external data store. Then they write the data into the data stream for further processing by consumer or filter operators.



A Teradata PT job script allows as many producer operators as data sources, as long as the output schema is the same; or you can use a single producer. The producer extracts data from the source and places it into the data stream, where other operators can use it.

Following is a list of Teradata PT producer operators:

Operator Description
Produces Data from a Database
Export The Export operator extracts data from database tables and writes it to the data stream. The Export operator functions in a way similar to the standalone FastExport utility protocol.
SQL Selector Selects data from database tables using SQL sessions. The only producer operator that can handle LOB, JSON, and XML data.
Produces Data from a Non-Database Data Source
DataConnector (producer) The DataConnector operator accesses files either directly or through an access module, and then writes it to the data stream.

The DataConnector operator can also read data from files and tables in Hadoop.

ODBC The ODBC operator extracts data from ODBC-compliant databases, such as Oracle SQL Server on Windows, UNIX, and z/OS platforms, and then writes it to the data stream. For the list of the supported ODBC-compliant databases, see "ODBC Operator" in Teradata® Parallel Transporter Reference, B035-2436.
Produces and Processes Data from a Non-Database Data Source
FastLoad INMOD Adapter The FastLoad INMOD adapter uses FastLoad INMOD routines to read and preprocess input data from flat files, and then places it in the data stream.
MultiLoad INMOD Adapter The MultiLoad INMOD adapter uses MultiLoad INMOD routines to read and preprocess input data from flat files, and then places it in the data stream.