See information about the latest product version
Database connections for coordinated message flows
When you configure a message flow to access a database, the broker establishes a connection to that database based on the ODBC DSN.
When you configure a message flow to access a database, the broker 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 broker 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 broker 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 a broker and a specific DSN.
For further information about connections made by the broker to user databases, see User database connections.
For details of these connections, refer to Enabling ODBC connections to the databases and Enabling JDBC connections to the databases.