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

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Published
October 2021
Language
English (United States)
Last Update
2021-10-14
dita:mapPath
cai1626458602965.ditamap
dita:ditavalPath
cai1626458602965.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem

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>