Data Transformation Engine Database Interface Designer Reference Guide

Chapter 5 - Database Sources and Targets Database Connections and Transactions
Database Interface Designer Reference Guide
96
7 For the PUT > Target setting, select Database from the list.
The settings displayed in the Output Card dialog box change to display the
database adapter settings for a target.
Note For database adapter-specific information about target settings, refer to
the adapter-specific reference guide.
8 Specify the values as desired in the adapter settings and click OK.
Database PUT > Target Settings
After you select Database as the PUT > Target setting and the database adapter
settings for a target become available in the output card, you can configure the
settings for a target that uses the database adapters.
Note Many of the adapter settings provide transactional control and connection
management that allow you to control the connections made to your database. For
information about specifying these particular PUT > Target and TargetRule
settings, refer to Database Connections and Transactions.
PUT > Target > Command Setting
The PUT > Target > Command setting is used to enter the database adapter
commands applicable for this target. For general information about these settings,
refer to the Map Designer Reference Guide. For specific information about using
database-specific adapter commands, refer to the adapter-specific reference
guide.
Database Connections and Transactions
Mercator maps allow superior transactional control and connection management
by providing settings that allow the scope of transactions to be controlled by the
definitions provided in a map. It is important to understand how these connections
to databases are controlled and how this relates to transactional scope.