This section describes the requirements, access privileges, and other features of HVR when using Teradata for replication. For information about the Capabilities supported by HVR on Teradata, see Capabilities for Teradata.
For information about compatibility and supported versions of Teradata with HVR platforms, see Platform Compatibility Matrix.
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). HVR only supports Teradata ODBC driver version 15.00 or 16.10. HVR also requires Teradata Parallel Transporter(TPT) packages to use HVR Refresh in bulk mode.
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:
This section lists and describes the connection details required for creating Teradata location in HVR.
|The hostname or ip-address of the machine on which the Teradata server is running. |
|The username to connect HVR to the Teradata Node . |
The password of the User to connect HVR to the Teradata Node .
Linux / Unix
Driver Manager Library
|The directory path where the Unix ODBC Driver Manager Library is installed. |
The directory path where the odbcinst.ini file is located.
Teradata TPT Library Path
|The directory path where the Teradata TPT Library is installed. |
|The user defined (installed) ODBC driver to connect HVR to the Teradata server.|
HVR allows you to create hub database in Teradata. The hub database is a small database which HVR uses to control its replication activities. This database stores HVR catalog tables that hold all specifications of replication such as the names of the replicated databases, the list of replicated tables, and the replication direction.
Grants for Hub Database
The following grants are required for hub database:
To perform bulk load (required for Hvrstats), the hub User must be granted create table privilege on the hub database.
To create, update or delete HVR catalog tables, the hub User must be granted select, insert, update and delete privileges on the hub database.
To perform bulk load (required for Hvrstats), the hub User must be granted create macro privilege on the hub database.
Starting HVR Scheduler on Hub
Following is the Linux command line syntax to start HVR scheduler on a Hub with Teradata:
Integrate and Compare
HVR supports integrating changes into Teradata location. This section describes the configuration requirements for integrating changes (using Integrate or HVR Refresh) into Teradata location. HVR also allows you to perform HVR Compare for Teradata database in source location.
Grants for Integrate and Compare
To change/replicate into target tables which are not owned by HVR User (using TableProperties /Schema), the User must be granted select, insert, update, and delete privileges.
To create target tables using Hvrrefresh, the User must be granted create table and drop any table privileges.
To perform bulk load, the User must be granted create macro privilege.