16.10 - ODBC Operator Capabilities - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

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.

The Simba ODBC driver is only supported for Oracle and MongoDB. The Simba MongoDB driver is only available on Windows.

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.
The MS SQL Server ODBC drver is only supported for SQL Server. The MS SQL Server driver is only available on Windows and Linux.
The ODBC operator supports only Oracle on OS X; it is not supported by OpenLink DB2 and SQL server drivers.
The ODBC operator does not support extracting LOB data from the third-party server and loading it to Teradata 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 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.

ODBC Operator Interface