topic On Demand Queries in App Development

On Demand Queries

Anonymous — Wed, 24 May 2017 17:23:12 GMT

Hello,

What does Qlik Sense have for on demand querying other than On Demand App Generation?

I have fairly large data, 1 billion + rows, and it is becoming unmanageable to load all of it in memory.

Assume I require access to all of the data.

Any thoughts on how others have handled this problem (native, API or data architecture changes are all on the table) are appreciated.

Thanks!

Re: On Demand Queries

rdrivas — Fri, 03 Jul 2020 11:29:53 GMT

Don't use ODAG, it is not possible to deploy between environments without manual intervention, time consuming + open to introduce new issues.

If you promote from UAT to LIVE ODAG reports, you will have to manually setup report template every time, forget about DevOps approach. 2 years old issue. https://support.qlik.com/articles/000056504

If you don't have full access to LIVE environments you need to introduce other tool, I recommend Power BI to on-Demand reports with huge datasets and it is really cheap.

Regards

Rodrigo