2 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 forOracle 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:

• Quickly create, modify, validate, deploy, and reuse Oracle GoldenGate best practice designs.
• Define data flows once and deploy to numerous locations.
• Graphically filter, map, and transform data.
• Apply global rules and exceptions.

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, 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 projects.

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

What can I use GoldenGate Studiofor?

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

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 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.

Concept	Definition
Deployment	The process of setting up and activating your data replication design so it can run in a real environment. A GoldenGate Studio deployment is GoldenGate's instance, configured to run pipelines. Learn how to Register Deployments.
Connection	Contains the connectivity information for source and target databases used in pipelines. Learn how to: Create Oracle Database and Oracle Exadata Connection Create Oracle Autonomous Database Connection
Recipe	A predefined template in GoldenGate Studio that automates the design and creation of data integration solutions, specifying how source and target systems interact. Learn about Recipes.
Pipeline	A pipeline enables replication across diverse database environments. Learn how to Create Pipelines.
Mapping Rules	Rules for including or excluding schemas and tables in a data replication.
Advanced Options	Editable process or load parameters for Extract, Replicat, and data pump operations. Learn more: Initial Load Advanced Options Extract Advanced Options Replicat Advanced Options
Extract	Process that reads or captures database changes from the source database.
Replicat	Process that applies captured changes to the target database.

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.

• GoldenGate Studio doesn't currently support Oracle Cloud Infrastructure GoldenGate deployments.
• GoldenGate Studio works in top down approach. It generates GoldenGate Connections, Extracts, Replicats, and Trail Files based on connections and pipelines created in GoldenGate Studio.
• Existing Connections, Extracts, Replicats, Trail Files in GoldenGate can not be used by GoldenGate Studio pipelines.
• Refrain from changing Extract, Replicat, and parameter files that are generated by GoldenGate Studio. Once these files are changed, editing or running these pipelines from GoldenGate Studio lead to inconsistencies and failures.