Running the Graphical Data Mapping Loyalty Data Warehousing sample

The Graphical Data Mapping Loyalty Data Warehousing sample contains a single message flow with a single message transformation that inserts or updates a database and provides a confirmation reply message. The transform and database update is implemented using graphical data mapping.

How to run the Graphical Data Mapping Loyalty Data Warehousing Sample message flow

1. From a DB2 command prompt, run the command:
   

   CONNECT TO RETAILDB

2. Then run the command:
   

   SELECT * FROM LOYALTY

   This shows you the contents of the LOYALTY table in the database.
3. In the Integration project GraphicalDataMappingLoyaltySampleApplication, open GraphicalDataMappingLoyaltySampleApplication.mbtest under Flow Tests. It contains an XML input message containing loyalty sales information.
4. Select the message you want to test, to either insert a new record or update an existing record.
5. Click Send message to put the message in the Loyalty Data MQInput node GDMRETAILOUT queue.
6. The input message is transformed into a XML LoyaltySalesDataOut message and is written to the LOYALTY table in the RETAILDB database.
7. To check how the test ran, review the response message and also run the following command:
   

   SELECT * FROM LOYALTY

   This will show the database and any effect the flow message had after your update.

Back to sample home