Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
kkkumar82
Valued Contributor III

Scheduling a qvw reload soon after database is updated

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

6 Replies
Highlighted
vardhancse
Valued Contributor III

Re: Scheduling a qvw reload soon after database is updated

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.

Highlighted
vardhancse
Valued Contributor III

Re: Scheduling a qvw reload soon after database is updated

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

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

Highlighted
MVP
MVP

Re: Scheduling a qvw reload soon after database is updated

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
kkkumar82
Valued Contributor III

Re: Scheduling a qvw reload soon after database is updated

Can you eloborate it from QMC point of view .

Thanks

Kiran Kumar

Highlighted
kkkumar82
Valued Contributor III

Re: Scheduling a qvw reload soon after database is updated

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

Thanks

Kiran Kumar

Highlighted
vardhancse
Valued Contributor III

Re: Scheduling a qvw reload soon after database is updated

Hi Expand the default->Select the QVW

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