Data Transformation Engine Database Interface Designer Reference Guide

Chapter 5 - Database Sources and Targets Using a Database as a Source
Database Interface Designer Reference Guide
93
3 For the CardName setting, enter a name for the card that describes the data
object represented by this card.
4 For the TypeTree setting, select the type tree containing the group type that
defines the desired query.
5 For the TypeName setting, select the group type from the type tree that
defines the desired query (for example,
DBSelect).
6 For the TypeName setting, select the group type from the type tree that
defines the desired query (for example,
DBSelect).
7 Specify the FetchAs, WorkArea, FetchUnit, and all Backup settings as
desired. For detailed information about these settings, refer to the Map
Designer Reference Guide.
Note For database adapter-specific information about source settings, refer to
the adapter-specific reference guide.
8 For the GET > Source setting, select Database from the list.
The SourceRule settings change to display the database adapter settings.
9 Specify the values as desired in the adapter settings and click OK.
Database GET > Source Settings
After you select Database as the GET > Source setting and the database
adapter settings become available for an input, configure the settings for a source
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 GET > Source and SourceRule
settings, refer to Database Connections and Transactions.
GET > Source > Command Setting
The GET > Source > Command setting is used to enter the applicable database
adapter commands for this source. 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 Resource Adapters Reference
Guide.