Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

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.





Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s