Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What are the best practices for a QlikView report from multiple data sources?

Hello all,

A client requested if it is possible to develop a QlikView report using more than one data source at the same time. In other words, the client has some data, let's say, in a production database, and some other data sitting in an Excel, and wants to generate a report that uses both data sources at the same time.

What are the different options that could be used if any (native in QlikView or work arounds)?

QlikView Version 7.5.2.3812.7

Thanks

Yazid B.

9 Replies
rbecher
MVP
MVP

Hello Yazid,

this is why QlikView is so favorite. You can load data from different sources like databases and/or files to bring everything together into one view.

I don't know much details about your requirements but I think you need no work arounds.

- Ralf

Astrato.io Head of R&D
brenner_martina
Partner - Specialist II
Partner - Specialist II

... and please update QlikView to version 10! It runs much faster and is in scripting so helpful!

fernandotoledo
Partner - Specialist
Partner - Specialist

Sure, version 10 is the best!

Not applicable
Author

Thank you Ralf for the prompt answer; you did address the question. I did find some similar questions that were posted in the past as well. And yes Martina and Fernando, upgrade to 10 is planned.

Thanks

Yazid B.

Not applicable
Author

... Unless you use ODBC to read data from Qlikview...

If you do, don't upgrade!

fernandotoledo
Partner - Specialist
Partner - Specialist

What´s kind of problem did you find in QV10 and ODBC?

Here it works fine. We use a 32bits oracle ODBC that didn´t work with windows 64bits + QV9 64 bits. With QV10 it´s now working well.

regards

Fernando

suniljain
Master
Master

Dear Yazid,

if you make qvd of data from multiple sources then different sources does not make any sense for qlikview.

That is the biggest advantage of using Qlikview as BI compare to Cognos and SAP BI.

it is also easy to maintain application.

Not applicable
Author

Hello all,

As a follow up to my original question and to give mode requirements details...

Let's assume we have an existing QlikView script that pulls data from an Oracle database as follows:

ODBC CONNECT TO [my_oracle_database];

Tab1:
Load f1,f2,f3;
SQL
SELECT f1,f2,f3 FROM my_db_table;


Now, let's assume that we have additional data that need to be included in our report.
This additional data though is not in my Oracle database but rather some of it is in a MS Access (Northwind.mdb)
and some of it is in Excel file (draft.xls).

Per the QlikView Reference Manual, the script can be modified as follows to combine all 3 data sources:

// Point to my Oracle database first
ODBC CONNECT TO [my_oracle_database];
// All selects from here on will get data from oracle database my_oracle_database

Tab1:
Load f1,f2,f3;
SQL
SELECT f1,f2,f3 FROM my_db_table;

// Point to MS Access second
Connect to 'Nwind;DBQ=C:\ProgramFiles\MSOffice95\Access\Samples\Northwind.mdb' (UserID is sa, Password is admin);
// All selects from here on will get data from MS Access Northwind.mdb

Tab1:
// Using add to merge new selected records to the previous records in Tab1
add
Load f1,f2,f3;
SQL
SELECT f1,f2,f3 FROM my_db_table_in_ms_access_Northwindmdb;

Tab1:
// Point to MS Excel third
// Using add to merge new selected records to the previous records in Tab1
add
Load f1,f2,f3
FROM (biff, embedded labels, table is [SQL Results$]);

Please let me know if this makes sense overall; and also if there are better ways to do it. For example, should concatenate be used instead of add? Etc.


Thanks

Yazid B.

Not applicable
Author

Hello,

Full discloure:  I am the CEO of DataRoket and we are doing a pilot right now to feed Qlikview.  Our platform outputs xml or to any target DB.

We, for instance, are pulling information from SAP and a Business Objects Universe and feeding a target location (MS SQL Server).

DR is also its own partitioned and high performance data repository that could feed Qlikview that way as well.  We would be very interested in a pilot to show this.

Best regards,

James Fox

CEO

DataRoket

jfox@dataroket.com