topic Connections to multiple data bases - does connection work simultaneously in qlikview in QlikView https://community.qlik.com/t5/QlikView/Connections-to-multiple-data-bases-does-connection-work/m-p/1407333#M804154 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">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&nbsp; data model. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Connections to multiple data bases - does connection work simultaneously in qlikview https://community.qlik.com/t5/QlikView/Connections-to-multiple-data-bases-does-connection-work/m-p/1407333#M804154 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">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&nbsp; data model. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Connections-to-multiple-data-bases-does-connection-work/m-p/1407333#M804154 Anonymous 2020-11-25T16:16:04Z Re: Connections to multiple data bases - does connection work simultaneously in qlikview https://community.qlik.com/t5/QlikView/Connections-to-multiple-data-bases-does-connection-work/m-p/1407334#M804155 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Fri, 03 Nov 2017 07:34:41 GMT https://community.qlik.com/t5/QlikView/Connections-to-multiple-data-bases-does-connection-work/m-p/1407334#M804155 jonathandienst 2017-11-03T07:34:41Z Re: Connections to multiple data bases - does connection work simultaneously in qlikview https://community.qlik.com/t5/QlikView/Connections-to-multiple-data-bases-does-connection-work/m-p/1407335#M804156 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Fri, 03 Nov 2017 07:37:12 GMT https://community.qlik.com/t5/QlikView/Connections-to-multiple-data-bases-does-connection-work/m-p/1407335#M804156 jonathandienst 2017-11-03T07:37:12Z Re: Connections to multiple data bases - does connection work simultaneously in qlikview https://community.qlik.com/t5/QlikView/Connections-to-multiple-data-bases-does-connection-work/m-p/1407336#M804157 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>Mark</P></BODY></HTML> Fri, 03 Nov 2017 08:32:45 GMT https://community.qlik.com/t5/QlikView/Connections-to-multiple-data-bases-does-connection-work/m-p/1407336#M804157 Mark_Little 2017-11-03T08:32:45Z Re: Connections to multiple data bases - does connection work simultaneously in qlikview https://community.qlik.com/t5/QlikView/Connections-to-multiple-data-bases-does-connection-work/m-p/1407337#M804158 <HTML><HEAD></HEAD><BODY><P>Hi trail,</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">I think&nbsp; @jonathan&nbsp; above are correct.</SPAN></P><P></P><P>Thanks,</P><P>Arvind Patil</P></BODY></HTML> Fri, 03 Nov 2017 09:52:51 GMT https://community.qlik.com/t5/QlikView/Connections-to-multiple-data-bases-does-connection-work/m-p/1407337#M804158 arvind_patil 2017-11-03T09:52:51Z