Book Image

Oracle Goldengate 12c Implementers Guide

By : John P Jeffries
Book Image

Oracle Goldengate 12c Implementers Guide

By: John P Jeffries

Overview of this book

The book is aimed at Oracle database administrators, project managers, and solution architects who wish to extend their knowledge of GoldenGate. The reader is assumed to be familiar with Oracle databases. No knowledge of GoldenGate is required.
Table of Contents (16 chapters)
12
A. GGSCI Commands
13
B. GoldenGate Installed Components
14
C. Acronyms
15
Index

Oracle GoldenGate evolution


GoldenGate Software Inc was founded in 1995. Originating in San Francisco, the company was named after the GoldenGate strait that connects San Francisco Bay to the Pacific Ocean by its founders Eric Fish and Todd Davidson. The tried and tested product that emerged quickly became very popular within the financial industry. Originally designed for the fault-tolerant Tandem computers, the resilient and fast data replication solution was in demand. Banks initially used GoldenGate software in their ATM networks to send transactional data from high street machines to mainframe central computers. The data integrity and guaranteed zero data loss is obviously paramount and plays a key factor. The key architectural properties of the product are:

  • Data is sent in real time with sub-second speed.

  • It supports heterogeneous environments across different database and hardware types. Being fully transaction aware, GoldenGate maintains read-consistency and referential integrity between source and target systems.

  • It renders high performance with low impact; able to move large volumes of data very efficiently while maintaining very low lag times and latency.

  • It offers seamless data integration with ETL products and technologies.

  • It has a flexible modular architecture.

  • It is reliable and extremely resilient to failure and data loss. No single point of failure or dependencies and is easy to recover.

Oracle Corporation acquired GoldenGate software in September 2009 and is certified to support operational reporting solutions for major Oracle applications, including Oracle E-Business Suite, JD Edwards, PeopleSoft, and Siebel CRM.