During the development phase, you can use a Mapping node
to connect to a database, retrieve data from multiple tables, and
then populate elements of a SOAP message. During the design of the
map, you can connect the WebSphere® Message
Broker Toolkit to
a database to discover the tables. To enable the run time to establish
a connection with the database to fulfill the operations that are
performed by the Mapping node,
you must create a JDBCProvider configurable service.
Procedure
Complete the following steps to implement a Mapping node
that connects to a database and enriches a message with the database
information:
- Configure the database physical model in WebSphere Message Broker by running
discovery. For more information, see Configuring a database in the WebSphere Message Broker Toolkit.
- Configure your integration solution to include the database
connection details. For more information, see Configuring an integration solution to access database resources.
- Add the relevant database tables to your message map. For
more information, see Adding database tables your message map.
- Configure the Select transform in
your message map to retrieve the database information. For more information,
see Configuring the Select transform in a message map.
- Optional: Handle database failures. For more
information, see Handling database failures in a Select transform.
- Configure the run time to enable it to establish a connection
with the database to fulfill the operations that are performed by
the Mapping node.
For more information, see Configuring a database to be available at run time.