Configuring ODBC connections for globally coordinated transactions

Configure the definition of your ODBC databases to the transaction manager (the queue manager).

Before you begin

You must create and configure the databases by following the instructions in Working with databases.

You, or your message flow developer, must also ensure that the message flows deployed to the integration node are set up to support coordination. The tasks that are involved in configuring the message flows correctly are described in Configuring transactionality for message flows.

On distributed systems, an IBM® MQ queue manager associated with the integration node performs the transaction manager role, which means that IBM App Connect Enterprise requires access to IBM MQ when processing messages. For more information about using IBM MQ with App Connect Enterprise, see Installing IBM MQ.

Procedure

  1. Ensure that your databases are configured for global coordination.
    For the databases that your message flows connect to, complete the tasks that are described in Configuring databases for global coordination of transactions.
  2. Configure the App Connect Enterprise environment so that the integration node queue manager coordinates transactions with database resource managers.
    The steps to configure the environment depend on the database manager that you are using.

Results

When you have completed these steps, your message flows are processed by using global coordination, which is managed by the queue manager.

You must complete all the steps correctly; if you do not, global coordination will not work.