1 Reply Latest reply: Dec 29, 2015 11:52 AM by Peter Cammaert RSS

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

    John Sumesh

      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.