In 2009 Oracle acquired a company called GoldenGate. GoldenGate offered software for real time data integration. The Oracle GoldenGate product is often mistaken for an ETL tool, but this is not what it is. But where can the value for Oracle GoldenGate be found?
When we look at the possibilities of real time data integration, the business case can be quite simple. Replication of an online database. But there are lots more implementations of Oracle GoldenGate that can be of interest. Here we can think about replicating databases for high availability, zero downtime configurations, live reporting, business intelligence replication or integration within a SOA environment.
Oracle GoldenGate uses the Database transition logs to determine what data is affected. This is a completely different approach than other replication software, that most of the time simply mirrors database. This technology is also the foundation why we can do real time data integration. Less data (e.q. only the transactions made) means less time transmitting. Sounds simple enough right?
Oracle GoldenGate can apply this technology not only on Oracle Databases, but also on IBM DB2, Microsoft SQL Server, MySQL, Sybase ASE, Teradata, SQL/MP, SQL/MP, TimesTen and Enscribe. With this pretty complete offering, a lot of solutions are possible. What to think about mirroring an Oracle database to a MySQL instance to create a relatively cheap backup? Or a heterogeneous environment consisting of mainframes, SQL Servers, DB2’s and Sybase into one Oracle Database for consolidation?
In the Oracle GoldenGate 11g Implementer’s guide by John P. Jeffries we see a various way of implementation possibilities for GoldenGate. Jeffries shows some examples of GoldenGate architecture, like one-to-one for disaster recovery and bi-directional data integration on active systems.
When talking about high availability, we Oracle people immediately think Real Application Clusters, RAC. I hope. Fortunately, Oracle GoldenGate can be completely integrated with Oracle RAC. This means that we actually create a high-availability scheme, based on standard Oracle RAC, using the possibilities that GoldenGate offers us.
Especially when we’re talking large amounts of data, in complex database and data integration environments, Oracle GoldenGate can offer us huge advantages. It certainly is worth the effort of investigating and it’s a pity not everyone in the Oracle world is familiar with the technology.
You can find the Oracle GoldenGate 11g Implementer’s Guide here.Oracle GoldenGate Patterns,