IBM Integration Bus, Version 10.0.0.2 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS


Context

This scenario shows how you can enhance a message in IBM® Integration Bus by using a message map. In this scenario, the data is available in an external database system. The data is stored across multiple database tables, all of which are located within the same database schema.

Your company has implemented an AddressBook service that is used by different departments in different countries in your organization. This service allows your employees to obtain a client's mail address or to save a new client's mail address.

This figure shows the AddressBook service being used by three departments.

The company uses IBM Integration Bus to develop and manage a number of integration solutions that transform and communicate data between source and target systems. In order to make the service reusable by multiple applications, you design an application responsible for the transformation of the different address formats between the requesting application and the AddressBook service. The AddressBook service is a SOAP-based service that stores a new address or returns an address to the user. You use a message map to define how to transform the SOAP message based on the operation that your user requests.

The company uses DB2® Version 9.7 as the external database system that hosts client's details and addresses.

The scenario uses the following database tables:
In IBM Integration Bus, you have the following choices to implement a message flow that connects to a database, and retrieves information to enrich the message:

This scenario demonstrates how to use a Mapping node to connect to a database, retrieve data from multiple tables, and graphically populate elements in a SOAP message with this information in the IBM Integration Toolkit.


scnmap_02_03_.htm | Last updated 2015-09-24 12:22:46