ODBC Operator Capabilities | - ODBC Operator Capabilities - Parallel Transporter

Teradata® Parallel Transporter Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
IntelliFlex
Lake
Enterprise
VMware
Product
Parallel Transporter
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2023-12-06
dita:mapPath
mjn1691132485167.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ogv1478610452101
lifecycle
latest
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 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.

  • Due to Progress DataDirect's lack of support for the MacOS platform, the ODBC operator is not officially supported on MacOS.
  • Due to Progress DataDirect's lack of support for the Linux ARM platform, the ODBC operator is not supported on Linux ARM.

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:



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
8.0.2 12c, 18c, 19c 2012, 2014, 2016, 2017, 2019 9.1, 10.1, 11.5 8.2, 9.1, 10.1, 13.3, 14, 15 5.0, 8.0.26