goldengate_deployment_types

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

Overview

Name	goldengate_deployment_types
Type	Resource
Id	google.oracledatabase.goldengate_deployment_types

Fields

The following fields are returned by SELECT queries:

list

Name	Datatype	Description
name	string	Identifier. The name of the Goldengate Deployment Type resource with the format: projects/{project}/locations/{region}/goldengateDeploymentTypes/{goldengate_deployment_type}
category	string	Output only. The category of the Goldengate Deployment Type resource. (DEPLOYMENT_CATEGORY_UNSPECIFIED, DATA_REPLICATION_CATEGORY, DATA_TRANSFORMS_CATEGORY)
connectionTypes	array	Output only. The connection types of the Goldengate Deployment Type resource.
defaultUsername	string	Output only. The default username of the Goldengate Deployment Type resource.
deploymentType	string	Output only. The deployment type of the Goldengate Deployment Type resource. (DEPLOYMENT_TYPE_UNSPECIFIED, OGG, DATABASE_ORACLE, BIGDATA, DATABASE_MICROSOFT_SQLSERVER, DATABASE_MYSQL, DATABASE_POSTGRESQL, DATABASE_DB2ZOS, DATABASE_DB2I, GGSA, DATA_TRANSFORMS)
displayName	string	Output only. The display name of the Goldengate Deployment Type resource.
oggVersion	string	Output only. The Ogg version of the Goldengate Deployment Type resource.
sourceTechnologies	array	Output only. The source technologies of the Goldengate Deployment Type resource.
supportedCapabilities	array	Output only. The supported capabilities of the Goldengate Deployment Type resource.
supportedTechnologiesUrl	string	Output only. The supported technologies URL of the Goldengate Deployment Type resource.
targetTechnologies	array	Output only. The target technologies of the Goldengate Deployment Type resource.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	projectsId, locationsId	filter, pageSize, orderBy, pageToken	Lists GoldenGateDeploymentTypes in a given project and location.

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
locationsId	string
projectsId	string
filter	string
orderBy	string
pageSize	integer (int32)
pageToken	string

SELECT examples

list

Lists GoldenGateDeploymentTypes in a given project and location.

SELECT
name,
category,
connectionTypes,
defaultUsername,
deploymentType,
displayName,
oggVersion,
sourceTechnologies,
supportedCapabilities,
supportedTechnologiesUrl,
targetTechnologies
FROM google.oracledatabase.goldengate_deployment_types
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND filter = '{{ filter }}'
AND pageSize = '{{ pageSize }}'
AND orderBy = '{{ orderBy }}'
AND pageToken = '{{ pageToken }}'
;