Skip to main content

goldengate_deployment_types

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

Overview​

Namegoldengate_deployment_types
TypeResource
Idgoogle.oracledatabase.goldengate_deployment_types

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringIdentifier. The name of the Goldengate Deployment Type resource with the format: projects/{project}/locations/{region}/goldengateDeploymentTypes/{goldengate_deployment_type}
categorystringOutput only. The category of the Goldengate Deployment Type resource. (DEPLOYMENT_CATEGORY_UNSPECIFIED, DATA_REPLICATION_CATEGORY, DATA_TRANSFORMS_CATEGORY)
connectionTypesarrayOutput only. The connection types of the Goldengate Deployment Type resource.
defaultUsernamestringOutput only. The default username of the Goldengate Deployment Type resource.
deploymentTypestringOutput 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)
displayNamestringOutput only. The display name of the Goldengate Deployment Type resource.
oggVersionstringOutput only. The Ogg version of the Goldengate Deployment Type resource.
sourceTechnologiesarrayOutput only. The source technologies of the Goldengate Deployment Type resource.
supportedCapabilitiesarrayOutput only. The supported capabilities of the Goldengate Deployment Type resource.
supportedTechnologiesUrlstringOutput only. The supported technologies URL of the Goldengate Deployment Type resource.
targetTechnologiesarrayOutput only. The target technologies of the Goldengate Deployment Type resource.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectprojectsId, locationsIdfilter, orderBy, pageSize, pageTokenLists 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.

NameDatatypeDescription
locationsIdstring
projectsIdstring
filterstring
orderBystring
pageSizeinteger (int32)
pageTokenstring

SELECT examples​

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 orderBy = '{{ orderBy }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
;