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


Introduction to the "Simplifying message flows by using stored procedures" scenario

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:

  1. You connect to a database, and create a stored procedure that selects columns from different tables.
  2. You deploy the procedure to the database, and test it.
  3. You then import a message flow, and discover the stored procedure that you created for your database mapping.
  4. Finally, you test the message flow in the IBM Integration Bus test tool.

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.

What to do next

  1. Read the following topics to understand the scenario and the concepts that the scenario demonstrates:
  2. Implement the solution.

sp_01_02_.htm | Last updated 2015-11-25 08:25:31