Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Qlik Sense Read ad hoc QVDs

Hello all,

I have been working with Qlik Sense the past 1 year, so i am quite new at this.. 

I came across with one very challenging request in which i will need your help. 

We want to create a Qlik Sense server in order to handle 5 Billion records per year. The main fact table will have 4.5 billion and the other 500 million will be dimensions and reference tables. Column number is minor compared with rows, I image 10-12 in main table and 4-5 in dimensions. Read only users will be 10-12 and 2 developers. 

My first question is if a 256 GB ram server with 1 T SSD could efficiently support the above request (I don't know if i will break it to dev node and prod node). 

And the second and more advanced question is if i can read ad hoc data from qvds. My plan is to store my main table in Daily QVDs(7 million records) in order to append data from my Oracle database. 

If an application has aggregated data from my main table in charts/KPIs etc and a user wants to drill down in a specific day (7 million rows in a QVD in Qlik server's storage) , can Qlik in real time load the specific QVD in the details Table? Or something similar to support my case. 

Thanks in Advance, 

George. 

 

Labels (4)
1 Reply
MVP & Luminary
MVP & Luminary

Can't answer the first question as I don't know how big your qvd's and apps are. You mention 5 billion records per year, but not how many years for example.

The second question sounds like a good use case for ODAP, i.e. On Demand App Generation.
See
https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/DataSource/Manage-b...
https://www.youtube.com/watch?v=acG0HR3hQyk

talk is cheap, supply exceeds demand