Oracle Goldengate: Part 1 - An Introduction

Oracle Goldengate(GG) is one of the key products of Oracle’s Data Integration product portfolio.

Oracle Buys GoldenGate Software

Adds Leading Real-time Data Integration Solution to Create Comprehensive Heterogeneous Data Integration Platform

Redwood Shores, Calif, July 23, 2009 ( http://www.oracle.com/us/corporate/press/022092 )

Oracle GoldenGate provides low-impact capture, routing, transformation, and delivery of transactional data across heterogeneous environments in real time.

Oracle Goldengate Key differentiators

  • Low Performance Impact:

Oracle GG capture process has minimum overhead on source and target database system. It just constantly reads transaction logs and converts them into its transaction format written inside the trial files. Compared to the similar replication tools it has the flexibility of reading the transaction information without depending on the source database software brings a unique differentiator to GG.

  • Flexible and Extensible

GG has the flexibility of running between heterogeneous source and target systems.

Let’s explain with some examples:

Source system MS SQL server  -->  Target system Oracle

Source system IBM DB2 -->  Target system Sybase

Source system MS SQL server -->  Target system MS SQL server

Source system Oracle 10.2.0.4 on AIX --> Target system Oracle 11.2.0.2 on Linux x86 and so on..

It is not a big deal to upgrade a source or target Oracle system of Goldengate from 11.2.0.1 to 11.2.0.2 for instance, because it just captures from Oracle’s transaction logfiles.

  • Reliable

Oracle Goldengate is so resilient to the failures of source – target or connectivity issues. Its reliability is proved by lots of mission critical systems of leading companies.

Oracle Goldengate Use Cases:

Same Oracle GoldenGate software can be used for several different purposes like:

  • Disaster Recovery
  • Zero downtime migrations – Upgrades
  • Operational Reporting
  • Real-time BI
  • Query Offloading
  • Distributed Data Management

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Oracle ECEMEA Partner Hubs Migration Center Team

We share our skills to maximize your revenue!
Our dedicated team of consultants can rapidly and successfully assist you to adopt and implement the latest of Oracle Technology in your solutions.

Stay Connected
partner.imc
@
beehiveonline.oracle-DOT-com
Google+

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
4
5
6
9
10
11
12
13
14
16
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today