Data Transformation Engine Database Interface Designer Reference Guide

Chapter 5 - Database Sources and Targets Using a Database as a Target
Database Interface Designer Reference Guide
94
Using a Database as a Target
After using the Database Interface Designer to define tables, views, message
queues, or stored procedures for a database, use the database to specify the
database adapter as the data target.
To use a database table, view, message queue, or stored procedure as a target
1 Define the database using the Database Interface Designer.
2 Generate a type tree from a table, view, stored procedure, or message queue.
3 Using the Map Designer, create a map with an output card that specifies the
database table, view, message queue, or stored procedure as the data target.
Defining a Database Target in the Map Designer
When you generate the type tree for a table, view, message queue, or stored
procedure, one of the types in the tree is a group representing the contents of the
table, view, message queue, or stored procedure. For example, a type tree
generated for a table or view is named DBTable. Use the Map Designer to select
the appropriate type representing the contents as the output card type of the
executable map.
After you have defined the database and have generated the type tree, using a
database as an output is very similar to using a file as output.
Use the Map Designer to specify Database as the PUT > Target setting in the
output card at the executable map level. Provide the name of the .mdq file
containing the definition of the database, along with the table, view, message
queue, or stored procedure to be used.
To define a database as a target
Note For more information about the map settings in this procedure, refer to the Map
Designer Reference Guide. This procedure will specifically address
database-specific parameters and settings.
1 In the Map Designer, select the To window.
2 From the Card menu, select New.
The Add Output Card dialog box is displayed, an example of which follows.