This sample demonstrates the use of graphical data mapping in a simplified retail scenario. The scenario uses a simplified sales data feed instead of the TLOG industry standard, for which a separate product sample is available.
For more information about mapping, see Using graphical data maps.
Scenario:
A retail company, similar to any typical supermarket chain, has multiple stores throughout the world. Stores complete sales transactions each day and stock deliveries keep the shelves full. This keeps the customers happy.
The company originally covered a small area and was therefore able to use a single warehouse to deliver stock to all its stores. It developed a proprietary stock management system that runs overnight and processes files containing stock adjustment records that identify the item, quantity, and store.
As the company grew it was no longer practical to use a single warehouse (depot) to provide stock to its stores, so multiple depots are now located across the geographies that it covers. To simplify stock processing, the company groups the stock adjustment data feed by depot.
In addition to stock management, the company has subsequently introduced a customer loyalty scheme in line with its competitors. The loyalty system that it developed is online all day, so it can accept its data feed at the time the sales transactions occur. This provides added benefits, including the fact that a customer's accrued points can be displayed on each till receipt.
The company has decided to use IBM Integration Bus to integrate the store sales feeds with the stock management and customer loyalty systems. An integration node is used to perform the appropriate data transformations and perform routing and consolidation on the sales data.
The following graphical data mapping capabilities are demonstrated in the transformations used in the solution:
The message flow used is:
The Graphical Data Mapping Loyalty Data Warehousing sample shows the use of Insert and Update transforms to provide a solution to warehouse the Loyalty data produced in this sample scenario.