Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

connection string

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?

6 Replies
Highlighted
Creator
Creator

Hello shivesh,

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

Hope this help!

Highlighted

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

Highlighted
Master
Master

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

Highlighted
Master
Master

Thanks

Highlighted

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

Highlighted
Creator
Creator

Please find the below link:

SQL connection variables dynamic

connection string | Qlik Community

Hope this help!