Graphical Data Mapping Loyalty Data Warehousing sample

The Graphical Data Mapping Loyalty Data Warehousing sample is an extension of the Graphical Data Mapping Retail sample, using a simplified customer loyalty scheme scenario. The sample uses graphical data mapping to perform the required transform in the message flow. The transform takes an input message, and updates or inserts into a database, with a data selection that uses instance data values from the message.

Use the following links to find out more about the sample and how to run the sample.

Import and deploy: 5 minutes

Read about the sample

Detailed explanation of the sample

Set up the database

You can set up the sample in one of the following ways:

NOTE: The Graphical Data Mapping Retail sample is a prerequisite for this sample.

• Import and partially deploy the sample

  This option imports the sample files into your workspace. This option also creates an execution group and WebSphere MQ queues. Use this option if you are not familiar with setting up database tables. An SQL script to set up the tables is imported into your workspace; see Setting up the database tables by using SQL scripts. Run this script before deploying the broker archive (BAR) file to the execution group.

• Import the sample

  This option imports the sample files into your workspace. Additional manual steps are required to configure the sample for testing.

You can import or import and deploy a sample only when you use the information center that is integrated with the IBM Integration Toolkit.

Run the sample

When you have finished with the sample, you can remove the database. See Cleaning up the database for more information.

When you have finished with the sample, you can remove it in one of the following ways:

• Remove the sample from the integration node, but leave its resources in the workspace
• Remove the sample from the integration node and the workspace