Simplified Database Routing sample

The Simplified Database Routing sample is a message flow application based on the scenario of an employee management processing system. You can run the Simplified Database Routing sample by using the supplied self-defining XML messages in the Test Client.

The Simplified Database Routing sample demonstrates how you can use a range of simplified message flow nodes that require no programming. The following nodes are examples of nodes that you can use to perform processing without using any programming:

Route
DatabaseRoute
DatabaseRetrieve

The Simplified Database Routing sample also demonstrates how to access databases by using JDBC, and how to use values held in an acquired result set from a database query, to either dynamically route messages or update their content.

NOTE: In WebSphere Message Broker Version 8.0 and later, message model schema files contained in libraries are the preferred way to model messages for most data formats, including the new DFDL domain. Message sets continue to be supported, and are required if you use the MRM or IDOC domains. You can continue to import and deploy message sets for use in message flows. However, if you need to create one or more message sets, message definitions, or message categories when using this sample, you must first enable message set development in the IBM Integration Toolkit. For more information, see Enabling message set development in the IBM Integration Bus documentation.

Click the following links to find out more about the sample and how to get the prebuilt sample to run by using the wizards. This sample includes step-by-step information so that you can create the Simplified Database Routing sample yourself.

Import and deploy: 5 minutes

Read about the sample

Set up the database

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

Import and deploy the sample
This option imports the sample files into your workspace and deploys the sample to the integration node. This option also sets up additional resources for the sample, for example, WebSphere MQ queues.
Import the sample
This option imports the sample files into your workspace. Additional manual steps might be 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

Build it yourself

When you have finished with the sample, you can remove the database, see Cleaning up the database.

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