Data Mover supports the QueryGrid T2H utility. In order to use the QueryGrid T2H utility, both the source and target system must have the same QueryGrid version installed and meet the following minimum version requirements:
| QueryGrid | Teradata Database | Data Mover |
|---|---|---|
| 1.0 | 15.00.04.08 | 16.00 |
| 2.0 | 15.10.01.01 | 16.10 |
For more information, see the following QueryGrid user manuals:
- For QueryGrid 1.x: Teradata QueryGrid: Teradata Database-to-Hadoop User Guide, B035-1185
- For QueryGrid 2.x: Teradata QueryGrid Installation and User Guide, B035-5991
- Grant source user permissions on either dbc.serverinfoV or dbc.serverInfoVX – depending on your system view.
- Define a job using T2H as a force_utility using the use_foreign_server tag in the job definition. See Creating a Job Using the T2T or T2H Utility for more information. Note: If a force_utility is not specified, but a valid foreign server is, Data Mover automatically selects T2H to move the data. T2H is not selected if the job consists of entire databases being copied or the tables contain T2H data restrictions.