Teradata Requirementslink
Updated 12 days ago
This section describes the requirements, access privileges, and other features of Fivetran Local Data Processing when using Teradata for replication.
For information about compatibility and supported versions of Teradata with Local Data Processing platforms, see Supported Platforms.
For the Capabilities supported by Local Data Processing on Teradata, see Capabilities for Teradata.
For information about the supported data types and mapping of data types in source DBMS to the corresponding data types in target DBMS or file format, see Data Type Mapping.
For the character encodings supported by Local Data Processing on Teradata, see the Character Encodings page.
ODBC Connectionlink
Local Data Processing uses ODBC connection to the Teradata server for which it requires the Teradata ODBC driver installed on the machine from which it connects to the Teradata server. For information about the supported ODBC driver version, refer to the Local Data Processing release notes (hvr.rel) available in the HVR_HOME directory or the download page.
Local Data Processing also requires Teradata Parallel Transporter(TPT) packages to perform Bulk Refresh.
Teradata ODBC driver and TPT packages can be installed using Teradata Tools and Utilities (TTU) package. TTU 16.10 is available for Linux and Windows on Teradata download page, and TTU 15.00 is available for download from Teradata Support Portal (requires user authentication).
The following action definitions are required for TTU to find the correct message files:
| Group | Table | Action | Parameter(s) | Annotation |
|---|---|---|---|---|
| Teradata | * | Environment | Name=NLSPATH | |
| Teradata | * | Environment | Value="/opt/teradata/client/teradata_version/odbc_64/msg/%N:/opt/teradata/client/teradata_version/tbuild/msg/%" | For Teradata 15.00 |
| Teradata | * | Environment | Value="/opt/teradata/client/teradata_version/odbc_64/msg/%N:/opt/teradata/client/teradata_version/msg/%N" | For Teradata 16.10 and higher |