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.
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".