Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikNoviceNo1
Contributor III
Contributor III

Refresh task in Qliksense QMC based on completion of SQL server job(SSIS)

hi all,

I am new to qliksense and am looking for a simple way to trigger QMC tasks based on completion of my data refresh in SQL server.

 

Labels (3)
1 Reply
PadmaPriya
Former Employee
Former Employee

Hello @QlikNoviceNo1 

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

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!