Basic steps for using database data

Edit online

About this task

The following is a high-level description of the steps required to use database data.

To use the Database Interface Designer to import database definitions

Edit online

Procedure

  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

Edit online

Procedure

  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.