topic Re: About two database connections in QlikView

About two database connections

Mon, 04 Aug 2014 17:23:07 GMT

In Qlikview can we connect with two database at a time?If no why ?

Re: About two database connections

joshabbott — Mon, 04 Aug 2014 17:25:20 GMT

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

Re: About two database connections

aveeeeeee7en — Mon, 04 Aug 2014 17:50:42 GMT

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

Re: About two database connections

maxgro — Mon, 04 Aug 2014 20:39:27 GMT

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

Re: About two database connections

Wed, 06 Aug 2014 04:30:51 GMT

Thanx Josh for ur reply i got the point