Configuring a database to be available at run time

To make database information accessible at run time, you must establish a connection with the database to fulfill the operations that are performed by the Mapping node. You must define a JDBC database connection.

About this task

The IBM® App Connect Enterprise Toolkit connects to the database CLIENTS and runs discovery so that the graphical data mapping editor can use the database definition to visualize the database tables PERSON, ADDRESS, and PHONE.

At run time, the Mapping node uses a JDBC Providers policy (in the integration server's default policy project) to obtain the configuration parameters that will enable it to make the connection to the runtime database that the message map will execute against.

Procedure

To configure the JDBC connection between the IBM App Connect Enterprise run time and the runtime database, you must complete the following steps:

  1. Create a JDBC Providers policy, as described in Configuring a JDBC Providers policy for the scenario to enrich a message with data from a database.

    The JDBC Providers policy provides the IBM App Connect Enterprise run time with the information that it needs to complete the connection to the runtime database.

    For more information, see Setting up a JDBC provider for type 4 connections.

  2. Set up security, as described in Securing the JDBC Providers policy for the scenario to enrich a message with data from a database.

    Some databases require access to be associated with a known user ID and password, for other, this association is optional. A DB2 database requires a data source login name and password on all connections.