Qlik Sense Cmdlet for PowerShell

Qlik Sense Cmdlet for PowerShell

Sokkorn CHEAV

Qlik Sense Cmdlet for PowerShell

Table of Contents

1. Introduction........................................................................................................................................................2 2. Why this document? ..........................................................................................................................................2 3. Tested Environment ...........................................................................................................................................2 4. Installation..........................................................................................................................................................2 6. Command Test Case ...........................................................................................................................................4

6.1 View a list of available commands .............................................................................................................4 6.2 View help for specific command ................................................................................................................4 6.3 Connect to Qlik Sense Server .....................................................................................................................4 6.4 Import QVF.................................................................................................................................................5 6.5 Publish QVF ................................................................................................................................................5 6.6 Trigger Task ................................................................................................................................................6 6.7 Export QVF .................................................................................................................................................7 6.8 Auto Import and Publish App Using Window Task Schedule.....................................................................7 6.9 Archive QVF and delete backup files older than 7 days.............................................................................9

Page 1 of 10

Qlik Sense Cmdlet for PowerShell

1. Introduction

Qlik-Cli is a PowerShell module that provides a command line interface for managing a Qlik Sense environment. The module provides a set of commands for viewing and editing configuration settings, as well as managing tasks and other features available through the APIs. You can find original Qlik-Cli in GitHub by click this link

2. Why this document?

The main purpose of this document is to provide some of use case function where we can't find in GitHub. A common scenario: a. Triggering tasks from an external application b. Auto import and publish app to QMC c. Backup QVF

3. Tested Environment

Below server environment has been successfully tested with 1. Windows Server 2016 Standard 2. Qlik Sense June 2017

4. Installation

The installation of Qlik-Cli is very simple. Here is the step: 1. Download the package from here 2. Extract the package into [C:\Windows\System32\WindowsPowerShell\v1.0\Modules\Qlik-Cli]

Page 2 of 10

Qlik Sense Cmdlet for PowerShell

MUST READ:

a. If you download package from point 4.1 and has same "Tested Environment", no issue occur.

b. If you download package from original GitHub and has same "Tested Environment", the PowerShell

will not work. To overcome the issue, you must amend script in file "Qlik-Cli.psm1" by adding

$result = Invoke-WebRequest -Uri ""

below line

[.ServicePointManager]::CertificatePolicy

=

New-Object

TrustAllCertsPolicy

Page 3 of 10

Qlik Sense Cmdlet for PowerShell

6. Command Test Case

6.1 View a list of available commands

Command:

Get-Help Qlik

6.2 View help for specific command

Command:

Get-Help Connect-Qlik

6.3 Connect to Qlik Sense Server

Command:

Connect-Qlik

Page 4 of 10

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download