Scheduling a qvw reload soon after database is updated

[kkkumar82]

Hi Qlikers,

I have a database (Mysql) in AWS where the data analysts update the data soon after their data cleaning process and intimate me so that I can create the qvds and then after I load the qvd data into a template.

My ask is , is there a way that we can automate this process, such that,

1. Soon after the database is updated the qvd extractor should be executed(reloaded)

2. Soon after the qvd extractor reloading is completed my another file should be reloaded.

can any one suggest me some senarios.

Thanks

Kiran Kumar

[vardhancse]

while creating task in QMC for the QVD generator and app we can create a dependency like on complete the QVD gen task reload the app.

[vardhancse]

task->Triggers<tab>-create new trigger.

Task finished and in details we can give the qvd gen task.

[jonathandienst]

If the cleaning process signalled its completion by dropping a flag file or updating a database table, you could write a batch file that polls for the dropped file or the database table value, and trigger the qvd and application reloads. Set this to run on a scheduled of (for example) every 15 minutes.

This is easier to implement if you have access to an enterprise scheduling tool, or find a suitable freeware or inexpensive scheduling tool that supports this sort of dependency. We do something very like this using AutoSys or Tivoli TWS, but these are enterprise class tools.

The batch file should trigger the qvd reload via EDX (search EDX / QMSEDX on this site for more on how to do this) and then the application reload task can depend on the completion of the QVD reload.

[kkkumar82]

Can you eloborate it from QMC point of view .

Thanks

Kiran Kumar

[kkkumar82]

I didnt see any trigger tab in QMC. probably we dont have publisher.

Thanks

Kiran Kumar

[vardhancse]

Hi Expand the default->Select the QVW

Create one new task, while creating new task we can see the trigger<tab>.