Manage Goldengate connection assignments

This page describes how to manage Goldengate connection assignments in Google Cloud.

Before you begin

  • Make sure that you have the required Identity and Access Management (IAM) roles and permissions to perform the tasks described in this page:

    • roles/oracledatabase.goldenGateConnectionAssignmentAdmin
    • roles/oracledatabase.goldenGateConnectionAssignmentViewer

    For more information about how to assign roles, see Apply IAM roles.

View connection assignment details

To view connection assignment information about your connection assignments, do the following:

gcloud

  • List connection assignments

    Use the gcloud oracle-database goldengate-connection-assignments list command to list connection assignments.

    gcloud oracle-database goldengate-connection-assignments list \
    --project=PROJECT_ID \
    --location=REGION

    Replace the following:

    • PROJECT_ID: the ID of your Google Cloud project. If you're using a Shared VPC, then this is the ID of your host project.
    • REGION: the region where you want to view the connection assignments.

  • View connection assignment details

    Use the gcloud oracle-database goldengate-connection-assignments describe command to view details of a connection assignment.

    gcloud oracle-database goldengate-connection-assignments describe ASSIGNMENT_ID \
    --project=PROJECT_ID \
    --location=REGION

    Replace the ASSIGNMENT_ID with the ID of your connection assignment.

API

  • List connection assignments

    To list connection assignments, run the following curl command:

    curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
-H "Content-Type: application/json" \
"https://oracledatabase.googleapis.com/v1/projects/PROJECT_ID/locations/REGION/goldengateConnectionAssignments"

    Replace the following:

    • PROJECT_ID: the ID of your Google Cloud project. If you're using a Shared VPC, then this project ID is the ID of your host project.
    • REGION: the region where you want to view the connection assignments.

  • View connection assignment details

    To view details of a connection assignment, run the following curl command:

    curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
-H "Content-Type: application/json" \
"https://oracledatabase.googleapis.com/v1/projects/PROJECT_ID/locations/REGION/goldengateConnectionAssignments/ASSIGNMENT_ID"

    Replace the ASSIGNMENT_ID with the ID of your connection assignment.

Delete a connection assignment

To delete a connection assignment, do the following:

gcloud

Use the gcloud oracle-database goldengate-connection-assignments delete command to delete a connection assignment.

gcloud oracle-database goldengate-connection-assignments delete ASSIGNMENT_ID \
    --project=PROJECT_ID \
    --location=REGION

Replace the following:

  • ASSIGNMENT_ID: the ID of the connection assignment.
  • PROJECT_ID: the ID of your Google Cloud project. If you're using a Shared VPC, then this is the ID of your host project.
  • REGION: the region where your connection assignment is located.

API

To delete a connection assignment, run the following curl command:

curl -X DELETE \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
-H "Content-Type: application/json" \
"https://oracledatabase.googleapis.com/v1/projects/PROJECT_ID/locations/REGION/goldengateConnectionAssignments/ASSIGNMENT_ID"

Replace the following:

  • PROJECT_ID: the ID of your Google Cloud project which contains the connection assignment to be deleted. If you're using a Shared VPC, then this is the ID of your host project.
  • REGION: the region where your connection assignment is located.
  • CONNECTION_ID: the ID of your connection assignment.