Start of change

Creating a database to database mapping

Before you start:
  1. Create a message flow project
  2. Create a message flow
  3. Define message flow content

You can create a message map that uses a database as both the source and target. The contents of the source database can be used to interact with the same or a different database table. The message map can also include a message as a source, but a message is not required. You can, for example, use a timer node to schedule regular updates to a database. To create a database to database mapping:

  1. Right-click a node that supports database mapping in your flow, such as the Mapping node, and click Open Map. The New Message Map wizard opens for your node.
  2. Select the Data Sources and any Messages that you want to use as sources for your map from Select map sources.

    If you cannot find the Messages or Data Sources that you expect, select the Show all resources in workspace check box.

  3. From Select map targets expand the database operation that you want to perform. You can select from the following database operations:
    • Table Inserts
    • Table Updates
    • Table Deletes
  4. Select the database tables that you want to map.

    You can create a message map that performs a combination of database inserts, updates or deletes by selecting database tables from different database operations. For example, if you want to create a conditional mapping that updates data in a database if it already exists, but inserts the data if it does not already exist in the database, then you can select the same database table under Table Inserts and Table Updates.
  5. Select OK to create the new message map. The Message Mapping editor opens with the selected sources and targets.
After you have created a message map file, configure the message mappings.
Related concepts
Message Mapping editor
Related tasks
Creating a message map file in the Broker Development view
Change database operation of a message map
Configuring message mappings
Related reference
Message mappings
Mapping node
End of change