Connections to multiple data bases - does connection work simultaneously in qlikview

[Anonymous]

If we have connected to multiple data bases like 4 or 5 data bases at a time do the connections for all the data bases work simultaneously. I.e can we pull fields from different data sources at the same time and use different fields from different data sources for comparison and calculations in charts and graphs? Does the connection to all these databases stay simultaneously or is there something like using fields from one data base at a time and hope it's not required to store each database content in qvd before use in UI or  data model.

[jonathandienst]

The load runs sequentially. You open a connection with CONNECT and use it. Then open the next connection with CONNECT which automatically closes the first connection. So it is one load and one DB connection at a time.

[jonathandienst]

The data can all be loaded in a single script with multiple connects. There is no need to save into QVDs simply to get data from several sources.

[Mark_Little]

Hi,

As Jonathan has explained if in a single script it will load sequentially. This would be the normal approach, once loaded that data is store within the dashboard, so you aren't continually reading the databases, unless Direct Discovery is used. So once load you have access to all the data loaded regardless to source, if your data model is created correctly it will all be associated as well.

Mark

[arvind_patil]

Hi trail,

I think  @jonathan  above are correct.

Thanks,

Arvind Patil