Discover how to enhance a message in IBM® Integration Bus by using a stored procedure to access data from multiple database tables.
In this scenario, you investigate the Mapping node and its support for database stored procedures. You learn about the benefits of using stored procedures, which simplify mapping. You use the tools that IBM Integration Bus provides for creating, deploying, and implementing stored procedures. After you create the initial database, you use IBM Integration Bus for each of the following steps:
Typically, a WebSphere® Integration Developer gets involved at step 3, after a database administrator has completed steps 1 and 2. To demonstrate the tools that IBM Integration Bus provides to interact with databases, the scenario includes all steps.