About the Integration service
Whenever possible, the Integration service uses a single database connection for a query. For example, if a design uses information object data sources that depend on multiple data connection definition files (.dcd), the Integration service may use only one database connection if the DCDs have the same values for the User name, Password, and Server properties and the query can be completely pushed to the database. For concurrent queries, however, the Integration service creates multiple database connections.