Loading data into Qlik Sense

This guide explains how to load data into Qlik Sense for further processing.

Introduction

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 Creating a datastream.

Apply the correct Data Mapping to your datastream.

Find your authentication token to the Management API. For more information, see Authorizing 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.