Table of Contents
- Title and Copyright Information
- Preface
-
Part I Using Oracle GoldenGate for DB2
LUW
- 1 Understanding What's Supported for DB2 LUW
- 2 Preparing the System for Oracle GoldenGate
- 3 Configuring Oracle GoldenGate for DB2 LUW
-
Part II Using Oracle GoldenGate for DB2
for i
-
4
Understanding What's Supported for DB2 for
i
- Supported DB2 for i Data Types
- Non-Supported DB2 for i Data Types
- Supported Objects and Operations for DB2 for i
- Non-Supported Objects and Operations for DB2 for i
- Oracle GoldenGate Parameters Not Supported for DB2 for i
- Supported Object Naming Conventions
- Port Requirements for DB2 for i
- System Schemas for DB2 for i
- Supported Character Sets
- 5 Preparing the System for Oracle GoldenGate
-
6
Configuring Oracle GoldenGate for DB2 for i
- What to Expect from this Procedure
- Getting Started with Oracle GoldenGate
- Creating the Oracle GoldenGate Instance
- Creating a GLOBALS File
- Creating a Data Definitions File
- Enabling SSL
- User Profiles and Security Privileges
- Encrypting the Extract and Replicat Passwords
- Configuring Extract for Change Capture from DB2 for i
- Configuring Replicat for Change Delivery to DB2 for i
- Next Steps in the Deployment
- When to Start Replicating Transactional Changes
- Testing Your Configuration
-
7
Instantiating and Starting Oracle GoldenGate Replication
- About the Instantiation Process
- Overview of Basic Oracle GoldenGate Instantiation Steps
- Satisfying Prerequisites for Instantiation
- Making the Instantiation Procedure More Efficient
- Configuring the Initial Load
- Adding Change-Capture and Change-Delivery processes
- Performing the Target Instantiation
- Monitoring Processing after the Instantiation
- Backing up Your Oracle GoldenGate Environment
- Positioning Extract After Startup
- 8 Using Remote Journal
-
4
Understanding What's Supported for DB2 for
i
- Part III Using Oracle GoldenGate for DB2 for z/OS
-
Part IV Using Oracle GoldenGate for
MySQL
- 12 Understanding What's Supported for MySQL
-
13
Preparing and Configuring the System for Oracle GoldenGate
- Database User for Oracle GoldenGate Processes for MySQL
- Ensuring Data Availability
- Setting Logging Parameters
- Database Connection
- Setting the Session Character Set
- Preparing Tables for Processing
- Changing the Log-Bin Location
- Configure Bi-Directional Replication
- Configuring MySQL for Remote Capture
- Configuring a Two-way SSL Connection in MySQL Capture and Delivery
- Capturing using a MySQL Replication Slave
- Other Oracle GoldenGate Parameters for MySQL
- Positioning Extract to a Specific Start Point
- 14 Using DDL Replication
- 15 Using Oracle GoldenGate with MySQL Group Replication
-
Part V Using Oracle GoldenGate for PostgreSQL
- 16 Understanding What's Supported for PostgreSQL
- 17 Preparing the Database for Oracle GoldenGate
- 18 Configuring Extract
- 19 Configuring an Initial Synchronization for a PostgreSQL Source Database using Precise Instantiation
- 20 Configuring Replicat
- 21 Additional Considerations
-
Part VI Using Oracle GoldenGate for
NonStop SQL/MX
- 22 Understanding What's Supported for NonStop SQL/MX
- 23 Preparing the Database for Oracle GoldenGate
-
24
Preparing the System for Oracle GoldenGate
- Configuring Oracle GoldenGate to Support Tables with a SYSKEY or Clustered Key
- Define an ODBC data source
- Specifying Object Names in a SQL/MX Configuration
- Disable Triggers and Cascade Constraints on a SQL/MX Target
- Configure ODBC to Prevent Timeouts on a SQL/MX Target
- Specify Connection Authentication on a SQL/MX Target
- Supply a Data Definitions File on a NonStop Target
- 25 Configuring Manager and Other Processes
-
Part VII Using Oracle GoldenGate for SQL
Server
- 26 Understanding What's Supported for SQL Server
-
27
Preparing the System for Oracle GoldenGate
- Prepare Database Users and Privileges
- Configure a Database Connection
-
Preparing Tables for Processing
- Disabling Triggers and Cascade Constraints on the Target
- Replicat Consideration for Target Identity Columns, Triggers, and Constraints
- Setting the NOT FOR REPLICATION flag for Target Identity Columns, Triggers, and Constraints
- Ensuring Row Uniqueness in Source and Target Table
- Improving IDENTITY Replication with Array Processing
- Globalization Support
- 28 Preparing the Database for Oracle GoldenGate — CDC Capture
- 29 CDC Capture Method Operational Considerations
- 30 Requirements Summary for Capture and Delivery of Databases in an Always On Availability Group
-
Part VIII Using Oracle GoldenGate for
Teradata
-
31
Understanding What's Supported for Teradata
-
Supported Teradata Data Types
- Limitations of Support for Numeric Data Types
- Limitations of Support for Single-byte Character Data Types
- Conditions and Limitations of Support for Multi-byte Character Data
- Limitations of Support for Binary Data Types
- Limitations of Support for Large Object Data Types
- Limitations of Support for Date Data Types
- Limitations of Support for IDENTITY Data Types
- Supported Objects and Operations for Teradata
- Non-Supported Operations for Teradata
-
Supported Teradata Data Types
- 32 Preparing the System for Oracle GoldenGate
- 33 Configuring Oracle GoldenGate
- 34 Common Maintenance Tasks
-
31
Understanding What's Supported for Teradata
- Part IX Using Oracle GoldenGate for Oracle TimesTen