connection string

[shiveshsingh]

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?

[rohitraut]

Hello shivesh,

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

Hope this help!

[its_anandrjs]

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............

[shiveshsingh]

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

[shiveshsingh]

Thanks

[its_anandrjs]

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);

[rohitraut]

Please find the below link:

SQL connection variables dynamic

connection string | Qlik Community

Hope this help!