Start reloading QV applications as soon as Datawarehouse loadings are done
Hi, I want to start my tasks in the managment console as soon as the datawarehouse loadings are complete. Wheather loadings are done or not is found out with a simply select towards the DB. What would you say is the easiest way to solve this? Thanks in advance, br Paul
I whatever environment controls you Data Warehouse batch add an additional task at the end of succeful competion of this to make and EDX cal lto start your QlikView refresh jobs.
Our IT Operations department uses Control-M to trigger EDX tasks as tables in the data warehouse complete their nightly updates. This allows some QlikView apps to begin their data reloads even before the entire data warehouse is finished with its nightly processing.
Same for us. The Control-M schedule manages the end to end process across different technoligies and platforms. The database batch jobs for the warehouse are then followed immediately by the EDX triggered QlikView refresh tasks.
