topic Re: connection string in QlikView

connection string

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

Suppose i have 2 data sources.

In 1 data source, i have 5 tables and in other i have 3 tables.

I wrote 1 connection string and took 3 tables from first source. Then wrote 2nd connection string and took 3 tables.

Now i need remaining 2 tables from first data source.

Do i need to write first connection string again?

Re: connection string

rohitraut — Sat, 09 Sep 2017 16:54:02 GMT

Hello shivesh,

No need to write first connection string again on same extractor or application.

Hope this help!

Re: connection string

its_anandrjs — Sat, 09 Sep 2017 16:57:04 GMT

I suggest use the QVD Maker for this for first Connection String use other QVD makers and for second another QVD makers.

Ex:-

QvdMaker1.qvw

QvdMaker2.qvw

//QvdMaker1.qvw

//Connection String1

CUSTOM CONNECT TO

....................;

Tables load strings............

//QvdMaker2.qvw

//Connection String2

CUSTOM CONNECT TO

....................;

Tables load strings............

Re: connection string

shiveshsingh — Sat, 09 Sep 2017 17:01:12 GMT

yep,,this is a way..but i am asking for understanding..if u cud help plz

Re: connection string

shiveshsingh — Sat, 09 Sep 2017 17:01:23 GMT

Thanks

Re: connection string

its_anandrjs — Sat, 09 Sep 2017 17:06:50 GMT

If you are using the way right now is also fine it works for you no need to write the connection string again and again you can use Include option here as well as.

Means write your connection string on any text file and just include the connection string txt file into your qvw file.

Ex:-

1. Write the connection string in any text file and then include it with option available in the load script.

$(Include=d:\connstr.txt);

Re: connection string

rohitraut — Sat, 09 Sep 2017 17:14:48 GMT

Please find the below link:

SQL connection variables dynamic

connection string | Qlik Community

Hope this help!