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 databases, see Database connections.
For details of these connections, refer to Enabling ODBC connections to the databases and Enabling JDBC connections to the databases.