Set Up Foreign Server Location for T2T Jobs | Teradata Data Mover - Foreign Server Location Setup for T2T Jobs

Set Up Foreign Server Location for T2T Jobs | Teradata Data Mover - Foreign Server Location Setup for T2T Jobs - 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

The T2T jobs by default use the foreign server defined on source system. You can guide the T2T jobs to use the foreign server on target system by any of the following methods.

If the specified foreign server does not exist on the specified system you cannot create or run T2T jobs.

In the job definition, add the foreignServerOnTarget attribute to the use_foreign_server element and set the value to true.
For example:
To use foreign server defined on source system:
```
<use_foreign_server>
        <name>myForeignServerOnSource</name>
    </use_foreign_server>
```
To use foreign server defined on target system:
```
<use_foreign_server foreignServerOnTarget="true">       
       <name>myForeignServerOnTarget</name>
    </use_foreign_server>
```

In the configuration.xml file, set the key job.default.foreign.server.on.target value to true. This setting forces all T2T jobs to use foreign server defined on target.

<property>
        <key>job.default.foreign.server.on.target</key>
        <value>true</value>
        <description>Purpose: If set to true Data Mover tries to utilize foreign server on target system for T2T job. The default value is false</description>
    </property>