Simple idea of how to use openESB and scheduled invocation of ETL process and store log data in database. Best ETL method is “Stagging” that uses “stagging table”. It simply transfers a bunch of rows from one db to another firstly to the middle buffer table and then to the target one. No delays, no empty tables, and data always fresh and ready for processing :)