The following example shows how you can use PowerExchange for IBM WebSphere MQ and PowerCenter to process real-time data.

You want to process purchase orders in real-time. A purchase order can include multiple items from multiple suppliers. However, the purchase order does not contain the supplier or the item cost. When you receive a purchase order, you must calculate the total cost for each supplier. You have a master database that contains your suppliers and their respective items and item cost. You use PowerCenter to look up the supplier and item cost based on the item ID. You also use PowerCenter to write the total supplier cost to a relational database.

Your database administrator recommends that you update the target up to 1,000 messages in a single commit. You also want to update the target every 2,000 milliseconds to ensure that the target is always current.

To process purchase orders in real time, you create and configure a mapping.

The following figure shows a mapping that processes purchase orders in real time:

The sample mapping includes the following components:

You create and configure a session and workflow with the following properties:

The following steps describe how the Integration Service processes the session in real-time: