Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have to start reload of a QV document once the daily ETL load is completed. A text file will be created in QV server once the ETL jobs are completed. The QV server has to check for this file and when it is present the reload has to be started.
We do not have publisher available and so this has to be done in QV Management console. I have gone through few other discussion related to starting a reload based on external event but could not find any details. I can also find the option to reload a document on external event in the 'Reload' tab in the Management Console but no options available except password.
I hope someone should have already done this and it will be great if you van help me with this.
Thanks,
Haneesh
hi haneesh,
You can have a work around on this.
Create a variable VTest in your reloading application use the below code
;
if
len(trim(VTest)) = 0 thenexit
script;
end
if
Haneesh
In that case I prefer to use command line utility QlikviewDistributionService.exe - this is QVS reload command line utility.
example
"C:\Program Files\QlikView\Publisher\Distribution Service\QlikviewDistributionService.exe" -r="D:\QlikView\Production\Data\QVDReceipts.qvw" -out="D:\QlikView\Tasks\QVDReceipts.txt"
This utility could be used from ms sql server agent, windows scheduler or any other scheduler, therefore could be easilly synchronized with any other tasks.
Ramunas
Thanks Ramunas.
Can you also clarify the following,
1. How this batch file should be scheduled so that this is executed once the file is available after the ETL load (the ETL jobs are run in a seperate server and a file will be saved in the QV server after the ETL job is completed)
2. Is it possible to reload multiple QV documents in a single batch file.
Thanks,
Haneesh
Are you doing this in windows scheduler?
No, this is in MS SQL Server Agent, but similar you can organize jobs in windows scheduler.
Ramunas
ok..Thanks a lot. I will try this using Windows Scheduler
-Haneesh