To configure the foreign server on the source system:
- Follow the instructions in Teradata® QueryGrid™ Installation and User Guide, B035-5991 to configure QueryGrid.
- Configure the proxy user and physical user on the target system to run T2T tasks, using the same physical user on the source system.
- Connect the physical user to the proxy user on the target system.
- Create an authorization and foreign server on the source system, ensuring that the source user has insert and select permissions on the foreign server.
- Grant source user permissions on either dbc.serverinfoV or dbc.serverInfoVX – depending on your system view.
- Logon to the source system as a source user and run the following two queries:
- Help foreign server <foreign_server_name>;
- Select * from <db_name>.<table_name>@<foreign_server_name>;
If you can run the queries without any issue, then the foreign server configuration completes successfully. - [Optional] Group pool is available with the T2T utility provided that all users are configured properly on both source and target systems. If you need to configure a group pool, follow these steps:
- Create a list of the same physical users on both the source and target systems.
- Create one proxy user on the target system and connect the physical user to the proxy user on the target system.
- Grant the physical users insert and select permissions to the foreign server on source system.
- Grant the physical users permissions on dbc.serverinfoV or dbc.serverInfoVX on source system.
- Add the source users to a group pool in the source system. The same set of users created on the target system do not necessarily need to be added to the group pool on target system.
- Define a job using T2T as a force_utility using the use_foreign_server tag in the job definition. For more information, see Creating a Job Using the T2T Utility.If a force_utility is not specified, but a valid foreign server is, Data Mover automatically selects T2T to move the data. T2T is not selected if the job consists of entire databases being copied or the tables contain T2T data restrictions.