10.4.1 Oracle AI Data Platform

• About Oracle AI Data Platform Connections
  
• Before You Begin
  
• Create and Validate an Oracle AI Data Platform Connection
  
• Use an Oracle AI Data Platform Connection in Replicat
  

10.4.1.1 About Oracle AI Data Platform Connections

An Oracle AI Data Platform connection stores the information that Oracle GoldenGate DAA uses to connect to Oracle AI Data Platform. After the connection is created and validated, you can reuse it when configuring Replicat processes that deliver transactional data to Oracle AI Data Platform.

The connection stores the service endpoint, Oracle Cloud Infrastructure (OCI) authentication information, and optional runtime settings independently of the Replicat configuration. This enables multiple Replicat processes to reuse the same validated connection.

10.4.1.2 Before You Begin

Before creating an Oracle AI Data Platform connection, ensure that you have the following:

• An Oracle GoldenGate DAA deployment.
• A validated OCI Object Storage connection. Oracle AI Data Platform uses the OCI Object Storage connection to access the required object storage resources.
• Network connectivity between the Oracle GoldenGate DAA deployment and Oracle AI Data Platform.
• The Oracle AI Data Platform tenancy OCID.
• The Oracle Cloud Infrastructure tenancy OCID.
• The Oracle Cloud Infrastructure user OCID.
• The Oracle Cloud Infrastructure region.
• An OCI API signing key pair.
• The public key fingerprint associated with the API signing key.
• The private key file and passphrase, if the private key is encrypted.
• Common runtime settings, if additional runtime configuration is required.
• Proxy information if the Oracle GoldenGate DAA deployment accesses Oracle AI Data Platform through an HTTP proxy.

10.4.1.3 Create and Validate an Oracle AI Data Platform Connection

Procedure

1. In the navigation menu, select DB Connections.
2. Click Add Connection.
3. In Connection Alias, enter a unique name for the connection.
4. From Technology Type, select Oracle AI Data Platform.
5. In the Technology Settings section, provide the Oracle AI Data Platform connection information:
   • Connection URL – Specifies the Oracle AI Data Platform service endpoint used to establish the connection. This field is required.
   • Tenancy OCID – Specifies the Oracle Cloud Infrastructure tenancy OCID associated with the Oracle AI Data Platform deployment. This field is required.
   • User OCID – Specifies the Oracle Cloud Infrastructure user OCID used to authenticate with Oracle AI Data Platform. This field is required.
   • Region – Specifies the Oracle Cloud Infrastructure region that hosts the Oracle AI Data Platform deployment. This field is required.

6. Configure the Security Settings section:

   • Private Key File – Upload the Base64-encoded OCI API private key (.pem) used to authenticate with Oracle Cloud Infrastructure. This field is required.
   • Private Key Passphrase – Specifies the passphrase protecting the private key when the private key is encrypted. Configure this field only if the uploaded private key is encrypted.
   • Public Key Fingerprint – Specifies the fingerprint of the OCI API public key associated with the uploaded private key. This field is required.

   Note:

   The private key file, private key passphrase, and public key fingerprint are treated as sensitive information.
7. Configure Common Settings if additional runtime configuration is required.

   Classpath: (Required) Specify the full path to client libraries are required by the replicat type. You can use Dependency Downloader to download client libraries.

8. (Optional) Configure Proxy Settings if the Oracle GoldenGate deployment accesses Oracle AI Data Platform through an HTTP proxy:
   • Proxy URL – Specifies the URL or host name of the proxy server used to access Oracle AI Data Platform.
   • Proxy Port – Specifies the port number of the proxy server.
   • Proxy Username – Specifies the user name for proxy authentication, if required.
   • Proxy Password – Specifies the password for proxy authentication. This field is treated as sensitive information.
   • Truststore – Specifies the Java truststore file that contains the certificate authority (CA) certificates used to validate the proxy server certificate, when required.
   • Truststore Password – Specifies the password associated with the truststore.
   • Keystore – Specifies the Java keystore file containing the client certificate and private key used for client authentication, when required.
   • Keystore Password – Specifies the password associated with the keystore.
   • SSL Key Password – Specifies the password protecting the private key stored in the keystore when it differs from the keystore password.

   Note:

   If the Oracle GoldenGate DAA deployment has direct network connectivity to Oracle AI Data Platform, leave the Proxy Settings blank.
9. Click Submit.
10. On the DB Connections page, click DB Login to validate the connection.

Note:

A successful DB Login validates only the saved connection information. It does not validate the Replicat configuration or Oracle AI Data Platform handler configuration. After successful validation, the connection is available for selection during Replicat creation.

10.4.1.4 Use an Oracle AI Data Platform Connection in Replicat

After the Oracle AI Data Platform connection has been successfully validated:

1. Create or edit a Replicat.
2. Select Oracle AI Data Platform as the target technology.
3. Select the validated Oracle AI Data Platform connection.
4. Complete the remaining Replicat configuration.
5. Create and start the Replicat.