What is Oracle GoldenGate Studio Free?
Oracle GoldenGate Studio Free is a starter version of Oracle's best in class replication software. With GoldenGate Studio Free, application databate administrators (DBAs) can learn basic concepts while creating simple data replication processes in a simplified user interface.
Want to learn more? Watch this short overview video.
Who is GoldenGate Studio Free for?
Discover if GoldenGate Studio Free is right for you.
Anyone can use GoldenGate Studio Free! If you're new to data replication and want to learn the basics without the overhead cost or spending a lot of time on set up and configuration, then GoldenGate Studio Free is for you!
What can I use GoldenGate Studio Free for?
You can use GoldenGate Studio Free:
- As a development or test environment
- As a production environment*, if your database is 20GB or smaller
- As a training tool in a learning environment
* Oracle GoldenGate Studio Free is not supported by Oracle Support. Questions regarding GoldenGate Studio Free can be posted in the GoldenGate Studio Free Community Forum.
What are GoldenGate Studio Free's limitations?
Learn about the limitations for using GoldenGate Studio Free.
GoldenGate Studio Free is limited to:
- Oracle Databases, no more than 20 gigabytes (GB) in size.
Note:
- For Container Databases (CDBs), this includes the total size of all Pluggable databases (PDBs).
- Oracle Database 23ai Free is supported, with the exception of Parallel Replicats.
- Support through community forums, instead of Oracle Support.
- Patches provided at Oracle's discretion in the form of new builds available through Oracle Container Registry.
- Interaction with other GoldenGate Studio Free instances. You can't use GoldenGate Studio Free with fully licensed Oracle GoldenGate products or other third-party integration tools.
- Integrated and Nonintegrated Replicats, ensuring that you don't use
Replicat-only features with licensed Extracts.
Note:
Refrain from changing the Replicat type in the Oracle GoldenGate Microservices console, or making changes to the underlying parameter file, as it affects GoldenGate Studio Free's ability to manage the pipeline. - No Active Data Guard (ADG) or XStream entitlements.
- No support for Downstream capture.
- No support for Graph data types.
- No support for changes to Automatic Conflict Detection and Resolution (ACDR) type once configured.
Concepts
Get familiar with the following concepts and other commonly used terms before you get started with GoldenGate Studio Free.
- Recipe: A recipe is a pipeline template for common data replication use cases. Follow a recipe to get started quickly and easily.
- Connection: A connection contains the network connectivity details to data stores and other GoldenGate instances.
- Pipeline: A pipeline is an instance of a recipe. It enables you to select your source connection, the type of replication action to apply, and the target connection. After a pipeline starts, you can observe the replication process in real time.
Other commonly used terms in this guide:
- Oracle GoldenGate Studio Free console: The main user interface for GoldenGate Studio Free, where you create and manage database connections and pipelines.
- Oracle GoldenGate Microservices console: The user interface for experienced GoldenGate users to configure advanced settings, monitor performance, and perform other common Oracle GoldenGate activities.
- Extract: A process that runs against the source database to extract, or capture, data.
- Replicat: A process that delivers data to the target database.
