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

[Anonymous]

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

[kaushiknsolanki]

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

[amit_saini]

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,

AS

[kkkumar82]

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

[Anonymous]

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

[kkkumar82]

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.

[Anonymous]

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

[raghvendrasingh · Accepted solution]

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

[Anonymous]

thanks a lot Raghvendra

[avinashelite]

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