Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In my company we have several QV servers, in Europe and in the US, and we have a use case where we would like to:
- reload a document using European QV server - because the data is in Europe
- copy the document to the US QV server - because the report needs to be accessed from the US
- distribute this document with the US QV server
in an automated way, ideally visible as one scheduled task from the European QV Management console.
So that users can also manually trigger it.
Note that the european server does not have a publisher license, but the US server has it.
I see currently 2 options to achieve this, can you tell me what would be the best option, or propose other ideas:
1. write a small C# tool using the QlikView Management API of both servers
cons: needs a windows machine to manually trigger it
2. no C# development, just use existing management console trigger mechanism:
a. add at the end of the load script a line to copy the reloaded qvw file to the US server
b. schedule distribution on the US server every 5 minute AND on successful event from another task? -> but which task to use? Database command task which would check the last reload of the document, and return "success" if last reload > last distribution, otherwise "error"?
Please advise
Thank you
Thanks for you reply,
actually only the US server has publisher
Thanks
I think what you suggest is better, as we don't rely on a database server anymore.
I've already implemented my solution using database logging and it's working as it should,
but we might actually switch to your option in the future to have something more robust.