System Level Specification Using the save_configuration Command - 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 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, and target_database tag values are specified at the system level, Data Mover applies them to all table objects included in the job request. If these values are supported for non-table objects, you must specify them at the object level.

A new 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. Here 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 -->
			<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>