topic Re: on which platform ODAG and Dynamic View can be installed? On premise or Saas? in Management & Governance

on which platform ODAG and Dynamic View can be installed? On premise or Saas?

Shrankhla1195 — Mon, 27 Feb 2023 09:40:42 GMT

Hi,

Can anyone help me out on which platform ODAG and Dynamic View can be installed? On premise or SaaS?

Thank you in advance for the help.

Best Regards,

Shrankhla

Re: on which platform ODAG and Dynamic View can be installed? On premise or Saas?

Dave_Channon — Mon, 27 Feb 2023 13:26:02 GMT

Hi @Shrankhla1195

Dynamic views and On Demand Apps can be deployed in both client-managed and SaaS products:

In either case, the apps run in Qlik Sense, and you have the option of connecting directly to your target data source(s), or loading from flat files.

Re: on which platform ODAG and Dynamic View can be installed? On premise or Saas?

Shrankhla1195 — Tue, 28 Feb 2023 04:16:45 GMT

Thank you for the reply @Dave_Channon.

And what about direct query feature is that also on both or only on SaaS?

Re: on which platform ODAG and Dynamic View can be installed? On premise or Saas?

Dave_Channon — Tue, 28 Feb 2023 09:09:48 GMT

Hey @Shrankhla1195

Direct query is only in Qlik Cloud (see https://community.qlik.com/t5/Product-Innovation/Direct-Query-now-available-in-Qlik-Sense-SaaS/ba-p/1962257 for more).

In our client-managed products we still have the legacy direct discovery capability (which although it has a command named "direct query", isn't related to the Cloud capability), more info here https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/DirectDiscovery/access-large-data-sets-with-direct-discovery.htm

Re: on which platform ODAG and Dynamic View can be installed? On premise or Saas?

Shrankhla1195 — Tue, 28 Feb 2023 11:25:47 GMT

thank you @Dave_Channon for the reply, I would like to know if you can help with one more query with dynamic load and ODAG -

With the help of reload button on the dynamic view charts and reload button in the ODAG app, can I get real time data just by clicking those Reload buttons?

or i need to have my qvd refreshed for that as well? Or those will be making a direct connection with my source by clicking on reload button?

Re: on which platform ODAG and Dynamic View can be installed? On premise or Saas?

Or — Tue, 28 Feb 2023 11:51:39 GMT

Data will be as up to date as whatever your source connection is. If your source is up to date in real time, the app will pull that information in real time (as of the reload time). If your source is a QVD updated by another app, a materialized view, or some other source that is not updated in real time, you will get the information that it contains as of the reload time.

Re: on which platform ODAG and Dynamic View can be installed? On premise or Saas?

Dave_Channon — Tue, 28 Feb 2023 12:53:53 GMT

Yep, as @Or says, it's your choice.

ODAG and dynamic views use template apps - so it's your choice which data source you target that app against, giving you the flexibility to use a different source to the base app. No issues using your scheduled reload QVDs for the base app, and a direct connect to the database for those ODAG apps/ dynamic view charts.

Re: on which platform ODAG and Dynamic View can be installed? On premise or Saas?

Shrankhla1195 — Tue, 28 Feb 2023 13:23:12 GMT

@Dave_Channon @Or and if i want to have real time data without refreshing the qvds then i have to directly connect it with db? because i want to have near real time data and qvds will be refreshed twice daily but i want the data to be near real time so i will directly make connection with db (db will have real time data) and create dynamic view and when i click on chart in dynamic view reload button i will be able to retrieve the real time data. Is my understanding correct ?

Re: on which platform ODAG and Dynamic View can be installed? On premise or Saas?

Dave_Channon — Tue, 28 Feb 2023 14:11:14 GMT

Yep, exactly.

I'll try to outline the components:

Base app - loading from QVDs, so bulk of data will be reloaded twice daily and most analytics in the app will be based on this slightly older data
Template app - loading from database, so latest data returned on each reload, which will provide data for objects using dynamic views on demand

The base app will use the template app to provide data for your dynamic view object.

Re: on which platform ODAG and Dynamic View can be installed? On premise or Saas?

Shrankhla1195 — Thu, 02 Mar 2023 05:18:21 GMT

this is just so helpful @Dave_Channon i really appreciate your help and guidance, I think i got it now. Many many thanks 😊