Graphical Data Mapping Loyalty Data Warehousing sample

The Graphical Data Mapping Loyalty Data Warehousing sample uses a simplified customer loyalty scheme scenario. This sample is an extension of the Graphical Data Mapping Retail Sample. The extension sample selects from, inserts, and updates rows in a database.

For more information about mapping, see Using graphical data maps.

Scenario:

A retail business implements a customer loyalty scheme where a customer can collect points based on their purchases.

The loyalty system is online during business hours, so that it can accept a data feed from sales transactions. This provides added benefits, such as displaying a customer's accrued points on their till receipt.

The retail business decided to use IBM Integration Bus to integrate the store sales feeds with the customer loyalty systems. An integration node performs the appropriate data transformations, routing and consolidation of the sales data.

The following graphical data mapping capabilities are demonstrated by the transformations used in the solution:

Repeating structures
Calling XPath functions
Updating and inserting rows in a database

For a detail explanation of the map, see Detailed explanation of the Graphical Data Mapping Data Warehousing sample.

The message flow used is:

Diagram of the message flow, showing LOYALTYDATA.in input to Loyalty Data to Database, and LOYALTYDATA.out as its output

The message flow behaviour is as follows:

An XML LoyaltySalesData message enters the message flow through the LOYALTYDATA.IN input node.
The Loyalty Data to Database mapping node maps the input data in to the database and creates an output XML LoyaltySalesDataOut message.
The message then enters the LOYALTYDATA.OUT node and the output message is placed on the queue.

Back to sample home