QRS API best practice

[EladKushmaro]

Hi,

We are moving from on-premise QV to on-premise QS.

We need to do the following which on QV we did with SSIS.

We wonder if the best is to do it with Qlik-Cli-Windows or QRS API with Python.

We're not familiar with both.

1. we have 1 on premise Qlik sense server

2. Run every 1/2 hour, all day long

3. Loop over our 12 SQL servers. In each DB, Check if some conditions are met in SQL tables

4. If so, run a specific QS task that is related to the DB

Thanks, Elad.

[APiccoli]

Hello EladKushmaro,

do you have evaluate the possibility to start the specific task, related to the DB with the tables ready, directly from the Qlik Sense Script?

References:
Invoke Reloading task from a loading script
QSR API - Task: Start
Connecting Qlik Sense QRS data via REST connector
How to setup a Data Connection to the QRS API using Certificates on the June 2017 release or higher

I hope this solve your need.
Alberto

[JonnyPoole]

The Qlik-CLI-Windows is widely used to initiate tasks from the command line from an external source (like SSIS) that can call command line programs. If you use python with the QRS API you need to author your own code. This may be necessary in some custom scenarios but if its a simple as triggering a task I'm not sure why you wouldn't use the CLI, it uses standard powershell. There is also an NPrinting CLI and QlikView CLI as this approach has been widely adopted and has spread into other Qlik solutions.

If you are moving to Qlik Sense, I might also recommend the admin playbook, an excellent source of tools and admin tasks for any QLik Sense administrator. 

https://adminplaybook.qlik-poc.com/