10.2.4 Google Cloud Storage

• About Google Cloud Storage
  
• Before You Begin
  
• Create and Validate a Google Cloud Storage Connection
  
• Use a Google Cloud Storage Connection in Replicat
  

10.2.4.1 About Google Cloud Storage

A Google Cloud Storage connection stores the information that Oracle GoldenGate for DAA uses to connect to Google Cloud Storage. After the connection is created and validated, you can reuse it when configuring Replicat processes that write transactional data to Google Cloud Storage.

The connection stores the authentication information and optional runtime settings independently of the Replicat configuration. This enables multiple Replicat processes to reuse the same validated connection.

10.2.4.2 Before You Begin

Before creating a Google Cloud Storage connection, ensure that you have the following:

• An Oracle GoldenGate for DAA deployment.
• Network connectivity between the Oracle GoldenGate DAA deployment and Google Cloud Storage.
• A Google Cloud service account key file with permission to access the target Cloud Storage buckets.
• The required Google Cloud Storage client libraries and any additional runtime dependencies, if they are not already available in the deployment.
  • To download the required dependencies, use the GG DAA Dependency Downloader:

    {GGforDAA install}/DependencyDownloader/gcs.sh 2.x

  • Download the supported Google Cloud Storage client libraries from:

    https://search.maven.org/artifact/com.google.cloud/google-cloud-storage

  • After downloading the dependencies, configure the gg.classpath property in the Java Adapter properties file to include the downloaded libraries before starting the Replicat process.
• Configure common runtime settings, such as the runtime classpath, if additional client libraries are required.
• Proxy information if the Oracle GoldenGate deployment accesses Google Cloud Storage through an HTTP proxy.

For more information on Google Cloud Storage handler configuration, supported features, dependency requirements, and troubleshooting, see Google Cloud Storage.

10.2.4.3 Create and Validate a Google Cloud Storage Connection

Use the Add Connection page to create a Google Cloud Storage 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 Google Cloud Storage.
5. In the Technology Settings section, provide the Google Cloud Storage connection information.

   Service Account Key File: Upload the Google Cloud service account key file used to authenticate with Google Cloud Storage. The uploaded file contains the credentials required to access Google Cloud Storage. This property is deprecated and will be replaced by serviceAccountKeyFileSecretId.

   Note:

   The uploaded service account key file is treated as authentication material and should be protected appropriately.
6. 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.

7. (Optional) Configure Proxy Settings if the Oracle GoldenGate deployment accesses Google Cloud Storage through an HTTP proxy.
   Proxy Settings

   • Proxy URL – Specifies the URL or host name of the proxy server used to access Google Cloud Storage.
   • 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 for DAA deployment has direct network connectivity to Google Cloud Storage leave the Proxy Settings blank.
8. Click Submit.
9. 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 Google Cloud Storage handler configuration. After successful validation, the connection is available for selection during Replicat creation.

10.2.4.4 Use a Google Cloud Storage Connection in Replicat

After the Google Cloud Storage connection has been successfully validated:

1. Create or edit a Replicat.
2. Select Google Cloud Storage as the target technology.
3. Select the validated Google Cloud Storage connection.
4. Complete the remaining Replicat configuration.
5. Create the Replicat.
6. Configure any remaining Google Cloud Storage handler properties before starting the Replicat.