Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
hamaimbo92
Contributor
Contributor

QLIK sense information update

Once Qlik sens enterprise is connected to a database such as SQL server etc that continually is updated with information, say, from a point of sales..... do the dashboards in Qlik sense/view also automatically get updated once created???

3 Replies
lironbaram
Partner - Master III
Partner - Master III

Hi 

a connection to data source will allow you to load data from this data source when you run load function in your Qlik app

the connection doesn't mean live streaming of data,

Qlik app is loading the data and then creating data model in memory to allow fast queries to users

for specific use cases you can use direct query that will query the data base for each user action in the Qlik app 

and won't work in memory 

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

 

petter
Partner - Champion III
Partner - Champion III

If you want more near-to-real-time updates you can employ any of these techniques:

 

1) Setting up a reload every n'th minute

2) Using "Direct Discovery" to connect to the data source. It is sort of a legacy technique but it still works ... sort of ... with some limitations.

3) Using "Server Side Extensions" (SSE) you can use Python as an intermediary to get "live" data from for instance SQL Server. SSE is also used with AAI (Advanced Analytics Integration) but not limited to AAI.

4) Using "On Demand Apps" also known as ODAG

hamaimbo92
Contributor
Contributor
Author

Thanks a lot. I will employ this method. Regards