Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-12-29 11:48 AM

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.

465 Views
1 Reply
Peter_Cammaert
Partner - Champion III
Partner - Champion III
‎2015-12-29 11:52 AM

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

340 Views