topic Re: Scheduling a qvw reload soon after database is updated in QlikView

Scheduling a qvw reload soon after database is updated

kkkumar82 — Thu, 06 Aug 2015 10:24:02 GMT

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

Re: Scheduling a qvw reload soon after database is updated

vardhancse — Thu, 06 Aug 2015 10:32:16 GMT

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.

Re: Scheduling a qvw reload soon after database is updated

vardhancse — Thu, 06 Aug 2015 10:33:16 GMT

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

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

Re: Scheduling a qvw reload soon after database is updated

jonathandienst — Thu, 06 Aug 2015 10:58:28 GMT

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.

Re: Scheduling a qvw reload soon after database is updated

kkkumar82 — Fri, 07 Aug 2015 07:39:51 GMT

Can you eloborate it from QMC point of view .

Thanks

Kiran Kumar

Re: Scheduling a qvw reload soon after database is updated

kkkumar82 — Fri, 07 Aug 2015 07:47:14 GMT

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

Thanks

Kiran Kumar

Re: Scheduling a qvw reload soon after database is updated

vardhancse — Fri, 07 Aug 2015 08:17:22 GMT

Hi Expand the default->Select the QVW

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