topic Re: Direct Discovery to pull real time data in QlikView

Direct Discovery to pull real time data

anindya_manna — Thu, 10 May 2018 06:11:50 GMT

Hi All,

can you please me to create an app in which we pull real time data through direct discovery from data base. i have OLE DB connections already created in my app.

Re: Direct Discovery to pull real time data

tresB — Thu, 10 May 2018 06:23:18 GMT

I guess you would find all the details here: https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/DirectDiscovery/direct-discovery-introductio…

Re: Direct Discovery to pull real time data

anindya_manna — Thu, 10 May 2018 06:35:09 GMT

Thanks Tresesco,

But how we can pull real time data in our apps ? To refresh data in our apps, we need to reload the apps even after using the direct discovery. then what is the best use of direct discovery.

Re: Direct Discovery to pull real time data

tresB — Thu, 10 May 2018 06:44:04 GMT

If you are using direct discovery (spend little more time in the help link I provide to understand), the data is not loaded into the memory during load, rather - with each selection, the charts with Direct Discovery fields are recalculated, with the calculations taking place in the source database table by executing the SQL query created by Qlik engine. The calculation condition feature can be used to specify when charts should be recalculated. Until the condition is met, Qlik engine does not send queries to recalculate the charts.

Hope this helps.

Re: Direct Discovery to pull real time data

anindya_manna — Thu, 10 May 2018 07:45:00 GMT

can we use excel as a data source in direct discovery?

Re: Direct Discovery to pull real time data

tresB — Thu, 10 May 2018 07:50:32 GMT

Technically, perhaps that should be feasible if you create an ODBC connection to the excel. However, using excel data which is very small as direct discovery data source - sounds like defeating the purpose and over killing to result in negative performance. Why would you like to use excel as a data source for direct discovery?