Trigger Qlik Sense task from SQL Server Query

[Sai_Krishna]

Hi Team,

We have Qlik Sense and SQL Server in different servers. I want to trigger Qlik task soon after data is loaded to database. Currently Qlik task is scheduled for every 5 minutes to check and load data. Customer want to have real time refresh and I see this is better option.

Kindly let me know options to trigger qlik task from sql server through query.

Regards,
Sai krishna.

[Anil_Babu_Samineni]

I am not that familiar whether you can batch script after success of SQL? But, If you have control+M this job is so easy.

[Sai_Krishna]

Hi Anil,

Thanks for your reply. Yes, we can trigger batch files from SQL server. Can
you please help me with the script that should go in the batch file to
start a *qlik sense task?*

[Anil_Babu_Samineni · Accepted solution]

Great, You can create batch script like this

1) Download this tool : https://github.com/eapowertools/QlikSenseTask 

2) Create batch like, Here below QlikSenseTask.exe is your tool which you download from Github

<Server File share>\QlikSenseTask\bin\Debug\QlikSenseTask.exe -task:"QlikSense Task Name" -proxy:https://<Central Node Server Name> -wait:60
exit

[Sai_Krishna]

Thanks for clear instructions Anil. It is working fine.