Automatic generation of QVD

[JishnuGS]

Hi Team,

Is there anyway we can generate QVD automatically when the data is been updated in Database. 

Please help me with some info.

Thanks,
Jishnu

[Steven_Haught]

@JishnuGS 

What is your trigger to know when the data base has been updated? I know that you can set up time triggers for the running of the QVD, could you not set up the trigger to run periodically to capture the new data? 

[QFabian]

Hi, i saw this in a customer:

1.- A store procedure (sp) is triggered to update the data in a table

2.- Then the sp just write a text file with a variable set on 1

3.- The Qlikview document is schedule to reload every half hour

4.- the first thing that that script do is read the file, and if the variable is set on 1, with an if, the process do all the script, if the variable is set on 0, the if just finish the script

4.- and the final script line is setting the variable to 0.

[QFabian]

Another way is With QlikView Server and QlikView Publisher you can start tasks from external event

check on this

https://community.qlik.com/t5/QlikView-Documents/Using-EDX-in-QlikView-11/ta-p/1478952

[JishnuGS]

@Steven_Haught  

I don't want to set up a trigger to run periodically. Is there anyway Qlik can know whether the data is updated in DB or not ?

[Steven_Haught · Accepted solution]

@JishnuGS 

I am not sure that Qlik can go and read from an external source and then know to load, not without doing so in the load statement as mentioned in the example above. 

May I ask why you would not want to run a periodic reload of the data and QVD? Seems to be the simple solution. We do it internally with a couple of sales databases that flow in throughout the day works very well to capture the data...