Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-11-22 06:39 AM

QVD versus a data warehouse

Hi - we have a DW that is populated with input from some (not all systems).  From the data warehouse QVD files are created.  A Qlikview partner has recommended that we remove the DW completely and create rather QVD files.  I am against this (mainly gut instinct) as this would tie us into Qlikview, and limits future BI opportunities.

I would appreciate some expert opinion on this.

Thanks

2,096 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2012-11-22 08:56 PM
Author

Hi Tim,

If you have invested time, money and effort into a DW consolidating data from disparate sources it sounds like a bad idea to just throw it out. I would just leverage the DW for data provisioning for QlikView, and use extra QVD files on top for any QlikView specific transformations or business logic that needs to be implemented. Sure I would still do incremental loads from DW to QVD but if the data in the DW is well formatted then this will be an easy approach and just ensure that not a full reload is executed against the DW every time that applications are refreshed.

786 Views
0 Likes