How to reuse connections in multiple maps in one solution.

For a customer we have one solution with 37 maps. All the maps use the same source (SQL Azure ) and target (Dynamics 365) connections. When running one of those maps it seems that GetConnection() is called 37 or more times which takes 12 minutes just to connect. In this case the connection to Azure is taking 12 minutes while the connection to D365 is taking one minute.

 

The workaround to run one map only is to disable all 36 other maps. Then the performance is good( 19 seconds instead of 13 minutes).

My question is how come this is happening and how should we configure the solution so that the connections are reused.

(1) Answer

Login