Qlik Sense


Disclaimer

Your use of this download is governed by Stonebranch’s Terms of Use, which are available at https://www.stonebranch.com/integration-hub/Terms-and-Privacy/Terms-of-Use/

Overview

Qlik Sense is a Business Intelligence (BI) Tool. Qlik Sense users can connect and combine data from hundreds of data sources by defining data pipelines as applications. Data can then be visualized via custom dashboards on a Qlik Sense Cloud instance (Business or Enterprise edition) or by using a Desktop application (Enterprise Windows edition).

This Universal Extension provides the capability to perform reload related actions upon an Application, stored on a Qlik Sense Cloud instance.

Version Information

Template NameExtension NameExtension Version
Qlik Senseue-qliksense1.1.0

Refer to Changelog for version history information.

Software Requirements

This integration requires a Universal Agent and a Python runtime to execute the Universal Task.

Software Requirements for Universal Template and Universal Task

Requires Python 3.7.0 or higher. Tested with the Universal Agent bundled Python distribution.

Software Requirements for Universal Agent

Both Windows and Linux agents are supported:

  • Universal Agent for Windows x64 Version 7.0.0.0 and later with python options installed.
  • Universal Agent for Linux Version 7.0.0.0 and later with python options installed.

Software Requirements for Universal Controller

Universal Controller Version 7.0.0.0 and later.

Network and Connectivity Requirements

  • Universal Agent where the extension is deployed should be able to reach the Qlik Sense Cloud instance.
  • A Qlik Sense API Key should be generated in prior from the Qlik Sense Cloud Management Console. API Keys can be generated by users who have either 'Tenant Admin' or 'Delelopers' Role assigned.

Support Qlik Sense SaaS API versions

This Universal Extension is compatible with SaaS API version 24-Feb-2022.

Key Features

This Universal Extension provides the following main features for a Qlik Sense Cloud instance.

  • Actions
    • Reload App
      • Reload App
      • Trigger and Wait until the Qliksense app reaches status "Success" or "Failed"
      • Support for partial reload
    • Read Reload Status
  • Authentication
    • Support for SSL communication

Import Universal Template

To use this downloadable Universal Template, you first must perform the following steps:

  1. This Universal Task requires the Resolvable Credentials feature. Check that the Resolvable Credentials Permitted system property has been set to true.

  2. To import the Universal Template into your Controller, follow the instructions here.

  3. When the files have been imported successfully, refresh the Universal Templates list; the Universal Template will appear on the list.

Modifications of this integration, applied by users or customers, before or after import, might affect the supportability of this integration. For more information refer to Integration Modifications.

Configure Universal Task

For the new Universal Task type Qlik Sense, create a new task and enter the task-specific details that were created in the Universal Template

Input Fields

The input fields for this Universal Extension are described below.

FieldInput typeDefault valueTypeDescription
ActionRequiredReload AppChoiceΑction performed upon the task execution. Available actions are listed below.
  • Reload App
  • Read Reload Status
Qlik Sense TypeRequiredCloudChoiceQlik Sense instance Type based on each installation.

Available actions are listed below.
  • Cloud
API CredentialsOptional-CredentialsDeveloper's API Key for Qlik Sense.

API Key should be stored in the Credentials record as Runtime password.

Required when Qlik Sense Type = Cloud.
Tenant URLOptional-TextQlik Sense Tenant Cloud instance URL.

Required when Qlik Sense Type = Cloud.
App IDOptional-TextQlik Sense Application ID to be reloaded.

Required when Action = Reload App.
Reload IDOptional-TextReload ID of an already reloaded Qlik Sense application.

Required when Action = Read Reload Status.
Partial ReloadOptionalFalseBooleanIndication to perform Partial Reload during Reload App on Cloud.

Optional when Action = Reload App.
Enable SSL certificate verificationOptionalTrueBooleanVerify SSL certificates when sending a request. Verification failures will result in the request being aborted.

Optional when Qlik Sense Type = Cloud.
Wait for success or failure

Introduced in version 1.1.0
OptionalFalseBooleanWait for the Reload app status response.

Optional when Action = Reload App.
Pooling interval

Introduced in version 1.1.0
Optional60IntegerThe amount of time the task will wait before pooling for a new response when the response is not success or failure during the last cycle.

Valid values from 0 to 60.

Task Examples

Reload a Qlik Sense Application

Reload an application on a Qlik Sense Cloud instance.

Reload a Qlik Sense Application and Wait for Success or Failure

Reload an application on a Qlik Sense Cloud instance and Wait for Success or Failure.

Read Reload Status of a Qlik Sense Application

Read the status of an already reloaded Qlik Sense application.

Task Output

Output Only Fields

The output parameters are set after every message processing. If they are 'preserved on re-run', they prevent a re-run of the task instance from restarting from scratch.
The output fields for this Universal Extension are described below.

FieldTypePreserved on re-runDescription
Reload StatusTextNoReload status returned from Read Reload Status action Reload App action when the Wait for Success or Failure button is turned on. Can be used as a Condition on a Workflow level.
Reload IdTextNoReload id returned from Reload App action when the Wait for Success or Failure button is turned on.

Exit Codes

The exit codes for this Universal Extension are described below.

Exit CodeStatus Classification CodeStatus Classification DescriptionStatus Description
0SUCCESSSuccessful ExecutionSUCCESS: QlikSense App reloaded successfully.
1FAILFailed ExecutionFAIL: < Error Description >
3AUTHORIZATION_ERRORInsufficient PermissionsAUTHORIZATION_ERROR: Account is not authorized to perform the requested action.
10CONNECTION_ERRORBad connection data or connection timed outCONNECTION_ERROR: < Error Description >
20DATA_VALIDATION_ERRORInput fields validation errorDATA_VALIDATION_ERROR: Some of the input fields cannot be validated. See STDERR for more details
21SUCCESSRead Reload Status succesul executionSUCCESS: Reload status is CREATED.
22SUCCESSRead Reload Status succesul executionSUCCESS: Reload status is QUEUED.
23SUCCESSRead Reload Status succesul executionSUCCESS: Reload status is RELOADING.
24SUCCESSRead Reload Status succesul executionSUCCESS: Reload status is FAILED.
25SUCCESSRead Reload Status succesul executionSUCCESS: Reload status is SUCCEEDED.

Extension Output

Extension Output example for a successful execution of Reload App.

{
    "exit_code": 0,
    "status_description": "SUCCESS: QlikSense App reloaded successfully.",
    "changed": true,
    "invocation": {
        "extension": "ue-qliksense",
        "version": "1.1.0",
        "fields": {
            "action": "Reload App",
            "qliksense_type": "Cloud",
            "tenant_url": "https://a4clkt1cb9k4trp.eu.qlikcloud.com",
            "api_credentials": "****",
            "app_id": "5aca2029-f5d7-48b7-9606-45d55f6bc469",
            "reload_id": null,
            "partial_reload": true,
            "enable_ssl_cert_verification": true,
            "wait_for_success_or_failure": false,
            "polling_interval": 0
        }
    },
    "result": {
        "reload_id": "626bc4aef8699d7f94fd30da"
    }
}

Extension Output example for a successful execution of Read Reload Status.

{
    "exit_code": 25,
    "status_description": "SUCCESS: Reload status is SUCCEEDED.",
    "changed": true,
    "invocation": {
        "extension": "ue-qliksense",
        "version": "1.1.0",
        "fields": {
            "action": "Read Reload Status",
            "qliksense_type": "Cloud",
            "tenant_url": "https://a4clkt1cb9k4trp.eu.qlikcloud.com",
            "api_credentials": "****",
            "app_id": null,
            "reload_id": "626aa8eb3433e820e4e410e0",
            "partial_reload": false,
            "enable_ssl_cert_verification": true,
            "wait_for_success_or_failure": false,
            "polling_interval": 0
        }
    },
    "result": {
        "reload_status": "SUCCEEDED"
    }
}

Extension Output example for a successful execution of Reload App with Wait for success or failure button activated.

{
    "exit_code": 0,
    "status_description": "SUCCESS: QlikSense App reloaded successfully.",
    "changed": true,
    "invocation": {
        "extension": "ue-qliksense",
        "version": "1.1.0",
        "fields": {
            "action": "Reload App",
            "qliksense_type": "Cloud",
            "tenant_url": "https://a4clkt1cb9k4trp.eu.qlikcloud.com",
            "api_credentials": "****",
            "app_id": "5aca2029-f5d7-48b7-9606-45d55f6bc469",
            "reload_id": null,
            "partial_reload": true,
            "enable_ssl_cert_verification": true,
            "wait_for_success_or_failure": true,
            "polling_interval": 60
        }
    },
    "result": {
        "reload_id": "626bc4aef8699d7f94fd30da",
        "reload_status": "SUCCEEDED"
    }
}

Integration Modifications

Modifications applied by users or customers, before or after import, might affect the supportability of this integration. The following modifications are discouraged to retain the support level as applied for this integration.

  • Python code modifications should not be done.
  • Template Modifications
    • General Section
      • "Name", "Extension", "Variable Prefix", "Icon" should not be changed.
    • Universal Template Details Section
      • "Template Type", "Agent Type", "Send Extension Variables", "Always Cancel on Force Finish" should not be changed.
    • Result Processing Defaults Section
      • Success and Failure Exit codes should not be changed.
      • Success and Failure Output processing should not be changed.
    • Fields Restriction Section
      The setup of the template does not impose any restrictions, However with respect to "Exit Code Processing Fields" section.
      1. Success/Failure exit codes need to be respected.
      2. In principle, as STDERR and STDOUT outputs can change in follow-up releases of this integration, they should not be considered as a reliable source for determining success or failure of a task.

Users and customers are encouraged to report defects, or feature requests at Stonebranch Support Desk.

Document References

This document references the following documents:

NameLocationDescription
Universal TemplatesUniversal TemplatesUser documentation for creating Universal Templates in the Universal Controller user interface.
Universal TasksUniversal TasksUser documentation for creating Universal Tasks in the Universal Controller user interface.
Qlik Sensehttps://www.qlik.com/us/products/qlik-senseQlik Sense home page
Qlik Sense Reloadhttps://qlik.dev/apis/rest/reloadsQlik Sense reload API documentation
Qlik Sense API Keyhttps://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Admin/mc-generate-api-keys.htmManaging API Keys

Changelog

ue-qliksense-1.1.0 (2022-09-29)

Enhancements

  • Added: Introduced a new Wait for success or failure functionality, where the user gets the reload app status after reloading the app. (#30178)

ue-qliksense-1.0.0 (2022-05-04)

Initial Version