# Connect with Oracle GoldenGate

You can load your data from various sources into SingleStore using Oracle GoldenGate and analyze the data in real time. Add a connection to your SingleStore cluster in GoldenGate, and use it in the Replicat that loads data in the target SingleStore database.

## Prerequisites

* Access to Oracle GoldenGate.
* [Download](https://www.oracle.com/in/middleware/technologies/goldengate-downloads.html) and [install](https://docs.oracle.com/en/middleware/goldengate/core/21.3/coredoc/install-oracle-goldengate.html) Oracle GoldenGate Microservices for MySQL v21.3.x.
* [Install](https://docs.oracle.com/en/middleware/goldengate/core/21.3/coredoc/install-installing-patches-ma.html#GUID-EAC33ABB-4278-415A-84D2-F4DFD2DEC360) the following patch: **Patch 35271106: Oracle GoldenGate 21.10.0.0.1 Microservices for MySQL-compatIble DBs**.
* Hands-on knowledge of the GoldenGate application/UI (refer to [GoldenGate documentation](https://docs.oracle.com/en/middleware/goldengate/core/21.3/index.html)).

## Connect to SingleStore from Oracle GoldenGate

To connect your SingleStore databases with Oracle GoldenGate, perform the following tasks:

1. Create a source **Extract**, select **Administration Service > Overview**. Under **Extracts**, select the **+** (plus) icon to add a new extract.
   The trails from this extract will be used by a SingleStore Replicat. Any database supported by Oracle GoldenGate as a source can support a SingleStore Replicat.

2. Select **Administration Service > Configuration > Database > Credentials > +** (plus icon) to create/configure a connection to the SingleStore database.

3. On the **Credentials** page, enter or select the following information:

   * **Credential Alias**: Enter an alias for this credential configuration.
   * **Database Server**: Enter the IP address or hostname of the SingleStore cluster.
   * **Port**: The default port is `3306`.
   * **User ID**: Enter the username of the SingleStore user. The user specified in the **Credential Alias** must have the required privileges to create a table in the SingleStore database.
   * **Password**: Enter the password for the SingleStore user.
   * **Verify Password**: Re-enter the **Password**.
   * Use defaults for other configuration items.

4. Select **Submit**.The **Credential Alias** is created.

5. From the **Credentials** section, use the **Credential Alias** created earlier to connect to the target database.

6. If you want to create a Parallel Replicat, skip to step 8. A checkpoint table is automatically created for a Parallel Replicat when it starts. Create a checkpoint table to be used by the Replicat. Select the **+** (plus) icon next to **Checkpoint**. 

7. Enter a name for the table in the **Checkpoint Table** box, and select **Submit**. The checkpoint table is added.

8. Select **Administration Service > Overview**. To create a new Replicat, select the **+** (plus) icon next to **Replicats**.

9. From the **Replicat Type** list, select a Replicat type, and then select **Next**.

10. On the **Basic Information** page, select or enter the following information:

    * **Process Name**: Enter a name for the process.
    * **Intent**: Select the Intent from the list.
    * **Credential Alias**: Select the Credential Alias created earlier from the list.
    * **Trail Name**: Name of the Extract created in step 1.
    * Use defaults for other configuration items.

11. Select **Next**.

12. On the **Parameter File** page, update the parameter setting to include the required source schema tables that will be mapped to the target schema tables in SingleStore.

13. Select **Create and Run**, and confirm that the new Replicat is running.

To confirm that the replication process is running, perform some DML operations on your database, and then perform the following tasks:

* Under **Extract**, select **Action > Details**. On the **Statistics** tab, you can see the number of operations performed.
* Select the **Statistics** tab for the Replicat (**Replicat > Action > Details**). The updates are visible in the **Table Statistics** section.

## Remarks

* You cannot replicate your data to views. Refer to [CREATE VIEW](https://docs.singlestore.com/managed-service/en/reference/sql-reference/data-definition-language-ddl/create-view.html) for more information.
* Updates to columns in the shard key are not supported.
* Updates to the primary key on tables without explicit shard keys are not supported, because SingleStore assigns the primary key column as the shard key in these cases.
* The `LIMITROWS` option for the Replicat is not supported for SingleStore tables without either a primary key or a unique key that is spread across multiple partitions.
* SingleStore does not support cross-database transactions. Therefore, Replicat can only map to a single database or schema. This includes mappings for checkpoints and heartbeat tables, which must all be created in the same database.

Refer to [Oracle GoldenGate Integration for SingleStore](https://www.singlestore.com/blog/oracle-goldengate-integration-for-singlestoredb/) for related information.

***

Modified at: September 26, 2025

Source: [/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-oracle-goldengate/](https://docs.singlestore.com/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-oracle-goldengate/)

(An index of the documentation is available at /llms.txt)