GoldenGate software was recently acquired by Oracle Corporation as part
of Oracle strategic moves this year. GoldenGate software provides powerful
suite of tools to replicate data between platforms at a high level of
performance with guaranteed transaction reliability. The following products
are part of the service offering from GoldenGate:
-
GoldenGate
Transaction Data Management – The TDM provides high speed data
replication between heterogeneous platforms.
-
GoldenGate
Director – The Goldengate Director (GD provides a graphical monitoring interface for
GoldenGate configurations.
-
GoldenGate
Veridata – The veridata component provides for ensuring that both
source and target database environments are in sync in terms of data
populations.
So,
how does GoldenGate differ from other third party replication solutions such
as that from Quest Shareplex and Oracle’s own replication products such as
Data Guard, Streams and Advanced Replication?
GoldenGate is a replacement for
Oracle heterogeneous replication services, another option for
replicating between different database products.
The
beauty of GoldenGate replication is that it allows for seamless integration
across platforms. For example, if I have a 15TB data warehouse of
Microsoft SQL Server 2008 and I want to replicate a subset of that data to
an Oracle data mart, then GoldenGate allows me to use their single construct
built into their software platform to replicate between these platforms
without complex programming or installations. GoldenGate transaction
replication software consists of several key components:
·
-
GoldenGate manager process which controls
background process behavior.
-
GoldenGate trail files which are the files that
data is stored in as part of replication processing.
-
GoldenGate extract process which performs the heavy
lifting of extracting data from the online or archive redo log files
within an Oracle database.
-
GoldenGate replicat process which applies the
captured data via a change data capture (CDC) process to the target
database environment.
The
major benefit of GoldenGate over Oracle heterogeneous services is the
ability to extract data from various source environments such as SQL Server, Sybase,
Teradata, and DB2 and pump the data into an Oracle data warehouse
environment.
 |
If you like Oracle tuning, you may enjoy my new book "Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
