topic Re: Connections to multiple data bases and Include scripts in QlikView

Connections to multiple data bases and Include scripts

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Can you please let me know how to connect to multiple data bases in Qlikview . Will it work and please share the connections for syntax for connections and storing these connections externally in include scripts.

Awaiting response as soon as possible.

Thank you in advance.

Re: Connections to multiple data bases and Include scripts

vishsaggi — Fri, 03 Nov 2017 02:20:36 GMT

If i get you correctly and i assume you already have the connection strings in your text files.

This is what i did.

Con1.txt

Con2.txt

Con3.txt

Are my three different data source connections files which has my connection strings. So in QV script i did this

LET v1ConnectionPath = '$(Must_Include=\\servername\Qlikview\Reports\Scripts\Con1.txt)';

LET v2ConnectionPath = '$(Must_Include=\\servername\Qlikview\Reports\Scripts\Con2.txt)';

LET v3ConnectionPath = '$(Must_Include=\\servername\Qlikview\Reports\Scripts\Con3.txt)';

Then using these variables i called where ever i required. Like

$(v1ConnectionPath);

My load script here.

$(v2ConnectionPath);

My 2nd Load script here. .....etc.

Hope this helps.

Re: Connections to multiple data bases and Include scripts

Anonymous — Fri, 03 Nov 2017 05:48:32 GMT

Hi Vishwanath,

Thank you for your message .

1. Can the connection strings be stored as it is in the text files. I.e. as it is generated in the qlikview script editor when we try to make the connection to the particular data base. No special syntax required in text file correct? just the string.

2. If we connect to multiple data bases will Qlikview function properly allowing fields from tables from both data bases or would there be any problem of loss of connection or (dealing with one database) at a time? As I might have 4 to 5 different data sources.

Re: Connections to multiple data bases and Include scripts

vishsaggi — Fri, 03 Nov 2017 14:30:29 GMT

Just use the connection string as when you add to Qlikview script. It would work fine.

I too have data coming from 4 different sources so i use these variable where ever necessary to pull data from different db's it does not effect other db connections.