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.

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

To make databases available, complete the following steps:

Procedure

  1. If you want to access databases from your deployed message flows, create and configure the databases and the connections to them.
  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.