Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In Qlikview can we connect with two database at a time?If no why ?
Not at the same time, but in the same script, which I imagine is what you want to do. Make a connection to a DB, and then any code or script under that connection (or in tab's to the right) will use that connection. When you want another connect, make that connection after all the script that uses the first connection. For instance:
Connection String #1
Script for #1
More Script #1
Connection String #2
Script for #2
More Script #2
Etc...
Hi Sreedhar
At a time, there will be only one Connection Active.
You can use Number of Connect Commands to fetch Data.
You can also Connect to one Database and Store files from that database in your system than disconnect the database. After this, again connect to a new database in the similar way than store and disconnect and so on.
eg.
1st Database:
ODBC Connect to .........
ABC
Load
.....
....
From
Store ABC into ..../.qvd(qvd);
Disconnect;
2nd Database:
ODBC Connect to .........
XYZ
Load
.....
....
From
Store XYZinto ..../.qvd(qvd);
Disconnect;
Hope that helps you and cleared some of your doubts.
Regards
Aviral Nag
not at the same time because in Qlik, when you extract some data from a database (with the statement sql select ......) you're connected to the database (one database) of the last connect statement (oledb connect, odbc connect, ...)
Thanx Josh for ur reply i got the point