Teradata Requirements
This section describes the requirements, access privileges, and other features of Fivetran HVR when using Teradata (Database or Vantage) for replication.
Supported Platforms
- Learn about the Teradata versions compatible with HVR on our Platform Support Matrix page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
Supported Capabilities
- Discover what HVR offers for Teradata on our Capabilities for Teradata page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
Data Management
Learn how HVR maps data types between source and target DBMSes or file systems on the Data Type Mapping page. For the list of the supported Teradata data types and their mapping, see Data Type Mapping for Teradata.
Understand the character encodings HVR supports for Teradata on the Supported Character Encodings page.
ODBC Connection
HVR 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 HVR release notes (hvr.rel) available in the HVR_HOME directory or the download page.
HVR 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 |