Data Transformation Engine Database Interface Designer Reference Guide

Chapter 1 - Introduction Installation
Database Interface Designer Reference Guide
9
Note Non-Windows adapters do not require the Database Interface Designer if you plan
to only use mtsmaker without a database/query file (.mdq) to generate each
type tree. For information about using mtsmaker, refer to the Resource Adapters
Reference Guide.
Installation
This product is installed as one of the components of the Mercator installation
program. Refer to the Getting Started book for details about installing or removing
this product from your system.
Basic Steps for Using Database Data
To use the Database Interface Designer to import database definitions
1 Create a database/query file (.mdq).
2 Define a database.
3 If the database is to be used as an input, define a query for that database.
4 Generate the type tree for the query, table, view, stored procedure, or
message from which or to which you want to map.
5 If the database is to be used as an output, set keys and designate columns for
performing SQL updates.
6 Save the .mdq file.
To use the Map Designer to configure database sources, targets, or operands in
a rule
1 From the input or output card(s) in the executable map, select Database as
the value for either the GET > Source or PUT > Target setting.
2 Select the .mdq file that contains the database-specific source or target
information.
3 Perform the following for an input and/or an output card:
! In an input card, select a query from the .mdq file.
! In an output card, specify a table name or stored procedure.