goldengate_connections

Creates, updates, deletes, gets or lists a goldengate_connections resource.

Overview

Name	goldengate_connections
Type	Resource
Id	google.oracledatabase.goldengate_connections

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
name	string	Identifier. The name of the GoldengateConnection resource in the following format: projects/{project}/locations/{region}/goldengateConnections/{goldengate_connection}
createTime	string (google-datetime)	Output only. The date and time that the GoldengateConnection was created.
entitlementId	string	Output only. The ID of the subscription entitlement associated with the GoldengateConnection.
gcpOracleZone	string	Optional. The GCP Oracle zone where Oracle GoldengateConnection is hosted. Example: us-east4-b-r2. If not specified, the system will pick a zone based on availability.
labels	object	Optional. The labels or tags associated with the GoldengateConnection.
ociUrl	string	Output only. HTTPS link to OCI resources exposed to Customer via UI Interface.
odbNetwork	string	Optional. The name of the OdbNetwork associated with the GoldengateConnection. The format is projects/{project}/locations/{location}/odbNetworks/{odb_network}. It is optional but if specified, this should match the parent ODBNetwork of the OdbSubnet.
odbSubnet	string	Optional. The name of the OdbSubnet associated with the GoldengateConnection for IP allocation. Format: projects/{project}/locations/{location}/odbNetworks/{odb_network}/odbSubnets/{odb_subnet}
properties	object	Required. The properties of the GoldengateConnection. (id: GoldengateConnectionProperties)

list

Name	Datatype	Description

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	projectsId, locationsId, goldengateConnectionsId		Gets details of a single GoldengateConnection.
list	select	projectsId, locationsId	filter, pageToken, pageSize, orderBy	Lists all the GoldengateConnections for the given project and location.
create	insert	projectsId, locationsId	goldengateConnectionId, requestId	Creates a new GoldengateConnection in a given project and location.
delete	delete	projectsId, locationsId, goldengateConnectionsId	requestId	Deletes a single GoldengateConnection.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
goldengateConnectionsId	string
locationsId	string
projectsId	string
filter	string
goldengateConnectionId	string
orderBy	string
pageSize	integer (int32)
pageToken	string
requestId	string

SELECT examples

get

Gets details of a single GoldengateConnection.

SELECT
name,
createTime,
entitlementId,
gcpOracleZone,
labels,
ociUrl,
odbNetwork,
odbSubnet,
properties
FROM google.oracledatabase.goldengate_connections
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND goldengateConnectionsId = '{{ goldengateConnectionsId }}' -- required
;

list

Lists all the GoldengateConnections for the given project and location.

SELECT
*
FROM google.oracledatabase.goldengate_connections
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND filter = '{{ filter }}'
AND pageToken = '{{ pageToken }}'
AND pageSize = '{{ pageSize }}'
AND orderBy = '{{ orderBy }}'
;

INSERT examples

create

Creates a new GoldengateConnection in a given project and location.

INSERT INTO google.oracledatabase.goldengate_connections (
data__properties,
data__odbSubnet,
data__odbNetwork,
data__name,
data__gcpOracleZone,
data__labels,
projectsId,
locationsId,
goldengateConnectionId,
requestId
)
SELECT 
'{{ properties }}',
'{{ odbSubnet }}',
'{{ odbNetwork }}',
'{{ name }}',
'{{ gcpOracleZone }}',
'{{ labels }}',
'{{ projectsId }}',
'{{ locationsId }}',
'{{ goldengateConnectionId }}',
'{{ requestId }}'
RETURNING
name,
done,
error,
metadata,
response
;

Manifest

# Description fields are for documentation purposes
- name: goldengate_connections
props:
  - name: projectsId
    value: "{{ projectsId }}"
    description: Required parameter for the goldengate_connections resource.
  - name: locationsId
    value: "{{ locationsId }}"
    description: Required parameter for the goldengate_connections resource.
  - name: properties
    description: |
      Required. The properties of the GoldengateConnection.
    value:
      googleBigQueryConnectionProperties:
        technologyType: "{{ technologyType }}"
        serviceAccountKeyFile: "{{ serviceAccountKeyFile }}"
      oracleNosqlConnectionProperties:
        technologyType: "{{ technologyType }}"
        privateKeyPassphraseSecret: "{{ privateKeyPassphraseSecret }}"
        tenancyId: "{{ tenancyId }}"
        publicKeyFingerprint: "{{ publicKeyFingerprint }}"
        privateKeyFile: "{{ privateKeyFile }}"
        useResourcePrincipal: {{ useResourcePrincipal }}
        region: "{{ region }}"
        userId: "{{ userId }}"
      googleCloudStorageConnectionProperties:
        serviceAccountKeyFile: "{{ serviceAccountKeyFile }}"
        technologyType: "{{ technologyType }}"
      mysqlConnectionProperties:
        technologyType: "{{ technologyType }}"
        sslCertFile: "{{ sslCertFile }}"
        sslCaFile: "{{ sslCaFile }}"
        sslCrlFile: "{{ sslCrlFile }}"
        username: "{{ username }}"
        securityProtocol: "{{ securityProtocol }}"
        database: "{{ database }}"
        host: "{{ host }}"
        dbSystemId: "{{ dbSystemId }}"
        passwordSecretVersion: "{{ passwordSecretVersion }}"
        sslKeyFile: "{{ sslKeyFile }}"
        port: {{ port }}
        password: "{{ password }}"
        sslMode: "{{ sslMode }}"
        additionalAttributes:
          - key: "{{ key }}"
            value: "{{ value }}"
      kafkaSchemaRegistryConnectionProperties:
        keyStorePassword: "{{ keyStorePassword }}"
        technologyType: "{{ technologyType }}"
        username: "{{ username }}"
        authenticationType: "{{ authenticationType }}"
        url: "{{ url }}"
        keyStoreFile: "{{ keyStoreFile }}"
        trustStoreFile: "{{ trustStoreFile }}"
        passwordSecretVersion: "{{ passwordSecretVersion }}"
        trustStorePassword: "{{ trustStorePassword }}"
        sslKeyPassword: "{{ sslKeyPassword }}"
        password: "{{ password }}"
        keyStorePasswordSecretVersion: "{{ keyStorePasswordSecretVersion }}"
        trustStorePasswordSecretVersion: "{{ trustStorePasswordSecretVersion }}"
        sslKeyPasswordSecretVersion: "{{ sslKeyPasswordSecretVersion }}"
      microsoftFabricConnectionProperties:
        tenantId: "{{ tenantId }}"
        endpoint: "{{ endpoint }}"
        clientId: "{{ clientId }}"
        technologyType: "{{ technologyType }}"
        clientSecret: "{{ clientSecret }}"
      lifecycleDetails: "{{ lifecycleDetails }}"
      javaMessageServiceConnectionProperties:
        trustStoreFile: "{{ trustStoreFile }}"
        keyStoreFile: "{{ keyStoreFile }}"
        jndiConnectionFactory: "{{ jndiConnectionFactory }}"
        authenticationType: "{{ authenticationType }}"
        jndiInitialContextFactory: "{{ jndiInitialContextFactory }}"
        username: "{{ username }}"
        securityProtocol: "{{ securityProtocol }}"
        jndiSecurityCredentialsSecret: "{{ jndiSecurityCredentialsSecret }}"
        keyStorePassword: "{{ keyStorePassword }}"
        technologyType: "{{ technologyType }}"
        connectionUrl: "{{ connectionUrl }}"
        trustStorePasswordSecretVersion: "{{ trustStorePasswordSecretVersion }}"
        useJndi: {{ useJndi }}
        jndiProviderUrl: "{{ jndiProviderUrl }}"
        sslKeyPasswordSecretVersion: "{{ sslKeyPasswordSecretVersion }}"
        connectionFactory: "{{ connectionFactory }}"
        keyStorePasswordSecretVersion: "{{ keyStorePasswordSecretVersion }}"
        jndiSecurityPrincipal: "{{ jndiSecurityPrincipal }}"
        password: "{{ password }}"
        sslKeyPassword: "{{ sslKeyPassword }}"
        passwordSecretVersion: "{{ passwordSecretVersion }}"
        trustStorePassword: "{{ trustStorePassword }}"
      postgresqlConnectionProperties:
        passwordSecretVersion: "{{ passwordSecretVersion }}"
        sslKeyFile: "{{ sslKeyFile }}"
        port: {{ port }}
        password: "{{ password }}"
        additionalAttributes:
          - key: "{{ key }}"
            value: "{{ value }}"
        sslMode: "{{ sslMode }}"
        sslCrlFile: "{{ sslCrlFile }}"
        technologyType: "{{ technologyType }}"
        sslCertFile: "{{ sslCertFile }}"
        sslCaFile: "{{ sslCaFile }}"
        username: "{{ username }}"
        securityProtocol: "{{ securityProtocol }}"
        host: "{{ host }}"
        dbSystemId: "{{ dbSystemId }}"
        database: "{{ database }}"
      microsoftSqlserverConnectionProperties:
        additionalAttributes:
          - key: "{{ key }}"
            value: "{{ value }}"
        password: "{{ password }}"
        host: "{{ host }}"
        database: "{{ database }}"
        port: {{ port }}
        serverCertificateValidationRequired: {{ serverCertificateValidationRequired }}
        username: "{{ username }}"
        securityProtocol: "{{ securityProtocol }}"
        sslCaFile: "{{ sslCaFile }}"
        passwordSecretVersion: "{{ passwordSecretVersion }}"
        technologyType: "{{ technologyType }}"
      goldengateConnectionProperties:
        username: "{{ username }}"
        port: {{ port }}
        passwordSecretVersion: "{{ passwordSecretVersion }}"
        technologyType: "{{ technologyType }}"
        goldengateDeploymentId: "{{ goldengateDeploymentId }}"
        password: "{{ password }}"
        host: "{{ host }}"
      routingMethod: "{{ routingMethod }}"
      azureDataLakeStorageConnectionProperties:
        azureTenantId: "{{ azureTenantId }}"
        clientId: "{{ clientId }}"
        account: "{{ account }}"
        endpoint: "{{ endpoint }}"
        authenticationType: "{{ authenticationType }}"
        accountKeySecret: "{{ accountKeySecret }}"
        azureAuthorityHost: "{{ azureAuthorityHost }}"
        sasTokenSecret: "{{ sasTokenSecret }}"
        technologyType: "{{ technologyType }}"
        clientSecret: "{{ clientSecret }}"
      elasticsearchConnectionProperties:
        passwordSecretVersion: "{{ passwordSecretVersion }}"
        technologyType: "{{ technologyType }}"
        password: "{{ password }}"
        servers: "{{ servers }}"
        authenticationType: "{{ authenticationType }}"
        securityProtocol: "{{ securityProtocol }}"
        username: "{{ username }}"
        fingerprint: "{{ fingerprint }}"
      connectionType: "{{ connectionType }}"
      googlePubsubConnectionProperties:
        technologyType: "{{ technologyType }}"
        serviceAccountKeyFile: "{{ serviceAccountKeyFile }}"
      genericConnectionProperties:
        technologyType: "{{ technologyType }}"
        host: "{{ host }}"
      hdfsConnectionProperties:
        technologyType: "{{ technologyType }}"
        coreSiteXml: "{{ coreSiteXml }}"
      kafkaConnectionProperties:
        streamPoolId: "{{ streamPoolId }}"
        passwordSecretVersion: "{{ passwordSecretVersion }}"
        trustStorePassword: "{{ trustStorePassword }}"
        sslKeyPassword: "{{ sslKeyPassword }}"
        bootstrapServers:
          - privateIpAddress: "{{ privateIpAddress }}"
            host: "{{ host }}"
            port: {{ port }}
        password: "{{ password }}"
        keyStorePasswordSecretVersion: "{{ keyStorePasswordSecretVersion }}"
        trustStorePasswordSecretVersion: "{{ trustStorePasswordSecretVersion }}"
        sslKeyPasswordSecretVersion: "{{ sslKeyPasswordSecretVersion }}"
        producerPropertiesFile: "{{ producerPropertiesFile }}"
        keyStorePassword: "{{ keyStorePassword }}"
        technologyType: "{{ technologyType }}"
        clusterId: "{{ clusterId }}"
        useResourcePrincipal: {{ useResourcePrincipal }}
        securityProtocol: "{{ securityProtocol }}"
        username: "{{ username }}"
        keyStoreFile: "{{ keyStoreFile }}"
        consumerPropertiesFile: "{{ consumerPropertiesFile }}"
        trustStoreFile: "{{ trustStoreFile }}"
      description: "{{ description }}"
      oracleConnectionProperties:
        authenticationMode: "{{ authenticationMode }}"
        password: "{{ password }}"
        passwordSecretVersion: "{{ passwordSecretVersion }}"
        technologyType: "{{ technologyType }}"
        sessionMode: "{{ sessionMode }}"
        gcpOracleDatabaseId: "{{ gcpOracleDatabaseId }}"
        connectionString: "{{ connectionString }}"
        username: "{{ username }}"
        walletFile: "{{ walletFile }}"
      mongodbConnectionProperties:
        tlsCertificateKeyFilePasswordSecretVersion: "{{ tlsCertificateKeyFilePasswordSecretVersion }}"
        password: "{{ password }}"
        tlsCertificateKeyFile: "{{ tlsCertificateKeyFile }}"
        username: "{{ username }}"
        securityProtocol: "{{ securityProtocol }}"
        tlsCaFile: "{{ tlsCaFile }}"
        connectionString: "{{ connectionString }}"
        databaseId: "{{ databaseId }}"
        passwordSecretVersion: "{{ passwordSecretVersion }}"
        technologyType: "{{ technologyType }}"
        tlsCertificateKeyFilePassword: "{{ tlsCertificateKeyFilePassword }}"
      db2ConnectionProperties:
        passwordSecretVersion: "{{ passwordSecretVersion }}"
        technologyType: "{{ technologyType }}"
        port: {{ port }}
        sslServerCertificateFile: "{{ sslServerCertificateFile }}"
        username: "{{ username }}"
        securityProtocol: "{{ securityProtocol }}"
        sslClientKeystashFile: "{{ sslClientKeystashFile }}"
        password: "{{ password }}"
        host: "{{ host }}"
        database: "{{ database }}"
        additionalAttributes:
          - key: "{{ key }}"
            value: "{{ value }}"
        sslClientKeystoredbFile: "{{ sslClientKeystoredbFile }}"
      redisConnectionProperties:
        authenticationType: "{{ authenticationType }}"
        trustStoreFile: "{{ trustStoreFile }}"
        redisClusterId: "{{ redisClusterId }}"
        keyStoreFile: "{{ keyStoreFile }}"
        technologyType: "{{ technologyType }}"
        keyStorePassword: "{{ keyStorePassword }}"
        securityProtocol: "{{ securityProtocol }}"
        username: "{{ username }}"
        keyStorePasswordSecretVersion: "{{ keyStorePasswordSecretVersion }}"
        password: "{{ password }}"
        trustStorePasswordSecretVersion: "{{ trustStorePasswordSecretVersion }}"
        passwordSecretVersion: "{{ passwordSecretVersion }}"
        trustStorePassword: "{{ trustStorePassword }}"
        servers: "{{ servers }}"
      amazonKinesisConnectionProperties:
        secretAccessKeySecret: "{{ secretAccessKeySecret }}"
        awsRegion: "{{ awsRegion }}"
        accessKeyId: "{{ accessKeyId }}"
        endpoint: "{{ endpoint }}"
        technologyType: "{{ technologyType }}"
      ociObjectStorageConnectionProperties:
        technologyType: "{{ technologyType }}"
        privateKeyPassphraseSecret: "{{ privateKeyPassphraseSecret }}"
        tenancyId: "{{ tenancyId }}"
        publicKeyFingerprint: "{{ publicKeyFingerprint }}"
        privateKeyFile: "{{ privateKeyFile }}"
        useResourcePrincipal: {{ useResourcePrincipal }}
        region: "{{ region }}"
        userId: "{{ userId }}"
      amazonS3ConnectionProperties:
        region: "{{ region }}"
        secretAccessKeySecret: "{{ secretAccessKeySecret }}"
        accessKeyId: "{{ accessKeyId }}"
        endpoint: "{{ endpoint }}"
        technologyType: "{{ technologyType }}"
      updateTime: "{{ updateTime }}"
      amazonRedshiftConnectionProperties:
        connectionUrl: "{{ connectionUrl }}"
        username: "{{ username }}"
        password: "{{ password }}"
        passwordSecretVersion: "{{ passwordSecretVersion }}"
        technologyType: "{{ technologyType }}"
      azureSynapseAnalyticsConnectionProperties:
        connectionString: "{{ connectionString }}"
        username: "{{ username }}"
        password: "{{ password }}"
        passwordSecretVersion: "{{ passwordSecretVersion }}"
        technologyType: "{{ technologyType }}"
      databricksConnectionProperties:
        clientId: "{{ clientId }}"
        connectionUrl: "{{ connectionUrl }}"
        storageCredential: "{{ storageCredential }}"
        authenticationType: "{{ authenticationType }}"
        password: "{{ password }}"
        passwordSecretVersion: "{{ passwordSecretVersion }}"
        technologyType: "{{ technologyType }}"
        clientSecret: "{{ clientSecret }}"
      lifecycleState: "{{ lifecycleState }}"
      ingressIpAddresses:
        - "{{ ingressIpAddresses }}"
      ocid: "{{ ocid }}"
      snowflakeConnectionProperties:
        connectionUrl: "{{ connectionUrl }}"
        username: "{{ username }}"
        privateKeyFile: "{{ privateKeyFile }}"
        password: "{{ password }}"
        authenticationType: "{{ authenticationType }}"
        passwordSecretVersion: "{{ passwordSecretVersion }}"
        technologyType: "{{ technologyType }}"
        privateKeyPassphraseSecret: "{{ privateKeyPassphraseSecret }}"
      icebergConnectionProperties:
        storage:
          googleCloudStorageIcebergStorage:
            bucket: "{{ bucket }}"
            projectId: "{{ projectId }}"
            serviceAccountKeyFile: "{{ serviceAccountKeyFile }}"
          storageType: "{{ storageType }}"
          amazonS3IcebergStorage:
            schemeType: "{{ schemeType }}"
            secretAccessKeySecret: "{{ secretAccessKeySecret }}"
            region: "{{ region }}"
            endpoint: "{{ endpoint }}"
            accessKeyId: "{{ accessKeyId }}"
            bucket: "{{ bucket }}"
          azureDataLakeStorageIcebergStorage:
            container: "{{ container }}"
            accountKeySecret: "{{ accountKeySecret }}"
            azureAccount: "{{ azureAccount }}"
            endpoint: "{{ endpoint }}"
        technologyType: "{{ technologyType }}"
        catalog:
          polarisIcebergCatalog:
            clientSecret: "{{ clientSecret }}"
            uri: "{{ uri }}"
            principalRole: "{{ principalRole }}"
            clientId: "{{ clientId }}"
            polarisCatalog: "{{ polarisCatalog }}"
          catalogType: "{{ catalogType }}"
          glueIcebergCatalog:
            glueId: "{{ glueId }}"
          nessieIcebergCatalog:
            uri: "{{ uri }}"
            branch: "{{ branch }}"
          restIcebergCatalog:
            uri: "{{ uri }}"
            properties: "{{ properties }}"
      displayName: "{{ displayName }}"
      oracleAiDataPlatformConnectionProperties:
        tenancyId: "{{ tenancyId }}"
        technologyType: "{{ technologyType }}"
        privateKeyPassphraseSecret: "{{ privateKeyPassphraseSecret }}"
        publicKeyFingerprint: "{{ publicKeyFingerprint }}"
        userId: "{{ userId }}"
        useResourcePrincipal: {{ useResourcePrincipal }}
        connectionUrl: "{{ connectionUrl }}"
        privateKeyFile: "{{ privateKeyFile }}"
        region: "{{ region }}"
  - name: odbSubnet
    value: "{{ odbSubnet }}"
    description: |
      Optional. The name of the OdbSubnet associated with the GoldengateConnection for IP allocation. Format: projects/{project}/locations/{location}/odbNetworks/{odb_network}/odbSubnets/{odb_subnet}
  - name: odbNetwork
    value: "{{ odbNetwork }}"
    description: |
      Optional. The name of the OdbNetwork associated with the GoldengateConnection. The format is projects/{project}/locations/{location}/odbNetworks/{odb_network}. It is optional but if specified, this should match the parent ODBNetwork of the OdbSubnet.
  - name: name
    value: "{{ name }}"
    description: |
      Identifier. The name of the GoldengateConnection resource in the following format: projects/{project}/locations/{region}/goldengateConnections/{goldengate_connection}
  - name: gcpOracleZone
    value: "{{ gcpOracleZone }}"
    description: |
      Optional. The GCP Oracle zone where Oracle GoldengateConnection is hosted. Example: us-east4-b-r2. If not specified, the system will pick a zone based on availability.
  - name: labels
    value: "{{ labels }}"
    description: |
      Optional. The labels or tags associated with the GoldengateConnection.
  - name: goldengateConnectionId
    value: "{{ goldengateConnectionId }}"
  - name: requestId
    value: "{{ requestId }}"

DELETE examples

delete

Deletes a single GoldengateConnection.

DELETE FROM google.oracledatabase.goldengate_connections
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND goldengateConnectionsId = '{{ goldengateConnectionsId }}' --required
AND requestId = '{{ requestId }}'
;