How many database connections are created while data load is performed in Strategy Enterprise Manager 9.x at the most?
The data load process is the essence of Strategy Enterprise Manager 9.x. It is the process that transfers the data from the statistics tables to Strategy Enterprise Manager warehouse tables.
As mentioned in below tech-note, during startup, Strategy Intelligence Server 9.x will open one database connection per project if projects are configured to log statistics.
KB16041 - How many database connections are created to the Statistics database while collecting statistics for projects in MicroStrategy Intelligence Server 9.x and 10.x?
Besides database connections mentioned above, one new database connection is opened for Enterprise Manager warehouse. So if there are 2 projects monitored by Enterprise Manager, two connections are opened while logging statistics, one more is opened while performing data load, which means at the most, 3 database connections are created while data load.
