OCI Streaming

About OCI Streaming Connections

An OCI Streaming connection stores the information that Oracle GoldenGate DAA uses to connect to an Oracle Cloud Infrastructure (OCI) Streaming service. OCI Streaming connections support both Oracle GoldenGate Extract and Oracle GoldenGate Replicat processes. You can use the connection to capture messages from OCI Streaming into Oracle GoldenGate trails or to publish transactional change data from Oracle GoldenGate trails to OCI Streaming.

The connection stores the bootstrap server information, security configuration, proxy configuration, and optional runtime settings independently of the Extract and Replicat configurations. This enables multiple Extract and Replicat processes to reuse the same validated connection. The connection properties are derived from the uploaded OCI Streaming connection schema.

Before You Begin

Before creating an OCI Streaming connection, ensure that you have the following:

Create and Validate an OCI Streaming Connection

Use the Add Connection page to create an OCI Streaming 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 OCI Streaming.

  5. In the Technology Settings section, provide the OCI Streaming connection information.

Technology Settings

Configure the following technology settings:

Configure the Security Settings section

Security Settings

Configure the following security settings:

Note: Configure the authentication and SSL properties only when Security Protocol is set to SASL_SSL.

Configure Common Settings, if additional runtime configuration is required.

Common Settings

Configure the following common settings:

(Optional) Configure Proxy Settings if the Oracle GoldenGate for Distributed Applications and Analytics deployment accesses OCI Streaming through an HTTP proxy.

Proxy Settings

Configure the following proxy settings:

Note: Configure the proxy and SSL settings only if the Oracle GoldenGate for Distributed Applications and Analytics deployment accesses OCI Streaming through a proxy that requires authentication or TLS. If the deployment has direct network connectivity to OCI Streaming, leave the Proxy Settings blank.

  1. Click Submit.

  2. 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 Extract or Replicat configuration or the OCI Streaming Handler configuration. After successful validation, the connection is available for selection during Extract or Replicat creation.

Use an OCI Streaming Connection in Replicat

After the OCI Streaming connection has been successfully validated:

  1. Create or edit an Extract or Replicat.

  2. Select OCI Streaming as the source or target technology, as applicable.

  3. Select the validated OCI Streaming connection.

  4. Complete the remaining process configuration.

  5. Create and start the Extract or Replicat.

Related Topics