ODBC Operator Capabilities - Parallel Transporter

The ODBC operator is a producer operator that enables universal open data access to retrieve data from any non-Teradata ODBC-compliant data source. The ODBC operator is optimized and certified to work with Progress DataDirect, MS SQL Server, and Oracle native ODBC drivers. Attempting to use this operator with any other ODBC driver may have unexpected results, lack of functionality and possible decreased performance.

Even though the ODBC operator can communicate with the Teradata RDBMS, it is more efficient to use either the Export operator or the SQL Selector operator to extract data from the Teradata RDBMS because these operators use the Teradata Call-Level Interface (CLIv2), which is more efficient. The Export operator is the fastest way to extract data from the Teradata RDBMS.

The ODBC operator also provides parallel access to different data sources. For example, in a single job script, you can use multiple ODBC operators to read from multiple data sources such as an Oracle server and a Microsoft SQL server. This is performed using the UNION ALL statement to combine the imported data.

The following figure shows the ODBC operator interface.