This topic contains sections marked as revised for this release

WebSphere Message Brokers
File: ar37600_
Writer: Cerys Giddings

Task topic

This build: July 31, 2007 21:36:45

Creating a database to database mapping

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.

Before creating a message map file with a database to database mapping, ensure you do the following:
  1. Create a message flow project
  2. Create a message flow
  3. Define message flow content
  4. Create database definitions

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, you can now 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
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:36:45

ar37600_ This topic's URL is: