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


Technical solution

You can use a message map to enhance an existing message with data from one or more database tables. Data from the database can then be used to enrich, route, and transform messages within IBM® Integration Bus.

In IBM Integration Bus, to connect to a database, you must configure the development environment and the IBM Integration Bus runtime environment:
  1. To have visibility of the database resources during the development phase, you must connect the IBM Integration Toolkit to the development database.
  2. To enable the deployed map to execute in the run time, you must create a JDBC provider configurable service that defines the connection to the runtime database. This database is normally a different database server from the one you use for development, and the artifacts could be in a different database schema.
To configure the IBM Integration Toolkit to connect to a database, you must create a database definition file in a data design project, and configure a database connection.

To access information stored in a database from resources in a IBM Integration Bus project, you must include a reference to the data design project in your application, service, or Message Broker project.

In IBM Integration Bus, you can use a message map to access information in a database, and then use this information to perform transformations on the message or to enrich a message.

During the design phase, you must complete the following steps in the IBM Integration Toolkit to access graphically database information in a message map:
  1. Add a reference to each database table from where you must retrieve data.
  2. Use a Select transform to define how to use the database information in the message map. The Select transform has embedded a nested map. You must define the transforms in this nested map.
  3. Use a Failure transform to handle database failures. The Failure transform has embedded a nested map. You can define the transforms in this nested map if you wish to provide specialized handling of any database exceptions that are hit running the generated SQL statements when the map executes. If you take the default of not adding a Failure transform, IBM Integration Bus will handle the error, reporting it to the system log, and then rolling back the current message transaction.

To configure the IBM Integration Bus run time to connect to a database, you must establish a connection with the database to fulfill the operations that are performed by the Mapping node. You must define a JDBC provider configurable service.

Use this scenario to learn how to use a Mapping node to connect to a database, retrieve data from multiple tables, populate elements in a SOAP message with this information, and handle a database SQL exception. use this scenario to also learn how to configure the JDBC provider configurable service.


scnmap_02_04_.htm | Last updated 2015-05-28 20:19:33