ODBC Operator Capabilities - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.00
Published
November 2020
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
ric1544831938741.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

The ODBC operator is a producer operator that enables universal open data access to retrieve data from any non-Teradata ODBC-compliant data sources. 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 and possible decreased performance.

The ODBC operator does not support extracting LOB data from the third-party server and loading it to a table. The operator can extract the LOB data, but does not prepare the data in Teradata format, which has 8-byte length preceding the data.

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

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, a Microsoft SQL server, Microsoft Access). Use the UNION ALL statement to combine the imported data, and then use multiple instances of the Update operator to insert/update multiple tables in the database.

The following figure shows the ODBC operator interface.



Database Versions and Bundled DataDirect ODBC Drivers

The ODBC operator is certified with the following ODBC drivers, and requires that a copy of the following drivers be installed on the system from which the Teradata Parallel Transporter job is run.

DataDirect Driver Version Oracle Microsoft SQL Server DB2 PostgreSQL MySQL
7.1.6 n/a 2012, 2014, 2016, 2017 9.1, 10.1, 11.1 8.2, 9.1, 10.1 5.0, 8.0
8.0.2 12c, 18c, 19c n/a n/a n/a n/a