Why use GoldenGate in ETL?
Posted by Dylan Wan on February 15, 2013
The traditional way of doing ETL nightly is no longer satisfying the requirements. In the past, we have the ETL “window” to perform ETL. The ETL processes typically run as daily or nightly ETL. We can use the downtime to execute some processes in the OLTP systems to extract their data while we can still avoid the impacts to the transaction processing system.
Nowadays, there are many cases of no downtime and no ETL window.
GoldenGate provides the unique benefit of constantly feeding the data from the OLTP system. The data are replicated spreading over the day without introducing much impact to the source system.