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

Chapter 7. Advanced Configuration

Replication has traditionally been associated with high availability and disaster recovery applications. In recent years, the scope has changed; replication is being used more for data warehouse loading and online upgrades or migration of applications. Oracle has addressed the increase in data volume and replication performance by integrating its products to provide robust and feature-rich Enterprise solutions.

When coupled with Oracle Data Integrator (ODI), GoldenGate can provide an end-to-end real-time data delivery solution that performs complex data selection, mapping, and transformation within the data replication stream. The topology consists of two main parts: data delivery and data transformation, the latter being the responsibility of ODI.

In this chapter, we will dive into the advanced configuration features provided in the GoldenGate product and discuss the Extract, Load, and Transform (E-LT) configuration and architecture of ODI. This...