Key Features
- JSON Web Token (JWT) authentication
- UDF upload to Teradata Database
- SET TRANSFORM GROUP FOR TYPE support for complex data types (CDT)
Key Changes in Product Behavior
Starting with version 16.20, ODBC Driver for Teradata has a new code base, and many of the features found in previous versions have been completely redesigned. The new driver does not include all of the deprecated features found in previous versions of ODBC Driver for Teradata, and these features have been removed. For more information about the new driver and how its functionality compares to the previous versions of ODBC Driver for Teradata, see Deprecated Features for ODBC Driver for Teradata 16.20 and Later Versions.
This version of ODBC Driver for Teradata includes the following characteristics:
- Deprecated features from the ODBC Driver for Teradata are no longer functional and are not supported in the new driver. There are no workarounds for these procedures, as they are obsolete. For a complete list of obsoleted features which do not work in the new driver, see Deprecated Features for ODBC Driver for Teradata 16.20 and Later Versions.
- Starting with version 15.10.01.x, the Side-by-Side feature requires unique driver names for DSN-less connecting Applications in order to reference the different versions of drivers that may be installed. For more information, see MultiVersion Support.
- ODBC install is self-contained and the installation of other Teradata Tools and Utilities products such as Teradata ICU, Call-Level Interface (CLI), and TeraGSS is not required.
- Installing the ODBC Driver no longer automatically migrates DSNs.
DSNs belonging to the older versions of the driver will not be converted to the newly installed version of the ODBC Driver. See "Driver Migration" below for more information.
- Supports the use of unixODBC and iODBC driver managers. This is in addition to existing support of Progress DataDirect Driver Manager.
- ODBC Driver for Teradata strictly adheres to ODBC specifications. Non-compliant ODBC functions found in old versions of ODBC Driver for Teradata are not supported by the new driver.
- As an important example of adherence to the ODBC specification, you must close the cursor before executing another query or else a cursor error is returned. Previously, you were able to bypass closing the cursor but this is not the correct behavior. This and other differences can be found in ODBC Driver for Teradata 16.20 Compatibility Reference.
- ODBC Driver for Teradata conforms to standard ODBC 3.8 core level specifications.
Differences in Driver Implementation
- Caches, or attempts to cache, up to 2GB of all SLOBs in a row.
- Three configuration parameters:
- 1-Enable SLOB Random Access
- 2-Max size of one SLOB
- 3-Max size of all SLOBs in a row
For more information, and a detailed list of features in the new driver, see ODBC Driver for Teradata 16.20 Features.
Driver Migration
On Windows, if the desired driver is Teradata ODBC DSN:
- Change the key value under HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources from Teradata to Teradata ODBC Driver 16.xx as shown in the figures below.
From
To:
- Also change the key HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\Teradata ODBC DSN\Driver from C:\Program Files (x86)\Teradata\Client\15.10\bin\tdata32.dll to Teradata ODBC Driver 16.xx as shown in the figures below.
From:
To:
The DSN now points to the new driver.
Key Changes in System Behavior
Key Change | Description |
---|---|
16.20 Update 2 | There are no key changes in system behavior for this release. |
16.20 Update 1 | |
ODBC-17927/TDS-99 |
Teradata Database version 16.20 Update 1 has native support for some of the ODBC Scalar functions. Thus, ODBC applications can use these scalar functions outside of the ODBC Escape Sequence syntax when the application is connected to the Teradata Database version 16.20 Feature Update 1 or higher. For a complete list of functions, see "Scalar Functions" in ODBC Driver for Teradata® User Guide (B035-2526-048K) version 16.20, April 2018. |
16.20.00 | |
N/A |
The 16.20 version of ODBC Driver for Teradata has a new code base, and many of the features found in previous versions have been completely redesigned. The new driver does not include all of the deprecated features found in previous versions of the Teradata ODBC Driver, and these features have been removed. For more information about the new driver and how its functionality compares to the previous versions of ODBC Driver for Teradata, see "New Teradata ODBC Driver Compatibility Reference" in ODBC Driver for Teradata® User Guide. This version of ODBC Driver for Teradata includes the following characteristics:
|
Deprecated/Removed Features
There are no deprecated or removed features for this release.