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

Product

Teradata Data Mover

Release Number

17.20

Published

September 2022

Language

English (United States)

Last Update

2022-09-26

dita:mapPath

tsn1650877444606.ditamap

dita:ditavalPath

mpm1591127278842.ditaval

dita:id

B035-4101

lifecycle

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>