Introduction

Learn about GoldenGate Studio concepts to help you get started.

About GoldenGate Studio

GoldenGate Studio helps you to design and deploy high-volume, real-time replication by automatically handling table and column mappings and generating best practice configurations from recipes. With GoldenGate Studio, you can start replicating data using a simple interface. GoldenGate Studio supports features such as multiple deployment management, authentication using Oracle Wallet for secure credential management for Oracle Autonomous AI Database, and validation utilities like Test Connection for reliable environment setup.

GoldenGate Studio is available in two editions: a free version with community-based support, and a commercial version. The commercial is ideal for organizations that require comprehensive Oracle Support, including access to regular upgrades and patches, ensuring a stable and maintainable environment for production use. This edition is particularly beneficial for organizations running mission-critical workloads, as it offers the ongoing support and regular updates necessary to keep complex environments secure and up to date. By providing full Oracle Support, the commercial version ensures smooth operations and minimizes risk for enterprise data integration initiatives.

Note: The Database Migration recipe is now available. For MySQL, only One-way Database replication and Database Migration recipes are supported. Oracle AI Database supports One-way Database replication, Database Migration, Active-Active Database Replication and ZeroETL Mirror recipe. Check Supported Oracle Databases and Supported MySQL Databases.

GoldenGate Studio delivers an enterprise-ready platform with advanced features, broader compatibility-including support for newly added Oracle and MySQL databases-scalable deployment options, and access to Oracle support.

GoldenGate Studio provides you with the following abilities:

Who is GoldenGate Studio for?

GoldenGate Studio is ideal for database administrators, architects, and IT professionals responsible for setting up and maintaining data integration and replication solutions.

GoldenGate Studio is ideal for a wide range of users involved in data integration and replication projects, especially database administrators, data architects, and IT teams responsible for doing replication across multiple Oracle databases and locations. For those already using GoldenGate Studio, GoldenGate Studio will enhance the experience by offering a highly intuitive, visual interface that significantly simplifies the process of designing, deploying, and managing replication environments. Its guided workflows make it easy to configure and monitor even complex data integration setups, reducing manual effort and streamlining the entire lifecycle of GoldenGate Studio projects.

GoldenGate Studio makes it easier for both new and experienced GoldenGate Studio users to handle everything from simple data integrations to complex, enterprise-wide deployments.

What can I use GoldenGate Studio for?

GoldenGate Studio enables you to visually design, deploy, and monitor end-to-end data replication and integration environments with GoldenGate Studio.

GoldenGate Studio makes it simple and efficient to set up, deploy, and manage real-time data replication solutions across Oracle AI Database. It helps you generate and validate GoldenGate Studio configurations based on best practices-allowing you to quickly build, modify, and reuse replication projects without writing manual scripts. With GoldenGate Studio, you can define powerful data flow designs and deploy them simultaneously to multiple locations, ensuring that data stays synchronized across all your critical systems.

Features like filtering, mapping, and transforming data are easily configured in GoldenGate Studio. This helps you align replication with your specific business logic. Organizations can ensure that only the right data is replicated, in the right format, to meet their operational and analytical needs. This means data replication isn’t just a copy-paste activity; it’s tailored to support your specific use cases, compliance needs, or reporting standards.

GoldenGate Studio Concepts

Get familiar with the following concepts and other commonly used terms before you get started with GoldenGate Studio.

GoldenGate Studio Limitations

Learn about the limitations of using GoldenGate Studio.

There are certain limitations and considerations that you should be aware of when using GoldenGate Studio.