topic Re: Qlikview QMC task triggering an external event in QlikView

Qlikview QMC task triggering an external event

nagaiank — Sun, 05 Jun 2016 00:39:07 GMT

Hello All,

I have used EDX to trigger a QMC task from an external event. Completion of a QMC task can be set to trigger another QMC task. Also the Qlikview application can send Alert email for a predefined condition. But what I need is the ability to trigger an external event or launch a web application on successful completion of a QMC task. Is there a way to achieve this? I did not find any post on this in the forum. Appreciate your help and advise. Thanks.

Re: Qlikview QMC task triggering an external event

Peter_Cammaert — Sun, 05 Jun 2016 10:08:42 GMT

Yes

If you have a Publisher, use a Supporting task and some batch scripts or command line tools to trigger third-party applications.
If you don't have a Publisher, you can create a dummy QVW document that contains an EXECUTE statement in the load script. Same effect as above.

Best,

Peter

Re: Qlikview QMC task triggering an external event

Anonymous — Mon, 06 Jun 2016 08:17:11 GMT

Hi Nagaiank,

You could write execute statement in QMC under Supporting task or inside another .qvw document.

Best regards,

Kaveri

Re: Qlikview QMC task triggering an external event

Anonymous — Wed, 22 Mar 2017 17:09:06 GMT

Is there any way to excute a task basis on the external trigger. For example if I need my QMC task to be run as soon I got a mail with specific subject or as simple I open a notepad file ?

Re: Qlikview QMC task triggering an external event

Peter_Cammaert — Thu, 23 Mar 2017 11:43:05 GMT

Yes, there is. But QlikView services will not detect any other situation than simply receiving a signal like an EDX trigger. If you want to make it more complex, you'll have to build an external solution that detects that the proper conditions are being met and sends an EDX trigger to the QlikView Management Service.

Most of these situations can be detected using native tools (for example SQL Server Agent in a MS SQL Server DB) or OS features and can send a signal towards the QMS using QMSEDX.exe. PowerShell or CMD scripting will often provide the glue logic.

If you have one or more specific cases that you want discussed by the community, please open a new discussion.