This post is over a year old, some of this information may be out of
date.
Possible options:
- Write your own self open source ETL tools - Pentaho Data Integration and Open Studio for Data Integration
- This is newly discovered which works on self-generated database triggers - an open source database replication solution - SymmetricDS
- Based on Oracle, you will have Data Pump, Golden Gate, Materialized Views, Database Change Notification
But take note of Best Practises section in Database Change Notification:
If there are frequent and a large number of notifications, it can slow down OLTP throughput due to the overhead of generating the notifications.