Configuring databases

Configure databases to hold application or business data that you can access from your message flows.

About this task

Databases that hold application or business data can be read from and written to by nodes within the message flows that you deploy to one or more integration nodes in your domain.

In some situations, and for some applications, you might need to ensure the integrity of the data that you hold in databases across multiple systems and resource managers by coordinating table updates and the writing to one database with the deletion of data in another. To achieve these goals, you must configure your databases, your integration nodes, and your message flows to be globally coordinated.

For more information about the requirement for, and set up of, databases, and the restrictions that apply, see Databases overview.

The process of making databases available has the following phases:

  1. Optional: Create and configure databases. If your message flows interact with databases, you must create those databases and configure ODBC and JDBC connections for them. Then the integration node can connect to the databases on behalf of the message flows.
  2. Optional: If your databases contain critical information, coordinate their updates through a transaction manager.

    On distributed systems, a WebSphere® MQ queue manager is the transaction manager that interacts with the resource managers (the database providers), which means that IBM® Integration Bus requires access to WebSphere MQ when processing the messages. On z/OS®, Resource Recovery Service (RRS) provides equivalent coordination. For more information about using WebSphere MQ with IBM Integration Bus, see Installing WebSphere MQ.

To complete these phases:

Procedure

  1. If you want to access databases from your deployed message flows, create and configure the databases and the connections to them.
    1. Optional: If you want your databases to participate in globally coordinated transactions, configure the databases for global coordination.
  2. On distributed platforms, create and configure connections to the databases that you have created:
    1. If your message flows use an ODBC connection to a database, enable an ODBC connection for that database.
      Repeat this step for each database that you want to access in this way.

      Note that you can use the mqsicvp command as an ODBC test tool; see Enabling ODBC connections to the databases for further information.

    2. If your message flows use a JDBC connection to a database, enable a JDBC connection for that database.
      Repeat this step for each database that you want to access in this way.
  3. On z/OS, connect to the database.
  4. Optional: If you want your databases to participate in globally coordinated transactions, configure the environment for global coordination.