topic Re: can we read / extract data directly from multiple database instances and join the tables in qlikview in QlikView

can we read / extract data directly from multiple database instances and join the tables in qlikview

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hi,

can we read / extract data directly from multiple database instances and join the tables in qlikview?

Example, Table A from Database A, Table B from Database B, I would like to join Table A and B in QlikView.

regards,

Sahana

Re: can we read / extract data directly from multiple database instances and join the tables in qlikview

kaushiknsolanki — Mon, 01 Aug 2016 07:39:52 GMT

Hi,

Yes its possible.

You can write the select statement like below.

Table1:

Sql

Select * from Database1.Table1;

Table2:

Sql

Select * from Database2.Table2;

Regards,

Kaushik Solanki

Re: can we read / extract data directly from multiple database instances and join the tables in qlikview

amit_saini — Mon, 01 Aug 2016 07:40:02 GMT

Hi,

Yes you can.

Load *

From TableA;

Join

Load *

From TableB;

Note: To join u should have common field (Key) between TableA and TableB

Just to help you on Data modelling side , attaching doc.

Thanks,

Re: can we read / extract data directly from multiple database instances and join the tables in qlikview

kkkumar82 — Mon, 01 Aug 2016 07:40:58 GMT

Hi Sahana,

Let do it like this in edit script.

Tab1:

ODBC connect to Oracle;

Table1:

Load statement;

Tab2:

OLEDB connect to SQLServer;

Join(Table1)

Table2:

Laod Statement;

Note: Be careful, don't copy load statement from one connection under another connection, the data may be ambiguous if the table is contained in both the databases or even through an error if the table is not contained in another connection.

Hope it helps you

Re: can we read / extract data directly from multiple database instances and join the tables in qlikview

Anonymous — Mon, 01 Aug 2016 07:59:31 GMT

hi all,

thanks for your responses.

Can I check that: when I reload the application, will my data from both database A(may be SQL) and Database B(may be Oracle) be refreshed simultaneously? else what would be the round about effort?

regards,

sahana

Re: can we read / extract data directly from multiple database instances and join the tables in qlikview

kkkumar82 — Mon, 01 Aug 2016 08:57:08 GMT

What do you mean by refreshing , is it loading or incremental load.

If it is refreshing, yes, it can loaded from both databases one by one , even if you can do the incremental loading also.

Re: can we read / extract data directly from multiple database instances and join the tables in qlikview

Anonymous — Mon, 01 Aug 2016 09:12:39 GMT

hi Kumar,

Yes, I meant data loading.So should I load the script twice, each time connecting to either of the data bases A or B?

Inst there an option to load both the databases at ones?

regards,

Sahana

Re: can we read / extract data directly from multiple database instances and join the tables in qlikview

raghvendrasingh — Mon, 01 Aug 2016 09:20:21 GMT

Hi Sahana,

Yes If you reload the application then it will refresh automatically.But this is not the best practice in Qlikview Development.

For Best Practice, First load the data from all sources and store in QVDs.

From QVDs you can fetch the data into your application.

Hope it will help you, If any doubt still remains kindly let me know.

Thanks,

Raghvendra

Re: can we read / extract data directly from multiple database instances and join the tables in qlikview

Anonymous — Mon, 01 Aug 2016 09:22:07 GMT

thanks a lot Raghvendra

Re: can we read / extract data directly from multiple database instances and join the tables in qlikview

avinashelite — Mon, 01 Aug 2016 09:23:10 GMT

simultaneous loading of data in one QVW is not possible because Qlikview connect to single data source while loading the data once its done...it will disconnect the correct and connect to another database .

If you need it in a simultaneous way then create 2 QVW's and then create QVD's out of those and then load them into the dashboard

Hope this helps you

Re: can we read / extract data directly from multiple database instances and join the tables in qlikview

Colin-Albert — Mon, 01 Aug 2016 09:24:10 GMT

Yes, you can do this, but only 1 connection is active at any time, so if you are changing connections you will need to have your connect statements in the correct position in the script.

You can use concatenate, mappings and joins in the QlikView script to combine that data as required.

e.g.

Connect statement 1 ;

load data from connection 1 ;

Connect statement 2 ;

load data from connection 2 ;