Part VI Using Oracle GoldenGate with SQL Server

With Oracle GoldenGate for SQL Server, you can capture transactional data from user tables of supported SQL Server versions and replicate the data to a SQL Server database or other supported Oracle GoldenGate targets, such as an Oracle Database or Big Data target.

Oracle GoldenGate for SQL Server supports data filtering, mapping, and transformations unless noted otherwise in this documentation. And beginning with Oracle GoldenGate 12.3, there will be two separate data capture methods. The first, which is referred to as Classic Capture, is the transaction log based capture method. The second method, newly introduced with Oracle GoldenGate 12.3, is the CDC Capture method. The Classic Extract binary is available at My Oracle Support, under Patches and Updates, and requires a Service Request in order to receive a password to download the binary. The CDC Extract binary is available on the Oracle Software Delivery Cloud.

This part describes tasks for configuring, and running Oracle GoldenGate on a SQL Server database.

• Understanding What's Supported for SQL Server
  This chapter contains the requirements for the system and database resources that support Oracle GoldenGate.
• Preparing the System for Oracle GoldenGate
  This chapter contains steps to take so that the database with which Oracle GoldenGate interacts is correctly configured to support Oracle GoldenGate capture and delivery. Some steps apply only to a source system, some only to a target, and some to both.
• Preparing the Database for Oracle GoldenGate — Classic Capture
  This section contains information that helps you configure database settings and supplemental logging to support Classic Capture of source transaction data by Oracle GoldenGate.
• Preparing the Database for Oracle GoldenGate — CDC Capture
  Process to configure database settings and supplemental logging to support CDC Capture.
• Requirements Summary for Classic Extract in Archived Log Only (ALO) Mode
  Oracle GoldenGate for SQL Server includes a feature of capturing DML from only the SQL Server transaction log backups GoldenGate can run on the database server in an ALO configuration, or optionally, GoldenGate can be installed and run on a middle tier Windows server. It should be pointed out that when using an ALO mode configuration, replication will have an induced lag which will be based on the log backup interval as well as the time it takes to complete writing out each log backup during that interval, and the time that it takes the Extract to fully process the log backup file.
• Requirements Summary for Capture and Delivery of Databases in an AlwaysOn Availability Group
  Oracle GoldenGate for SQL Server features Capture support of the Primary and read-only, synchronous mode Secondary databases of an AlwaysOn Availability Group, and Delivery to the Primary database.
• Oracle GoldenGate Classic Extract for SQL Server Standard Edition Capture
  Classic Extract for Oracle GoldenGate for SQL Server is designed to capture DML from both SQL Server Standard Edition and SQL Server Enterprise Edition.
• CDC Capture Method Operational Considerations
  This section provides information about the SQL Server CDC Capture options, features, and recommended settings.