What’s New in Oracle GoldenGate 12.3
Oracle is pleased to deliver the first Microservices enabled, real-time streaming and replication platform to simplify, manage, and monitor complex deployment environments in private, public and hybrid environments. Oracle GoldenGate 12c Microservices Architecture empowers customers to design, build, embed, and automate all aspects of their replication environment on premise and in the cloud. Customers can now interact with their data and replication architecture from anywhere! Please see below for more details:
GoldenGate 12.3 Platform Features – All Platforms
For the Oracle Database
- Microservices Architecture
A new services based architecture simplifies large scale and cloud deployments. This architecture enables remote and secure configuration, administration, and monitoring capabilities using comprehensive RESTFul interfaces and embedded HTML5 based UI. It enables Applications to embed, automate, and orchestrate GoldenGate across the enterprise.
- Parallel Replicat
Highly scalable apply engine for the Oracle database that can automatically parallelize the apply workload taking into account dependencies between transactions. Parallel Replicat provides all the benefits of Integrated Replicat performing the dependency computation and parallelism outside the database. It parallelizes the reading and mapping of trail files and provides the ability to apply large transactions quickly.
- Automatic Conflict-Detection-Resolution (CDR) without application changes
Quickly enable active/active replication while ensuring consistent conflict-detection-resolution (CDR) without modifying application or database structure. With automatic CDR you can now configure and manage Oracle GoldenGate to automate conflict detection and resolution when it is configured in Oracle Database 12c Release 2 (12.2) and later.
- Procedural Replication to enable simpler application migrations and upgrades
Procedural Replication in Oracle GoldenGate allows you to replicate Oracle-supplied PL/SQL procedures, avoiding the shipping and applying of high volume records usually generated by these operations.
- Database Sharding
Oracle Sharding is a scalability and availability feature designed OLTP applications that enables distribution and replication of data across a pool of Oracle databases that share no hardware or software. The pool of databases is presented to the application as a single logical database. Data redundancy is managed by Oracle GoldenGate via Active-Active replication that is automatically configured through the database engine.
For SQL Server
- Introducing a new, CDC based Capture
Oracle GoldenGate 12.3 introduces a new Change Data Capture based Extract, which offers some new functional advantages over our existing transaction log based capture method.
Benefits include the following:
- Capture from SQL Server 2016
- Remote Capture
- Transparent Data Encryption (TDE) support
- Certification to capture, from an AlwaysOn Primary and/or readable synchronous Secondary database
With an increase in uptake of our customers running their application critical databases in an AlwaysOn environment, Oracle GoldenGate 12.3 is the first version to certify capture from either the Primary database, or a read-only Synchronous Secondary database.
- Delivery to SQL Server 2016
For DB2 z/OS
- Remote Execution
The new remote execution includes both remote capture and delivery for DB2 z/OS. Running Oracle GoldenGate off the z/OS server significantly reduces the MIPS consumption and allows the support of AES encryption and credential store management.
For DB2 i
- Support for IBM i 7.3
Oracle GoldenGate supports the latest DB2 for i platform.
- DDL replication between MySQL DBs
With the DDL replication between MySQL databases, there is no need to stop Oracle GoldenGate replication when there are DDL changes on the source database.
Join us in upcoming events:
- Stay up to date by visiting our Data Integration Blog for up to date news and articles.
- Save the Date! Oracle OpenWorld is in early October, and we look to have a Customer Summit on Thursday afternoon, October 5th, as we have had in the past. Mark your calendars and more to come on that soon.