Teradata Requirements - DSS 6 | Data Source Solutions Documentation
Documentation: Teradata Requirements - DSS 6 | Data Source Solutions Documentation
Teradata Requirements
This section describes the requirements, access privileges, and other features of Data Source Solutions DSS when using Teradata (Database or Vantage) for replication.
Supported Platforms
- Learn about the Teradata versions compatible with DSS on our Platform Support Matrix page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
Supported Capabilities
- Discover what DSS 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 DSS 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 DSS supports for Teradata on the Supported Character Encodings page.
ODBC Connection
DSS 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 DSS release notes (dss.rel) available in the DSS_HOME directory or the download page.
DSS 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 |