Does this tool connect to my OCI account?

No. This tool runs entirely in your browser and generates configuration JSON that you can copy and paste into your infrastructure-as-code templates, CLI commands, or cloud console. It never connects to any cloud account or sends data externally.

Are the generated configurations production-ready?

The tool produces syntactically valid configurations based on current OCI service specifications. Always review generated configs against your organization security policies and test in a non-production environment before deploying.

OCI GoldenGate Deployment Builder

StorageOCI

Build GoldenGate deployment and connection configurations for real-time data replication.

Last verified: May 2026

OCI GoldenGate Configuration

Build GoldenGate deployment and connection configurations for real-time data replication and streaming.

Required Fields

compartmentIddisplayNamedeployment.deploymentTypedeployment.cpuCoreCountconnections

{
  "compartmentId": "ocid1.compartment.oc1..aaaaaaaexample",
  "displayName": "prod-goldengate-deployment",
  "description": "GoldenGate deployment for real-time data replication between Oracle databases",
  "deployment": {
    "deploymentType": "OGG",
    "licenseModel": "LICENSE_INCLUDED",
    "cpuCoreCount": 2,
    "isAutoScalingEnabled": true,
    "subnetId": "ocid1.subnet.oc1.iad.aaaaaaaexample",
    "nsgIds": ["ocid1.networksecuritygroup.oc1.iad.aaaaaaaexample"],
    "isPublic": false,
    "oggData": {
      "deploymentName": "prod-gg",
      "adminUsername": "oggadmin",
      "credentialStore": "GOLDENGATE",
      "certificate": "ocid1.certificate.oc1.iad.aaaaaaaexample"
    },
    "maintenanceWindow": {
      "day": "SUNDAY",
      "startHour": 2
    }
  },
  "connections": [
    {
      "displayName": "source-oracle-db",
      "connectionType": "ORACLE",
      "technologyType": "ORACLE_DATABASE",
      "connectionString": "source-db.subnet.vcn.oraclevcn.com:1521/SRCPDB.subnet.vcn.oraclevcn.com",
      "username": "ggadmin",
      "vaultSecretId": "ocid1.vaultsecret.oc1.iad.aaaaaaaexample-src",
      "sessionMode": "DIRECT",
      "databaseId": "ocid1.database.oc1.iad.aaaaaaaexample-src"
    },
    {
      "displayName": "target-adw",
      "connectionType": "ORACLE",
      "technologyType": "ORACLE_AUTONOMOUS_DATABASE",
      "databaseId": "ocid1.autonomousdatabase.oc1.iad.aaaaaaaexample",
      "username": "ggadmin",
      "vaultSecretId": "ocid1.vaultsecret.oc1.iad.aaaaaaaexample-tgt"
    }
  ],
  "replicationConfig": {
    "extractName": "EXT_SRC",
    "replicatName": "REP_TGT",
    "trailName": "aa",
    "tableMapping": [
      {
        "sourceSchema": "HR",
        "sourceTable": "*",
        "targetSchema": "HR_REPLICA",
        "targetTable": "*"
      },
      {
        "sourceSchema": "SALES",
        "sourceTable": "ORDERS",
        "targetSchema": "ANALYTICS",
        "targetTable": "FACT_ORDERS"
      }
    ]
  },
  "freeformTags": {
    "service": "data-replication",
    "team": "dba"
  }
}

Generated Output

Output will appear here...

See It in Action

Your team needs to migrate a 5 TB Oracle Database from on-prem to OCI Autonomous DB with zero downtime. The builder generates a GoldenGate deployment: source connection to on-prem Oracle, target connection to OCI Autonomous, initial-load extract followed by continuous CDC replication. The migration runs for 2 weeks while applications keep running on-prem. At cutover, applications switch to ADB, GoldenGate has all transactions caught up, and downtime is <5 minutes. Without GoldenGate, this migration would have required hours of downtime.

What This Tool Does

Build GoldenGate deployment and connection configurations for real-time data replication. This tool helps OCI engineers generate valid configurations quickly without consulting documentation, reducing errors and accelerating infrastructure deployment. All processing runs in your browser with no data sent to external servers.

Technical Details

The builder constructs OCI GoldenGate deployment configurations: deployment resource (compartment, OCPU count, deployment type: OGGS18C or OGGS19C, license model: BYOL or LICENSE_INCLUDED, public/private endpoint), connections (source and target database connections with credentials in OCI Vault), and trail file storage configuration. Output is generated as oci goldengate commands and Terraform oci_golden_gate_deployment + oci_golden_gate_connection resources.

Common Use Cases

1Generating oci goldengate deployment configurations for new infrastructure deployments.
2Validating existing configurations against best practices before applying changes.
3Learning OCI service configuration patterns through interactive examples.
4Accelerating infrastructure-as-code development by producing correct JSON/YAML starting points.

Common Questions

Does this tool connect to my OCI account?: No. This tool runs entirely in your browser and generates configuration JSON that you can copy and paste into your infrastructure-as-code templates, CLI commands, or cloud console. It never connects to any cloud account or sends data externally.
Are the generated configurations production-ready?: The tool produces syntactically valid configurations based on current OCI service specifications. Always review generated configs against your organization security policies and test in a non-production environment before deploying.

Expert Tips

TIP

OCI GoldenGate is the gold standard for real-time database replication. Use it for: heterogeneous replication (Oracle → Postgres, MySQL → BigQuery), zero-downtime migrations, multi-cloud data sync. The pricing is per-OCPU-hour on the deployment, dramatically simpler than the on-prem GoldenGate licensing model.

TIP

GoldenGate captures CDC (Change Data Capture) from source databases — every INSERT/UPDATE/DELETE is replicated as it happens. This is dramatically better than scheduled batch replication for keeping downstream systems in sync.

TIP

For multi-region disaster recovery of Oracle Database, GoldenGate provides RPO=zero (no data loss) with RTO measured in seconds. The cost is significant but for mission-critical Oracle workloads, the recovery objectives justify it.

Related Learning Guides

Autonomous Database on OCI20 min read
OCI Object Storage & Tiers16 min read

Was this tool helpful?

Disclaimer: This tool runs entirely in your browser. No data is sent to our servers. Always verify outputs before using them in production. AWS, Azure, and GCP are trademarks of their respective owners.