Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

aparnanair1405
New Contributor II

Application reload trigger.


Hi  Community,

We have a DB server and an application server (2 different server IPs).

I need to trigger the application reload whenever the db load is complete.

Any help is appreciated.

Regards,

ARN.

Tags (1)
Labels (1)
6 Replies
manojkulkarni
Valued Contributor II

Re: Application reload trigger.

You can do this by triggering the application from external program which can sense of DB load complete.

Re: Application reload trigger.

What kind of "DB load"?

manojkulkarni
Valued Contributor II

Re: Application reload trigger.

go through the below link

Using EDX in QlikView 11 - basic example

aparnanair1405
New Contributor II

Re: Application reload trigger.

Hi,

The trigger is required on SQL Server ETL Load.

Regards,

ARN

Re: Application reload trigger.

If I'm not mistaken, a SQL Agent batch job can launch a command line program at the end of a succesful execution. Use QMSEDX as command line tool that allows you to trigger a task in the QMC from any machine in your network.

See Manoj K's link below for more information.

Best,

Peter

MVP
MVP

Re: Application reload trigger.

You could also just have a check of a status flag in a status table in your database that is done in the beginning of your load script to see if it is time for a reload. You could then have this load script to poll every 5 minutes or so - but only do the reload work when the status flag says so.