Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
jaryszek2
Contributor

Can Qlikview replace Data Warehouse or i a bad approach?

Hi,

in this forum there is a lot of similar question but all in spanish language.

I want to understand the difference in english.

What do you think ? Can replace or not?

What if you have a model demanding snoflake shema rather then star schema (in Qlikview better is star schema and snowflake should be avoided). ?

what if we hava  a ot of source of data, very large data size and QV memory will be not enough?

Could you please help and explain it e little ?

BesT wishes,

Jacek

3 Replies
Highlighted
jaryszek2
Contributor

Re: Can Qlikview replace Data Warehouse or i a bad approach?

Anyone?

Did you have any situations where QV where to slow to manage all data?

Or optimatizations tool within data warehous were better then performance of QV?

Jacek

MVP
MVP

Re: Can Qlikview replace Data Warehouse or i a bad approach?

If you have an existing data warehouse, then use that as the source for your QV documents. No need to rip out and replace the existing ETL.

If you don't have an existing warehouse, then its not so easy to decide. If your only use for the warehouse is to feed QV documents, then you can create a 2 or 3 tier ETL, storing intermediate and final QVDs on a properly structured and secured file server. You would need to build QVW generators to extract the data from the source system, and to tramnform the data into the form required for your QV documents. The ETL and the final document loads would then need to be scheduled in QV Server/QV Publisher or some sort of external scheduling tool.

If you need the robustness and governance of a database server, or you need to feed other reporting tools, then you may be better off creating a SQL based warehouse.

As far as scaling is concerned, "a lot of data" is not very specific, but is fairly straightforward to create QVDs with 10s or 100s of million rows and you can also use incremental logic using monthly, quarterly or annual QVDs to partition the data if required. The data set size is therefore not necessarily a constraint.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
jaryszek2
Contributor

Re: Can Qlikview replace Data Warehouse or i a bad approach?

Thank you Jonathan,

it is very helpful for me.

Topic is interestic - it depends on business needs and requirements.

And IT environment also,

Best wishes,

Jacek