Loading data into Qlik Sense#
This guide explains how to load data into Qlik Sense for further processing.
Introduction#
Note
Qlik Sense is a passive destination.
When you assign Qlik Sense to a datastream as a destination, Qlik Sense periodically pulls all data extracts with Collected or Loaded status from Adverity. When you collect data from the datastream, it is not actively pushed to Qlik Sense.
Prerequisites#
Before you complete the procedure in this guide, perform all of the following actions:
Create a datastream whose data you want to load into Qlik Sense. For more information on creating a datastream, see Collecting data in Adverity.
Find your authentication token to the Management API. For more information, see Authorizing to Management API.
Using the Management API, find the ID of the datastream from which you want to load data into Qlik Sense. For more information, see Listing datastreams of a specific type.
Procedure#
To load data from a datastream into Qlik Sense, create a REST connection in the Qlik Sense user interface with the following configuration. For more information on creating a REST connection in the Qlik Sense user interface, see the Qlik Sense documentation.
In URL, write the following:
https://{{INSTANCE}}/api//datastreams/{{DATASTREAM_ID}}/extracts/most-recent/download/
Replace
{{INSTANCE}}
and{{DATASTREAM_ID}}
with the values you found using the Management API.In Method, select GET.
In Key generation strategy, select No keys.
In Authentication Schema, select Anonymous.
In the Query headers section, write the following:
In the Name field, write
Authorization
.In the Value field, write
Token {{TOKEN}}
. Replace{{TOKEN}}
with your authentication token to the Management API.
Select the Allow response headers checkbox.
As a result, you created a REST connection in the Qlik Sense user interface. Use this REST connection to load data into Qlik Sense. The data loaded is always the most recent data extract from the datastream.