Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

How to automate QVW reload based on a data change(add/delete/modify) in SQL Server

The whole purpose of this scenario is to trigger the Qlikview ETL to start only if there is a change in the Data,instead of fixed schedule in QMC.

Eg: I have an ETL that run three QVS(Product/Customer/Market) and create respective QVD's which is fine and runs on 30mins schedule,what I really need is some mechanism to run the QVS's in the QVW to run only, if there is a change in the respective table in SQL Server associated with that QVS.

I am sure many of you have faced similar scenario's in your projects,any help would be appreciated.

1 Reply

Re: How to automate QVW reload based on a data change(add/delete/modify) in SQL Server

Configure the SQL server agent to launch a batch/command file upon a specific condition occurring in the database. The batch file can use the QMSEDX Enhanced‌ command line tool to trigger a preprogrammed QDS task that is waiting "on an external event".

Best,

Peter

Community Browser