This book teaches the basics of Oracle GoldenGate, which is a product that is used to simplify the process of Oracle Database Replication. GoldenGate can be used for reporting, failover, high availability, live reporting, data warehousing, and BigData ETL process, as well as connecting to multiple other data sources outside of Oracle Database such as SQL Server, MySQL, Teradata, PostgreSQL, and many others. The purpose of GoldenGate and its popularity is its ability to make the highly complex architecture of database replication into a much more simplistic task. This book teaches the reader how to use Oracle GoldenGate, from installation to troubleshooting.
Table of Contents
List of Figures
List of Tables
About the Author
Chapter 1 GoldenGate Architecture
Chapter 2 Installing GoldenGate
Chapter 3 Configuring GoldenGate
Chapter 4 Basic GoldenGate Administration
Chapter 5 Loading Data into GoldenGate
Chapter 6 Applying Replication
Chapter 7 Wrapping It Up
Gavin Powell is an experienced professional database subject matter expert after spending thirty years as an IT professional, doing interesting things like database architecture, DBA work, performance tuning, trouble shooting and even development. Around the end of the DOT Com era, Gavin added technical writing to his many activities and now has over twenty titles published in print and online. Gavin has worked in leadership, operational and functional development roles, including complex OLTP and warehouse/Big data installations. Gavin has worked extensively with multiple relational, Big data and object databases, including Oracle, Hadoop, MySQL, PostgreSQL, Netezza, and quite a few more. Gavin has a BSc in Computer Science, has almost completed a leadership MBA, is a semiprofessional songwriter, a Berklee trained vocalist and performer; but is also an average downhill skier and is only vaguely useful as a speed-skater.