topic How to use two database in one script? in QlikView

How to use two database in one script?

Thu, 05 Sep 2013 12:01:19 GMT

Hello everybody,

I want to use two database in one script? It is possible? I need it because our company have two different plants with different plantkeys and different database.

Now I use like the picture:

The problem I have only the data of the second plant.

What can I do?

Thanks for your help.

greeetings sven

Re: How to use two database in one script?

tresB — Thu, 05 Sep 2013 12:05:34 GMT

Hello Sven,

Try like this:

ODBC CONNECT TO <First connection string>;

Script here to load from first DB;

DISCONNECT;

ODBC CONNECT TO <Second connection string>;

Script here to load from second DB;

Re: How to use two database in one script?

cesaraccardi — Thu, 05 Sep 2013 12:07:29 GMT

Hi Sven,

You can load data from as many databases as you want, but keep in mind that you are only allowed to work with one at a time. So, for what you are trying to achieve you need to do like:

1. Connect to database A

2. Load data from database A

3. Connect to database B

4. Load data from database B

If the loads have the same structure (number of fields, name of the fields) the data will be concatenated and a sigle table with information from both databases will be created.

Hope that helps,

Cesar

Re: How to use two database in one script?

Thu, 05 Sep 2013 13:12:52 GMT

Hey Sven Arnold,

A "QVD Generator", or better a QVD layer, is probably a good idea in your case.

Cheers

Juan Pedro