Configure Foreign Server on Target System | Teradata Data Mover - Configuring Foreign Server on Target System - Teradata Data Mover

Teradata® Data Mover User Guide - 20.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.01
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
hlv1700545853003.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
don1467241476387
Product Category
Analytical Ecosystem

To configure the foreign server on the target system:

  1. Follow the instructions in Teradata® QueryGrid™ Installation and User Guide, B035-5991 to configure QueryGrid.
    1. Configure the proxy user and physical user on the source system to run T2T tasks, using the same physical user on the target system.
    2. Connect the physical user to the proxy user on the source system.
    3. Create an authorization and foreign server on the target system, ensuring that the target user has insert and select permissions on the foreign server.
  2. Grant target user permissions on either dbc.serverinfoV or dbc.serverInfoVX – depending on your system view.
  3. Logon to the target system as a target user and run the following two queries:
    1. Help foreign server <foreign_server_name>;
    2. 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.
  4. [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:
    1. Create a list of the same physical users on both the source and target systems.
    2. Create one proxy user on the source system and connect the physical user to the proxy user on the source system.
    3. Grant the physical users insert and select permissions to the foreign server on target system.
    4. Grant the physical users permissions on dbc.serverinfoV or dbc.serverInfoVX on target system.
    5. Add the target users to a group pool in the target system. The same set of users created on the target system do not necessarily need to be added to the group pool on source system.
  5. 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.