Database connections for coordinated message flows

When you configure a message flow to access a database, the integration node establishes a connection to that database based on the ODBC or JDBC DSN. To coordinate the database updates with other updates (determined by the configuration you have set for each node that accesses a database), the integration node makes a connection for each transaction mode for each DSN accessed on each message flow thread.

Therefore, if you set the Transaction Mode property for one node in the message flow to Automatic, and for another node to Commit, the integration node establishes two separate connections to this DSN from the same thread. Take this action into account when you calculate the number of connections required between an integration node and a specific DSN.

For further information about connections made by the integration node to databases, see Database connections.

For details of these connections, refer to Enabling ODBC connections to the databases and Enabling JDBC connections to the databases.