Objective: In this article we are going see the brief Introduction of Oracle Goldengate.

Oracle Goldengate is a strategic solution to real time data integration.

GoldenGate enables the exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms across the enterprise.

It moves committed transactions with transaction integrity and minimal overhead on your existing infrastructure.

Its modular architecture gives you the flexibility to extract and replicate selected data records, transactional changes, and changes to DDL (data definition language) across a variety of topologies.

• If a data pump is not used, Extract must send the captured data operations to a remote trail on the target.

• Data pump and replicate can perform data transformation.

• You can use multiple Replicate processes with multiple Extract processes in parallel to increase throughput.

• Collectors is by default started by Manager (dynamic Collector), or it can be manually created (static). Static Collector can accept connections from multiple Extracts.

Supported Source Databases:

• c-tree

• DB2 for Linux, UNIX, Windows

• DB2 for z/OS

• MySQL

• Oracle

• SQL/MX

• SQL Server

• Sybase

• Teradata

Supported Target Databases:

• c-tree

• DB2 for iSeries

• DB2 for Linux, UNIX, Windows

• DB2 for z/OS

• Generic ODBC

• MySQL

• Oracle

• SQL/MX

• SQL Server

• Sybase

• TimesTen

Supported Oracle databases:

• Oracle 9i R2

• Oracle 10g R1 and R2

• Oracle 11g R1 and R2

• Microsoft SQL Server 2008

• IBM DB2 9.1, 9.5 and 9.7

• Sybase 15.0 and 15.5

• SQL/MX 2.3 and 3.1

Supported Operating Systems:

• Windows Server 2008 R2

• Windows Server 2008 with SP1+

• Windows 2003 with SP2+/R2+

• Windows 2003

• Oracle Linux 6 (UL1+)

• Oracle Linux 5 (UL3+)

• Oracle Linux 4 (UL7+)

• Red Hat EL 6 (UL1+)

• Red Hat EL 5 (UL3+)

• Red Hat EL 4 (UL7+)

• Solaris 11

• Solaris 10 Update 6+

• Solaris 10 Update 4+

• Solaris 2.9 Update 9+n

• HP-UX 11i

• AIX 7.1 (TL2+)

• AIX 6.1 (TL2+)

• AIX 5.3 (TL8+)

• zOS 1.08 , 1.09 , 1.10 , 1.11 and 1.12

Varun Kapila

Add comment