openESB ETL plugin remarks

Posted by & filed under Enterprise Sevice Bus.

ETL plugin for openESB for small data migration project is awesome. I don’t know how would it work for small data warehouse issue where you get 4 gb of data daily. Maybe fine. But for other small migration project it does the job just fine and first of all it’s amazingly easy to setup. I… Read more »

bpel + ETL + scheduler + db log

Posted by & filed under Enterprise Sevice Bus.

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… Read more »