Part I What is Oracle GoldenGate for Heterogeneous Databases?

Oracle GoldenGate is a comprehensive software package for real-time data capture and replication in heterogeneous IT environments.

The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems. Oracle GoldenGate brings extreme performance with simplified configuration and management, support for cloud environments, expanded heterogeneity, and enhanced security.

You can use the following supported heterogeneous databases with Oracle GoldenGate.

• DB2 LUW

• DB2 for i

• DB2 z/OS

• MySQL

• PostgreSQL

• SQL Server

• Teradata

• TimesTen

Each database that Oracle GoldenGate supports has it’s own requirements and configuration.

Many databases contain schemas that are intended for use by the database or the system. In most cases, objects in these schemas should not be automatically replicated through the use of a wildcard specification. For the databases and schemas listed in this book, there are specific schemas or objects that will not be automatically replicated by Oracle GoldenGate unless they are explicitly specified without a wildcard.

This book is divided into parts so that you can easily find information that is relevant to your environment. See Installing Oracle GoldenGate for system requirements and installation details for each of these databases.