Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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 (7)
1 Reply
PadmaPriya
Support
Support

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!