LiveQuery for Qlik Sense

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.

Easy warehouse connection

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.

The LiveQuery service enables an almost 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.

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.

How?

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.

LiveQuery furthermore, 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.

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.

Contact us for pricing