Live Queries in Qlik Sense
LiveQuery for Qlik Sense is a service that enables live queries directly from the Qlik Sense front-end to a specified data warehouse. No need to move data to QVDs with LiveQuery. The product is a service residing on a server. The LiveQuery service acts as an intermediary between Qlik and the data warehouse.
Live Queries with no QVDs
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, simplifying your architecture.
Seamless integration between live queries and in-memory
The LiveQuery service enables near-seamless integration between live queries and in-memory data. To achieve this the LiveQuery service dynamically transform 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.
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
The LiveQuery service enables queries to parser 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
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 on the structure of the data warehouse.