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, Simba, 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.
Using the ODBC operator requires that a copy of the following drivers to be installed on the system from which the Teradata PT job is run.
- DataDirect ODBC driver version 5.3 or above.
- Simba ODBC driver version 1.0 or above.
- MS SQL Server ODBC driver version 11 or above.
- Oracle Native ODBC driver version 11 or above.
Even though the ODBC operator can communicate with the Teradata Database, it is more efficient to use either the Export operator or the SQL Selector operator to extract data from the Teradata Database because these operators use the Teradata Call-Level Interface (CLIv2). The Export operator is the fastest way to extract data from the Teradata 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 Teradata Database.
The following figure shows the ODBC operator interface.