Implementing the solution for the scenario to enrich a message with data from a database

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 IBM® App Connect Enterprise 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 JDBC Providers policy.

Before you begin

  1. Create the initial configuration. For more information, see Creating the scenario graphical data map configuration.
  2. Create the database resources. For more information, see Creating the scenario database configuration.

Procedure

Complete the following steps to implement a Mapping node that connects to a database and enriches a message with the database information:

  1. Configure the database physical model in IBM App Connect Enterprise by running discovery. For more information, see Configuring a database in the IBM App Connect Enterprise Toolkit.
  2. Configure your integration solution to include the database connection details. For more information, see Configuring an integration solution to access database resources.
  3. Add the relevant database tables to your message map. For more information, see Adding database tables your message map.
  4. 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.
  5. Optional: Handle database failures. For more information, see Handling database failures in a Select transform.
  6. 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.