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

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

Mon, 21 Feb 2011 17:15:55 GMT

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.

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

rbecher — Mon, 21 Feb 2011 17:37:52 GMT

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

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

brenner_martina — Mon, 21 Feb 2011 18:09:26 GMT

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

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

fernandotoledo — Mon, 21 Feb 2011 18:13:30 GMT

Sure, version 10 is the best!

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

Mon, 21 Feb 2011 18:38:36 GMT

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.

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

Mon, 21 Feb 2011 19:06:49 GMT

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

If you do, don't upgrade!

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

fernandotoledo — Mon, 21 Feb 2011 19:14:29 GMT

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

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

suniljain — Mon, 21 Feb 2011 19:34:13 GMT

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.

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

Wed, 23 Feb 2011 17:41:03 GMT

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.

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

Thu, 23 Jun 2011 16:33:43 GMT

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