About Oracle GoldenGate AI Service

The AI Service in Oracle GoldenGate works with Replicat. The Replicat process interacts with an external AI service defined in the ServiceManager. From the ServiceManager, AI service provider details are configured depending on the type of AI service being embeded. Based on the AI Service provide, AI models are created from the Service Manager.

Note:

To ensure security, Oracle GoldenGate requires the use of CA certificates when connecting to any AI service provider. For AI services outside the corporate network, an HTTP proxy must be used.

Configure and Use an AI Service

Oracle GoldenGate provides the AI Service to allow embedding from various AI Service providers, including Google Gemini, OpenAI, Voyager AI, and OCI Generative AI. This service allows you to bring embedded data from the AI service.

Before you begin using the AI Service, make sure that you have the required values to configure the AI Service Provider and the associated AI Model details.

From the Service Manager, first you configure an AI Service Providers and then configure AI Service models based on your AI Service Provider from the Service Manager.

Here are the steps to add an AI Service Provider:

  1. Click the plus sign in the Providers section. This displays the Add Provider dialog box to add an AI provider.

  2. Specify the details depending on your AI provider. The following AI Providers are supported:

    Provider Type Options

    Gemini
    Specify the following values:

    • Provider ID, such as geminiai

    • Provider Name

    • Base URL

    • API Key

    OCI Generative AI
    Specify the following values:

    • Provider ID, example oracleai

    • Provider Name, example, oci

    • Base URL, example https://generativeai.regionapi_version

    • Tenancy OCID

    • Compartment OCID

    • User OCID

    • API Key, generate the API Key and upload it in OCI Console. Add this key in the

    • Key Fingerprint, fingerprint of the API Key.

    OpenAI
    Specify the following values:

    • Provider ID, such as geminiai

    • Provider Name

    • Base URL

    • API Key

    Voyage AI
    Specify the following values:

    • Provider ID, such as geminiai

    • Provider Name

    • Base URL

    • API Key

  3. Click Submit.

The AI Provider is listed in the Providers list. Now, you can create an AI Model associated with the provider.

To create an AI Model, add the following values:

  • Model ID: Depending on the AI service provider, you can specify a model ID. For example, for Gemini, you can select the model ID as gemini-3.0-pro.

  • Model Name: Specify a name for the model.

  • Remote Model Name: Specify the name of the model that is hosted on a provider's server and would be accessed using APIs for different tasks.

  • Provider ID: This is the same provider that you have created.

  • Capabilities (Embedding): Preselected option set to Embedding.

  • Enabled (toggle switch): Enable or disable the model.

  • Maximum Input Characters: Maxmimum characters allowed in the given Model.

AI Models

From the left-navigation pane, click the AI Models option to view the AI models that are available with the configured AI Providers.