Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
nadig_sahana
Contributor III
Contributor III

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

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

1 Solution

Accepted Solutions
raghvendra_singh
Creator II
Creator II

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

View solution in original post

10 Replies
kaushiknsolanki
Luminary Alumni
Luminary Alumni

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
amit_saini
Master III
Master III

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
Specialist III
Specialist III

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

nadig_sahana
Contributor III
Contributor III
Author

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
Specialist III
Specialist III

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.

nadig_sahana
Contributor III
Contributor III
Author

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

raghvendra_singh
Creator II
Creator II

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

View solution in original post

nadig_sahana
Contributor III
Contributor III
Author

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