Qloud Cover LiveQuery

LiveQuery for Qlik Sense

Live Analysis in Qlik

Have you wanted to create a completely live dashboard in Qlik Sense?

LiveQuery for Qlik Sense helps you do just that. LiveQuery for Qlik Sense is a service that enables live queries directly from the Qlik Sense front-end to a specified data warehouse. The LiveQuery services acts as an intermediary between Qlik and the data warehouse without moving data to QVDs.

The result? Completely live Qlik Sense dashboards that can combine the power of live queries with in-memory data.

Stretch Qonnect is a certified Qlik Elite Solution Provider and won Qlik Solution Provider of the Year in EMEA for 2020.

Free Trial


Product Demo

Qlik Sense being for self-service business intelligence on computer

Live Queries in Qlik Sense

Live Queries with no QVDs: A Streamlined Approach

Firstly, LiveQuery for Qlik Sense is a service that enables live queries directly from the Qlik Sense front-end to a specified data warehouse. Importantly, there’s no need to move data to QVDs with LiveQuery. Essentially, the product is a service residing on a server. Specifically, the LiveQuery service acts as an intermediary between Qlik and the data warehouse. With LiveQuery, you do not need to move data to QVDs in order to use Qlik Sense. The service makes it possible to create queries from Qlik Sense without moving all the data in memory, thereby simplifying your architecture.

Seamless integration between live queries and in-memory: Enhancing Data Accessibility

Moreover, the LiveQuery service enables near-seamless integration between live queries and in-memory data. To achieve this, the LiveQuery service dynamically transforms the queries and links the query results to the Qlik data model, based on a series of factors. This is done in real time as the user is using the application.

In-memory cache: Efficient Data Management

Additionally, the LiveQuery service has an in-memory result cache. This means that repeated queries can return results without accessing the warehouse. This reduces the load on the data warehouse and increases the responsiveness of the Qlik front-end. The cache has a configurable time-to-live; when a query result in the cache surpasses this time, the result is evicted from the cache and the query is parsed on the data warehouse. This enables the administrators to balance the requirement between real-time data and load/cost on the data warehouse.

User-specific queries: Personalized Data Experience

Furthermore, the LiveQuery service enables queries to be parsed based on the information about which user is performing the query in the front end. This enables support for user-specific queries, reusing existing table and row-level access implemented to best practice standards for the data warehouse.

Frontend-driven development: Simplified Application Building

Lastly, the LiveQuery service integrates into the Qlik Sense development GUI, which makes the development of applications utilizing LiveQuery simple and fast. No scripting or template applications are required, only SQL and some knowledge of the structure of the data warehouse.

 

 

 

 

 

Free Trial


Contact us