Using a database as a target

Edit online

About this task

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:

Procedure

  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.