How to start QlikSense task externally

[ramkrishna86]

Hi,

Can anyone suggest how to start a QlikSense Server task externally using ssis scheduler?

Actually we use Microsoft SSIS to update our SQL data table. When table is updated we would like to start a reload task on our QlikSense server for an app.

As of now our tasks are scheduled independent of SQL table but now we want to automate reload task of an app just after SQL table update.

Thank,

Ram Krishna

[pangodream]

I use this https://www.pangodream.es/how-to-invoke-a-qlik-sense-task-from-node-js 

[PadmaPriya]

To Load the data into the app. Please refer to below link:
https://help.qlik.com/en-US/sense-developer/2.0/Subsystems/EngineAPI/Content/CreatingAppLoadingData/...

To automate reload task of an app just after SQL table update. Please refer to below article:
https://github.com/marcusspitzmiller/QlikSenseTask

Also there is an extension to reload the task. Please refer below link:
https://www.pangodream.es/how-to-invoke-a-qlik-sense-task-from-node-js

The easiest way is to add a new task at the end in the SSIS package (Execute Task) which just needs the command line so it will be path to your .qvw with a /r switch.
This might help ... http://community.qlik.com/message/41323#41323

Let us know your feedback.

Thanks,

Padma Priya

Senior Technical Support Engineer-Qlik Support