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 for Oracle Autonomous Databases, 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.
GoldenGate Studio delivers an enterprise-ready platform with advanced features, broader compatibility, 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 Studio for?
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 databases. 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.
Comparing GoldenGate Studio Versions
Explore the differences between the previously released GoldenGate Studio Free 23.7 and the current GoldenGate Studio 23.9 offerings. GoldenGate Studio 23.9 is available in Commercial and Free version.
| Feature | GoldenGate Studio Free 23.7 | GoldenGate Studio 23.9 Commercial and Free |
|---|---|---|
| About | GoldenGate Studio Free 23.7 is designed as an entry-level, easy-to-use version for individuals or teams exploring data replication or working with non-production and small-scale Oracle databases. | GoldenGate Studio 23.9 Commercial and Free provides the full suite of enterprise replication features for robust, large-scale, and mission-critical implementations. |
| Supported Environments | Intended for development, testing, training, or small production workloads (up to 20 GB databases) | Supports both production and non-production environments, handling large, enterprise-scale workloads. |
| Supported Databases | Oracle databases only (19c, 21c, 23ai). | Supports Oracle databases (19c, 21c, 23ai), Oracle Exadata and Oracle Autonomous database. |
| Deployments | Manual deployment creation is not supported. A single deployment is automatically created and managed by the system when the application is first started. | Need to register at least one deployment. |
| Multiple Deployments |
Supports only one deployment that comes packaged with GoldenGate Studio Free 23.7. |
Supports multiple deployments. You can use a single deployment for both source and target databases. |
| Validate and Run analysis tools | Use Validate and Run analysis tools during connection creation. | Validation and run analysis are done during Pipeline creation. |
| Recipes | Includes two recipes: One-way and Active-active Recipe. | Includes three recipes: One-way, Active-active and ZeroETL Recipe. |
| Oracle Wallet | This feature is not supported. | Supports Oracle Wallet for secure storage and management
of database credentials, enhancing security and compliance.
Can upload Oracle Wallets when creating Autonomous Database (ADB) connections. |
| Test Connection | This feature is not supported. |
Use Test Connection to verify the connectivity between GoldenGate Studio and a database endpoint. You can save time diagnosing issues that could have been identified early with a connectivity check. This reduces the chance of runtime errors or failures. |
| User alias | This feature is not supported. | Supports User alias to facilitate aliasing of user credentials, allowing for more flexible and secure authentication scenarios. |
| Advanced Options in Initial Load | Limited set of features, simplified UI, some advanced options are unavailable or restricted. | Need to add user alias, specify the source wallet URI, and select transfer medium for Initial Load such as Database Link, Object Storage, and File Storage. |
| Support | Community support only (no Oracle Support). Questions regarding GoldenGate Studio Free can be posted in the GoldenGate Studio Free Community Forum. | Commercial version is eligible for Oracle Support and Free version is eligible for Community Support only. |
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: |
| 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: |
| 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 Oracle GoldenGate can't be used by GoldenGate Studio pipelines.
- Refrain from changing Extract, Replicat, and parameter files that are generated by GoldenGate Studio in Oracle GoldenGate. Once these files are changed, editing or running these pipelines from GoldenGate Studio lead to inconsistencies and failures.