Scheduling reports
Hi all,
we are using Kettle ETL to transmit values from our peripheral systems into our datawarehouse database. Sometimes these jobs lack a little bit longer, sometimes they are in time.
In our reporting and analysis workspace (11.1.2.4) we've scheduled reports. These reports need the transmitted data from our ETL processes. The time frame between the transmission and the scheduled reports is very small because the reports are necessary for the production routines; e.g. the ETL process ends at 06.00 a.m and the scheduled report starts at 06.10 a.m.
If the ETL process ends to late not all the data are processed in the report(s) because it starts at the scheduled time.