Sample Job Creation | XML File | Teradata Data Mover - Sample Job Creation XML File - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.05
Published
October 2020
Language
English (United States)
Last Update
2020-11-18
dita:mapPath
xxl1591023586203.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem

The following sample XML illustrates the correct order of all possible elements available for a job creation XML file.

Refer to this sample XML before creating a job.

<?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/unity/datamover.xsd">
    <job_name>datamovertest</job_name>
    <source_tdpid>dmdev</source_tdpid>
    <source_user>dmguest</source_user>
    <source_password>please</source_password>
    <source_password_encrypted></source_password_encrypted>
    <source_logon_mechanism></source_logon_mechanism>
    <source_logon_mechanism_data></source_logon_mechanism_data>
    <source_account_id></source_account_id>
    <source_session_charset></source_session_charset>
    <target_tdpid>dmsmp2</target_tdpid>
    <target_user>dmguest</target_user>
    <target_password>please</target_password>
    <target_password_encrypted></target_password_encrypted>
    <target_logon_mechanism></target_logon_mechanism>
    <target_logon_mechanism_data></target_logon_mechanism_data>
    <target_account_id></target_account_id>
    <target_session_charset></target_session_charset>
    <use_userid_pool>false</use_userid_pool>
    <data_streams>1</data_streams>
    <source_sessions>1</source_sessions>
    <target_sessions>1</target_sessions>
    <max_agents_per_task>1</max_agents_per_task>
    <response_timeout>100</response_timeout>
    <sync>true</sync>
    <overwrite_existing_objects>true</overwrite_existing_objects>
    <freeze_job_steps>false</freeze_job_steps>
    <force_utility>tptapi</force_utility>
    <staging_database>
        <name>dmguest</name>
    </staging_database>
    <staging_database_for_table>
        <name>dmguest</name>
    </staging_database_for_table>
    <target_database>
        <name>dmguest</name>
    </target_database>
    <log_level>0</log_level>
    <online_archive>false</online_archive>
    <log_to_event_table>tmsmevent</log_to_event_table>
    <database selection="unselected" replaceDatabase="true">
        <name>dmguest</name>
        <staging_database>
          <name>dmguest</name>
        </staging_database>
        <staging_database_for_table>
          <name>dmguest</name>
        </staging_database_for_table>
        <target_database>
          <name>dmguest</name>
        </target_database>
        <compare_ddl>TRUE</compare_ddl>     
        <table selection="included" copyStats="false">
            <name>ppiorders</name>
            <staging_database>
               <name>dmguest</name>
            </staging_database>
              <staging_database_for_table>
                <name>dmguest</name>
              </staging_database_for_table>
              <force_target_staging_table>false</force_target_staging_table>
              <target_database>
                <name>dmguest</name>
              </target_database>
              <target_name>table8_clone</target_name>
              <validate_row_count>all</validate_row_count> 
              <override_lock_access>false</override_lock_access>
              <export_without_spool>true</export_without_spool>
              <compare_ddl>TRUE</compare_ddl>              
              <sql_where_clause><![CDATA[ WHERE ORDERDATE > '2003-01-23' ]]></sql_where_clause>
              <key_columns>
                <key_column>ORDERDATE</key_column>
              </key_columns> 
              <staging_to_target>insert_only</staging_to_target>
        </table>
        <table selection="included" copyStats="false">
            <name>employee</name>
            <compare_ddl>true</compare_ddl>
        </table>
    </database>
    <triggers>
    <trigger selection="included">
       <database>dmguest</database>
       <subject_table_database>dmguest</subject_table_database>
       <table>employee</table>
       <name>TestTrigger</name>
       <action_time enabled="NO">BEFORE</action_time>
    </trigger>
    </triggers>
    <indices>
        <index selection="included" copyStats="false">
            <name>Orders_HI</name>
            <target_name>orders_HI_new</target_name>
            <index_database>dmguest</index_database>
            <index_type>HASH_INDEX</index_type>
        </index>
    </indices>
    <views>
        <view selection="included" copyData="true">
          <name>testview</name>
	      <database>dmguest</database>
	      <view_data_table>
	          <target_table>TargetTable</target_table>
	          <target_database>dmguest</target_database>
	      </view_data_table>
          <staging_database>
	          <name>dmguest</name>
	      </staging_database>
          <staging_database_for_table>
              <name>dmguest</name>
          </staging_database_for_table>
          <force_target_staging_table>false</force_target_staging_table>
          <validate_row_count>all</validate_row_count>
          <compare_ddl>true</compare_ddl>
          <sql_where_clause><![CDATA[  WHERE "test2"."C1" > 500 ]]></sql_where_clause>
          <key_columns>
   		   <key_column>C1</key_column>
          </key_columns>
        </view>
    </views>
    <foreign_servers>
       <foreign_server selection="included" >
           <name>FSObj</name>
           <map>map1</map>
           <colocate>col1</colocate>
        </foreign_server>
    </foreign_servers>
    <function_aliases>
        <function_alias selection="included" >
            <name>dmguest</name>
            <database>faObj</database>
        </function_alias>
    </function_aliases>
    <macros>
	<macro selection="included"> 
		<name>macro_employee</name>  
		<database>dmguest</database> 
	</macro> 
    </macros>
    <stored_procedures>
	<stored_procedure selection="included"> 
		<name>getEmpInfo</name>  
		<database>dmguest</database> 
	</stored_procedure> 
    </stored_procedures>
    <uowid>test</uowid>
    <query_band>AppName=B;</query_band>
</dmCreate>