Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
amien
Specialist
Specialist

With Qlikview you dont need a datawarehouse?

true or false?

and if true, what criteria does your data need to have?

if false .. why not?

4 Replies
Anonymous
Not applicable

True, QlikView does not need a data warehouse.
Criteria are based not on technology but purely on the business logic. You load the data in your application that is needed for your analysis.

amien
Specialist
Specialist
Author

where do you keep the history? just expend the databases that are allready running?

Not applicable

Hi,

To build up history with QlikView, you can use QVD files. For every table you can create a QVD file. For example you can add the newest records from your database to the QVD file with incremental loads based on for example last change dates. Chapter 25 in your Reference Manual gives you a couple of solutions how to create QVD files. It's also possible to Insert, Update and Delete rows of data. You can find examples for incremental load in this forum.

Greetz

Robbie

johnw
Champion III
Champion III

I suppose that depends on the definition of "data warehouse". In a very general sense, I consider our multi-purpose QlikView QVD files to be a type of data warehouse. But generally speaking, no. You can load directly from your business systems. You don't need to stage the data in a data warehouse. If you have a data warehouse already in place, you might well want to load from there instead of from your raw data. But if you don't have one in place, I'm not thinking of a good reason to build one if QlikView is going to be your primary reporting tool.

As far as history goes, my preference and our most common solution in our shop is to keep history in the business systems themselves, and just load it from there into QlikView. I also have one case where history is kept in generations of a flat file, one file for each month. That was done for a particularly large (for us) database with various reasons to want to keep purging old data from the live database. We do have several incremental loads, where the QVD is storing the historical data, and it isn't being reloaded from the live system. However, in all the cases I'm thinking of, the QVD is backed up by either a file or database, so that if we lost the QVD for some reason, we could recreate it from scratch.