Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »


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.

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 from 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:

FeatureDescription
Reload AppAction to reload a Qlik Sense application
Read Reload StatusAction to reload status of a previously reloaded application

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.

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 AppChoiceThe action performed upon the task execution. Available action:
  • Reload App
  • Read Reload Status
Qlik Sense TypeRequiredCloudChoiceThe Qlik Sense instance Type based on each installation. Available action:
  • 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

Extension Cancelation

When using a 7.0 or newer template, we must ensure that the “Always Cancel On Force Finish” is checked. This is to minimize leaving “orphan” processes on the OS without the option for the agent to see they are running.



Task Examples

Reload a Qlik Sense Application

Reload an application on a Qlik Sense Cloud instance:

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. Can be used as a Condition on a Workflow level.

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.0.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
        }
    },
    "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.0.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
        }
    },
    "result": {
        "reload_status": "SUCCEEDED"
    }
}

Document References

This document references the following documents:

NameLocationDescription
Universal Templateshttps://docs.stonebranch.com/confluence/display/UC70/Universal+TemplatesUser documentation for creating Universal Templates in the Universal Controller user interface.
Universal Taskshttps://docs.stonebranch.com/confluence/display/UC70/Universal+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
  • No labels