Creating a Job Using the T2T Utility - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.00
Published
December 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
rdo1467305237457.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
You can create a T2T job by defining it as a force_utility and providing a foreign server tag in the job definition.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dmCreate xmlns="http://schemas.teradata.com/dataMover/v2009"
               xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
               xsi:schemaLocation="http://schemas.teradata.com/dataMover/v2009/DataMover.xsd">
               <source_tdpid>sourceSys</source_tdpid> 
               <source_user>source_user</source_user>
               <source_password>source_password</source_password>

               <target_tdpid>targetSyc</target_tdpid>
              <target_user>target_user</target_user>
               <target_password>target_password</target_password>
               <data_streams>1</data_streams>
               <source_sessions>1</source_sessions>
               <target_sessions>1</target_sessions>
               <freeze_job_steps>FALSE</freeze_job_steps>
             <force_utility>T2T</force_utility>
               <use_foreign_server>
                              <name>foreignservername</name>
               </use_foreign_server>
               <log_level>99</log_level>
               <database selection="unselected">
                             <name>db1</name>
                              <table selection="included">
                              <name>tb1</name>        
                              </table>

               </database>
</dmCreate>