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 |