Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Automate qlik sense qvf file deployment through QMC

Hello Experts ,

i am working on automation  of  auto deployment QlikSense file, so need your assistance to achieve below automation challenge.

We are having one QVF file which we want to import and publish through QMC.

We want to connect QMC server through any desktop , is there any way to deploy QVF file through any command or API or websocket or any other way , through which i will be able to connect QMC server and do import and publish my QVF file.

 

any help will be highly appreciable.

Labels (1)
2 Replies
Highlighted
Partner
Partner

You should check out the Qlik Engine API.

https://help.qlik.com/en-US/sense-developer/February2019/APIs/EngineAPI/index.html

Good luck!
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Partner
Partner

Dear getabhishek1

 

You can use Qlik-Cli to perform this automation. Please follow those steps:

 

1.) Ensure that you have PowerShell 5.x in your computer.

 

2.) Download Qlik-Cli from the following URL: https://github.com/ahaydon/Qlik-Cli

 

3.) Extract it to C:\Program Files\WindowsPowerShell\Modules\Qlik-Cli

 

4.) Open C:\Program Files\WindowsPowerShell\Modules\Qlik-Cli\Qlik-Cli.psm1

and add after

[System.Net.ServicePointManager]::CertificatePolicy = New-Object TrustAllCertsPolicy

the following line

$result = Invoke-WebRequest -Uri "https://IpAddress/resource"

 

5.) Import the module by running the following command in PowerShell > Import-Module Qlik-Cli

 

6.) Ensure that the module has been installed with the following command in PowerShell > Get-Help Qlik

 

7.) Try to connect with a Certificate to Qlik Sense

 

Get-ChildItem cert:CurrentUser\My | Where-Object { $_.FriendlyName -eq 'QlikClient' } | Connect-Qlik qliksense_hostname

 

Example

Get-ChildItem cert:CurrentUser\My | Where-Object { $_.FriendlyName -eq 'QlikClient' } | Connect-Qlik vmqlik

 

8.) Import the target application with the following command in PowerShell

 

Import-QlikApp <Application File> -upload

 

Example

Import-QlikApp '.\ABC Invoice Check.qvf' -upload

 

Note down the id from the import command.

 

9.) Publish the application to a stream

 

Publish-QlikApp -id <Application ID from Step 7> -stream <Stream Name>

 

Example

Publish-QlikApp -id 352d77d8-6902-446e-b80e-848a67c617fc -stream Everyone

 

I have tried the aforementioned commands on a virtual machine with the following specs:

  • Windows Server 2012 R2
  • PowerShell 5.1
  • Qlik Sense November 2018 SR2

 

If you want to fully automate this process you should write a script which:

  • Gets the application file path.
  • Isolates the ID produced during the application import.
  • Pushes the ID to the Publish command.

 

Sorry for the long post!

 

Best regards,

Ilias

We're entering a new world in which data may be more important than software.