Specify Staging and Target Values at System Level | Teradata Data Mover - 17.11 - System Level Specification Using the save_configuration Command - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-4101-091K
Language
English (United States)

You can also specify values for staging and target database tags at the system level. Specify at the system level by executing the save_configuration command, the same command used to set other Data Mover configuration properties.

When staging_database, staging_database_for_table, source_staging_database, target_staging_database, and target_database tag values are specified at the system level, Data Mover applies them to all table objects included in the job request.

A property named system.default.database.enabled controls the system level default values for the target and staging databases. For each target system, you can set three values for the default databases. Within the systemLevelDatabase element, the system tag is mandatory and the databases tags are all optional. The following is an example of the new property in the save_configuration XML file:

<property>
	<key>system.default.database.enabled</key>
	<value>true</value>
	<defaultDatabases>
		<systemLevelDatabase>
			<system>targetSystem1</system> <!-- Tdpid here -->
			<source_staging_database>stagingDB1</source_staging_database>
			<!--target_staging_database>stagingDB1</target_staging_database--> 
			<staging_database>stagingDB1</staging_database>
			<staging_database_for_table>stagingDBForTable1</
staging_database_for_table>
			<target_database>targetDB1</target_database>
		</systemLevelDatabase>
		<systemLevelDatabase>
			<system>targetSystem2</system>
			<!-- only specify the target database for targetSystem2 -->
			<target_database>targetDB2</target_database>
		</systemLevelDatabase>
	</defaultDatabases>
		<description>Purpose: Enable/Disable the default target/staging
databases at the system level. Default value false means disabled.</
description>
</property>