It is common to have to retrieve or insert information into a database table during the processing of a flow. Performance is impacted if the interface must establish a connection to the database for each flow, particularly because the log in process must be performed for each connection.
Database connection pools are integration components that establish and maintain a pool of connections to a database resource. The connections are established initially and are available to other components to issue queries against the database resource. When a component is done using a connection, the connection is released and returned to the pool so that another component may use it. This eliminates the need to log in each time a connection is required.
For information on how to create database connection pools, see Configuring database connection pools. For information on how to use database connection pools in maps, see the Map Development Guide. For information on how to use database connection pools in collaboration templates, see the Collaboration Development Guide.