OracleConnection

class oci.golden_gate.models.OracleConnection(**kwargs)

Bases: oci.golden_gate.models.connection.Connection

Represents the metadata of an Oracle Database Connection.

Attributes

AUTHENTICATION_MODE_MTLS A constant which can be used with the authentication_mode property of a OracleConnection.
AUTHENTICATION_MODE_TLS A constant which can be used with the authentication_mode property of a OracleConnection.
CONNECTION_TYPE_AMAZON_KINESIS str(object=’’) -> str
CONNECTION_TYPE_AMAZON_REDSHIFT str(object=’’) -> str
CONNECTION_TYPE_AMAZON_S3 str(object=’’) -> str
CONNECTION_TYPE_AZURE_DATA_LAKE_STORAGE str(object=’’) -> str
CONNECTION_TYPE_AZURE_SYNAPSE_ANALYTICS str(object=’’) -> str
CONNECTION_TYPE_DB2 str(object=’’) -> str
CONNECTION_TYPE_ELASTICSEARCH str(object=’’) -> str
CONNECTION_TYPE_GENERIC str(object=’’) -> str
CONNECTION_TYPE_GOLDENGATE str(object=’’) -> str
CONNECTION_TYPE_GOOGLE_BIGQUERY str(object=’’) -> str
CONNECTION_TYPE_GOOGLE_CLOUD_STORAGE str(object=’’) -> str
CONNECTION_TYPE_HDFS str(object=’’) -> str
CONNECTION_TYPE_JAVA_MESSAGE_SERVICE str(object=’’) -> str
CONNECTION_TYPE_KAFKA str(object=’’) -> str
CONNECTION_TYPE_KAFKA_SCHEMA_REGISTRY str(object=’’) -> str
CONNECTION_TYPE_MICROSOFT_SQLSERVER str(object=’’) -> str
CONNECTION_TYPE_MONGODB str(object=’’) -> str
CONNECTION_TYPE_MYSQL str(object=’’) -> str
CONNECTION_TYPE_OCI_OBJECT_STORAGE str(object=’’) -> str
CONNECTION_TYPE_ORACLE str(object=’’) -> str
CONNECTION_TYPE_ORACLE_NOSQL str(object=’’) -> str
CONNECTION_TYPE_POSTGRESQL str(object=’’) -> str
CONNECTION_TYPE_REDIS str(object=’’) -> str
CONNECTION_TYPE_SNOWFLAKE str(object=’’) -> str
LIFECYCLE_STATE_ACTIVE str(object=’’) -> str
LIFECYCLE_STATE_CREATING str(object=’’) -> str
LIFECYCLE_STATE_DELETED str(object=’’) -> str
LIFECYCLE_STATE_DELETING str(object=’’) -> str
LIFECYCLE_STATE_FAILED str(object=’’) -> str
LIFECYCLE_STATE_UPDATING str(object=’’) -> str
ROUTING_METHOD_DEDICATED_ENDPOINT str(object=’’) -> str
ROUTING_METHOD_SHARED_DEPLOYMENT_ENDPOINT str(object=’’) -> str
ROUTING_METHOD_SHARED_SERVICE_ENDPOINT str(object=’’) -> str
SESSION_MODE_DIRECT A constant which can be used with the session_mode property of a OracleConnection.
SESSION_MODE_REDIRECT A constant which can be used with the session_mode property of a OracleConnection.
TECHNOLOGY_TYPE_AMAZON_RDS_ORACLE A constant which can be used with the technology_type property of a OracleConnection.
TECHNOLOGY_TYPE_OCI_AUTONOMOUS_DATABASE A constant which can be used with the technology_type property of a OracleConnection.
TECHNOLOGY_TYPE_ORACLE_DATABASE A constant which can be used with the technology_type property of a OracleConnection.
TECHNOLOGY_TYPE_ORACLE_EXADATA A constant which can be used with the technology_type property of a OracleConnection.
TECHNOLOGY_TYPE_ORACLE_EXADATA_DATABASE_AT_AZURE A constant which can be used with the technology_type property of a OracleConnection.
authentication_mode Gets the authentication_mode of this OracleConnection.
compartment_id [Required] Gets the compartment_id of this Connection.
connection_string Gets the connection_string of this OracleConnection.
connection_type [Required] Gets the connection_type of this Connection.
database_id Gets the database_id of this OracleConnection.
defined_tags Gets the defined_tags of this Connection.
description Gets the description of this Connection.
display_name [Required] Gets the display_name of this Connection.
freeform_tags Gets the freeform_tags of this Connection.
id [Required] Gets the id of this Connection.
ingress_ips Gets the ingress_ips of this Connection.
key_id Gets the key_id of this Connection.
lifecycle_details Gets the lifecycle_details of this Connection.
lifecycle_state [Required] Gets the lifecycle_state of this Connection.
locks Gets the locks of this Connection.
nsg_ids Gets the nsg_ids of this Connection.
private_ip Gets the private_ip of this OracleConnection.
routing_method Gets the routing_method of this Connection.
session_mode Gets the session_mode of this OracleConnection.
subnet_id Gets the subnet_id of this Connection.
system_tags Gets the system_tags of this Connection.
technology_type [Required] Gets the technology_type of this OracleConnection.
time_created [Required] Gets the time_created of this Connection.
time_updated [Required] Gets the time_updated of this Connection.
username [Required] Gets the username of this OracleConnection.
vault_id Gets the vault_id of this Connection.

Methods

__init__(**kwargs) Initializes a new OracleConnection object with values from keyword arguments.
get_subtype(object_dictionary) Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.
AUTHENTICATION_MODE_MTLS = 'MTLS'

A constant which can be used with the authentication_mode property of a OracleConnection. This constant has a value of “MTLS”

AUTHENTICATION_MODE_TLS = 'TLS'

A constant which can be used with the authentication_mode property of a OracleConnection. This constant has a value of “TLS”

CONNECTION_TYPE_AMAZON_KINESIS = 'AMAZON_KINESIS'
CONNECTION_TYPE_AMAZON_REDSHIFT = 'AMAZON_REDSHIFT'
CONNECTION_TYPE_AMAZON_S3 = 'AMAZON_S3'
CONNECTION_TYPE_AZURE_DATA_LAKE_STORAGE = 'AZURE_DATA_LAKE_STORAGE'
CONNECTION_TYPE_AZURE_SYNAPSE_ANALYTICS = 'AZURE_SYNAPSE_ANALYTICS'
CONNECTION_TYPE_DB2 = 'DB2'
CONNECTION_TYPE_ELASTICSEARCH = 'ELASTICSEARCH'
CONNECTION_TYPE_GENERIC = 'GENERIC'
CONNECTION_TYPE_GOLDENGATE = 'GOLDENGATE'
CONNECTION_TYPE_GOOGLE_BIGQUERY = 'GOOGLE_BIGQUERY'
CONNECTION_TYPE_GOOGLE_CLOUD_STORAGE = 'GOOGLE_CLOUD_STORAGE'
CONNECTION_TYPE_HDFS = 'HDFS'
CONNECTION_TYPE_JAVA_MESSAGE_SERVICE = 'JAVA_MESSAGE_SERVICE'
CONNECTION_TYPE_KAFKA = 'KAFKA'
CONNECTION_TYPE_KAFKA_SCHEMA_REGISTRY = 'KAFKA_SCHEMA_REGISTRY'
CONNECTION_TYPE_MICROSOFT_SQLSERVER = 'MICROSOFT_SQLSERVER'
CONNECTION_TYPE_MONGODB = 'MONGODB'
CONNECTION_TYPE_MYSQL = 'MYSQL'
CONNECTION_TYPE_OCI_OBJECT_STORAGE = 'OCI_OBJECT_STORAGE'
CONNECTION_TYPE_ORACLE = 'ORACLE'
CONNECTION_TYPE_ORACLE_NOSQL = 'ORACLE_NOSQL'
CONNECTION_TYPE_POSTGRESQL = 'POSTGRESQL'
CONNECTION_TYPE_REDIS = 'REDIS'
CONNECTION_TYPE_SNOWFLAKE = 'SNOWFLAKE'
LIFECYCLE_STATE_ACTIVE = 'ACTIVE'
LIFECYCLE_STATE_CREATING = 'CREATING'
LIFECYCLE_STATE_DELETED = 'DELETED'
LIFECYCLE_STATE_DELETING = 'DELETING'
LIFECYCLE_STATE_FAILED = 'FAILED'
LIFECYCLE_STATE_UPDATING = 'UPDATING'
ROUTING_METHOD_DEDICATED_ENDPOINT = 'DEDICATED_ENDPOINT'
ROUTING_METHOD_SHARED_DEPLOYMENT_ENDPOINT = 'SHARED_DEPLOYMENT_ENDPOINT'
ROUTING_METHOD_SHARED_SERVICE_ENDPOINT = 'SHARED_SERVICE_ENDPOINT'
SESSION_MODE_DIRECT = 'DIRECT'

A constant which can be used with the session_mode property of a OracleConnection. This constant has a value of “DIRECT”

SESSION_MODE_REDIRECT = 'REDIRECT'

A constant which can be used with the session_mode property of a OracleConnection. This constant has a value of “REDIRECT”

TECHNOLOGY_TYPE_AMAZON_RDS_ORACLE = 'AMAZON_RDS_ORACLE'

A constant which can be used with the technology_type property of a OracleConnection. This constant has a value of “AMAZON_RDS_ORACLE”

TECHNOLOGY_TYPE_OCI_AUTONOMOUS_DATABASE = 'OCI_AUTONOMOUS_DATABASE'

A constant which can be used with the technology_type property of a OracleConnection. This constant has a value of “OCI_AUTONOMOUS_DATABASE”

TECHNOLOGY_TYPE_ORACLE_DATABASE = 'ORACLE_DATABASE'

A constant which can be used with the technology_type property of a OracleConnection. This constant has a value of “ORACLE_DATABASE”

TECHNOLOGY_TYPE_ORACLE_EXADATA = 'ORACLE_EXADATA'

A constant which can be used with the technology_type property of a OracleConnection. This constant has a value of “ORACLE_EXADATA”

TECHNOLOGY_TYPE_ORACLE_EXADATA_DATABASE_AT_AZURE = 'ORACLE_EXADATA_DATABASE_AT_AZURE'

A constant which can be used with the technology_type property of a OracleConnection. This constant has a value of “ORACLE_EXADATA_DATABASE_AT_AZURE”

__init__(**kwargs)

Initializes a new OracleConnection object with values from keyword arguments. The default value of the connection_type attribute of this class is ORACLE and it should not be changed. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:
  • connection_type (str) – The value to assign to the connection_type property of this OracleConnection. Allowed values for this property are: “GOLDENGATE”, “KAFKA”, “KAFKA_SCHEMA_REGISTRY”, “MYSQL”, “JAVA_MESSAGE_SERVICE”, “MICROSOFT_SQLSERVER”, “OCI_OBJECT_STORAGE”, “ORACLE”, “AZURE_DATA_LAKE_STORAGE”, “POSTGRESQL”, “AZURE_SYNAPSE_ANALYTICS”, “SNOWFLAKE”, “AMAZON_S3”, “HDFS”, “ORACLE_NOSQL”, “MONGODB”, “AMAZON_KINESIS”, “AMAZON_REDSHIFT”, “DB2”, “REDIS”, “ELASTICSEARCH”, “GENERIC”, “GOOGLE_CLOUD_STORAGE”, “GOOGLE_BIGQUERY”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
  • id (str) – The value to assign to the id property of this OracleConnection.
  • display_name (str) – The value to assign to the display_name property of this OracleConnection.
  • description (str) – The value to assign to the description property of this OracleConnection.
  • compartment_id (str) – The value to assign to the compartment_id property of this OracleConnection.
  • freeform_tags (dict(str, str)) – The value to assign to the freeform_tags property of this OracleConnection.
  • defined_tags (dict(str, dict(str, object))) – The value to assign to the defined_tags property of this OracleConnection.
  • system_tags (dict(str, dict(str, object))) – The value to assign to the system_tags property of this OracleConnection.
  • lifecycle_state (str) – The value to assign to the lifecycle_state property of this OracleConnection. Allowed values for this property are: “CREATING”, “UPDATING”, “ACTIVE”, “DELETING”, “DELETED”, “FAILED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
  • lifecycle_details (str) – The value to assign to the lifecycle_details property of this OracleConnection.
  • time_created (datetime) – The value to assign to the time_created property of this OracleConnection.
  • time_updated (datetime) – The value to assign to the time_updated property of this OracleConnection.
  • locks (list[oci.golden_gate.models.ResourceLock]) – The value to assign to the locks property of this OracleConnection.
  • vault_id (str) – The value to assign to the vault_id property of this OracleConnection.
  • key_id (str) – The value to assign to the key_id property of this OracleConnection.
  • ingress_ips (list[oci.golden_gate.models.IngressIpDetails]) – The value to assign to the ingress_ips property of this OracleConnection.
  • nsg_ids (list[str]) – The value to assign to the nsg_ids property of this OracleConnection.
  • subnet_id (str) – The value to assign to the subnet_id property of this OracleConnection.
  • routing_method (str) – The value to assign to the routing_method property of this OracleConnection. Allowed values for this property are: “SHARED_SERVICE_ENDPOINT”, “SHARED_DEPLOYMENT_ENDPOINT”, “DEDICATED_ENDPOINT”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
  • technology_type (str) – The value to assign to the technology_type property of this OracleConnection. Allowed values for this property are: “AMAZON_RDS_ORACLE”, “OCI_AUTONOMOUS_DATABASE”, “ORACLE_DATABASE”, “ORACLE_EXADATA”, “ORACLE_EXADATA_DATABASE_AT_AZURE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
  • username (str) – The value to assign to the username property of this OracleConnection.
  • connection_string (str) – The value to assign to the connection_string property of this OracleConnection.
  • authentication_mode (str) – The value to assign to the authentication_mode property of this OracleConnection. Allowed values for this property are: “TLS”, “MTLS”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
  • session_mode (str) – The value to assign to the session_mode property of this OracleConnection. Allowed values for this property are: “DIRECT”, “REDIRECT”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
  • private_ip (str) – The value to assign to the private_ip property of this OracleConnection.
  • database_id (str) – The value to assign to the database_id property of this OracleConnection.
authentication_mode

Gets the authentication_mode of this OracleConnection. Authentication mode. It can be provided at creation of Oracle Autonomous Database Serverless connections, when a databaseId is provided. The default value is MTLS.

Allowed values for this property are: “TLS”, “MTLS”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:The authentication_mode of this OracleConnection.
Return type:str
compartment_id

[Required] Gets the compartment_id of this Connection. The OCID of the compartment being referenced.

Returns:The compartment_id of this Connection.
Return type:str
connection_string

Gets the connection_string of this OracleConnection. Connect descriptor or Easy Connect Naming method used to connect to a database.

Returns:The connection_string of this OracleConnection.
Return type:str
connection_type

[Required] Gets the connection_type of this Connection. The connection type.

Allowed values for this property are: “GOLDENGATE”, “KAFKA”, “KAFKA_SCHEMA_REGISTRY”, “MYSQL”, “JAVA_MESSAGE_SERVICE”, “MICROSOFT_SQLSERVER”, “OCI_OBJECT_STORAGE”, “ORACLE”, “AZURE_DATA_LAKE_STORAGE”, “POSTGRESQL”, “AZURE_SYNAPSE_ANALYTICS”, “SNOWFLAKE”, “AMAZON_S3”, “HDFS”, “ORACLE_NOSQL”, “MONGODB”, “AMAZON_KINESIS”, “AMAZON_REDSHIFT”, “DB2”, “REDIS”, “ELASTICSEARCH”, “GENERIC”, “GOOGLE_CLOUD_STORAGE”, “GOOGLE_BIGQUERY”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:The connection_type of this Connection.
Return type:str
database_id

Gets the database_id of this OracleConnection. The OCID of the database being referenced.

Returns:The database_id of this OracleConnection.
Return type:str
defined_tags

Gets the defined_tags of this Connection. Tags defined for this resource. Each key is predefined and scoped to a namespace.

Example: {“foo-namespace”: {“bar-key”: “value”}}

Returns:The defined_tags of this Connection.
Return type:dict(str, dict(str, object))
description

Gets the description of this Connection. Metadata about this specific object.

Returns:The description of this Connection.
Return type:str
display_name

[Required] Gets the display_name of this Connection. An object’s Display Name.

Returns:The display_name of this Connection.
Return type:str
freeform_tags

Gets the freeform_tags of this Connection. A simple key-value pair that is applied without any predefined name, type, or scope. Exists for cross-compatibility only.

Example: {“bar-key”: “value”}

Returns:The freeform_tags of this Connection.
Return type:dict(str, str)
static get_subtype(object_dictionary)

Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.

id

[Required] Gets the id of this Connection. The OCID of the connection being referenced.

Returns:The id of this Connection.
Return type:str
ingress_ips

Gets the ingress_ips of this Connection. List of ingress IP addresses from where the GoldenGate deployment connects to this connection’s privateIp. Customers may optionally set up ingress security rules to restrict traffic from these IP addresses.

Returns:The ingress_ips of this Connection.
Return type:list[oci.golden_gate.models.IngressIpDetails]
key_id

Gets the key_id of this Connection. Refers to the customer’s master key OCID. If provided, it references a key to manage secrets. Customers must add policies to permit GoldenGate to use this key.

Returns:The key_id of this Connection.
Return type:str
lifecycle_details

Gets the lifecycle_details of this Connection. Describes the object’s current state in detail. For example, it can be used to provide actionable information for a resource in a Failed state.

Returns:The lifecycle_details of this Connection.
Return type:str
lifecycle_state

[Required] Gets the lifecycle_state of this Connection. Possible lifecycle states for connection.

Allowed values for this property are: “CREATING”, “UPDATING”, “ACTIVE”, “DELETING”, “DELETED”, “FAILED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:The lifecycle_state of this Connection.
Return type:str
locks

Gets the locks of this Connection. Locks associated with this resource.

Returns:The locks of this Connection.
Return type:list[oci.golden_gate.models.ResourceLock]
nsg_ids

Gets the nsg_ids of this Connection. An array of Network Security Group OCIDs used to define network access for either Deployments or Connections.

Returns:The nsg_ids of this Connection.
Return type:list[str]
private_ip

Gets the private_ip of this OracleConnection. Deprecated: this field will be removed in future versions. Either specify the private IP in the connectionString or host field, or make sure the host name is resolvable in the target VCN.

The private IP address of the connection’s endpoint in the customer’s VCN, typically a database endpoint or a big data endpoint (e.g. Kafka bootstrap server). In case the privateIp is provided, the subnetId must also be provided. In case the privateIp (and the subnetId) is not provided it is assumed the datasource is publicly accessible. In case the connection is accessible only privately, the lack of privateIp will result in not being able to access the connection.

Returns:The private_ip of this OracleConnection.
Return type:str
routing_method

Gets the routing_method of this Connection. Controls the network traffic direction to the target: SHARED_SERVICE_ENDPOINT: Traffic flows through the Goldengate Service’s network to public hosts. Cannot be used for private targets. SHARED_DEPLOYMENT_ENDPOINT: Network traffic flows from the assigned deployment’s private endpoint through the deployment’s subnet. DEDICATED_ENDPOINT: A dedicated private endpoint is created in the target VCN subnet for the connection. The subnetId is required when DEDICATED_ENDPOINT networking is selected.

Allowed values for this property are: “SHARED_SERVICE_ENDPOINT”, “SHARED_DEPLOYMENT_ENDPOINT”, “DEDICATED_ENDPOINT”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:The routing_method of this Connection.
Return type:str
session_mode

Gets the session_mode of this OracleConnection. The mode of the database connection session to be established by the data client. ‘REDIRECT’ - for a RAC database, ‘DIRECT’ - for a non-RAC database. Connection to a RAC database involves a redirection received from the SCAN listeners to the database node to connect to. By default the mode would be DIRECT.

Allowed values for this property are: “DIRECT”, “REDIRECT”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:The session_mode of this OracleConnection.
Return type:str
subnet_id

Gets the subnet_id of this Connection. The OCID of the target subnet of the dedicated connection.

Returns:The subnet_id of this Connection.
Return type:str
system_tags

Gets the system_tags of this Connection. The system tags associated with this resource, if any. The system tags are set by Oracle Cloud Infrastructure services. Each key is predefined and scoped to namespaces. For more information, see Resource Tags.

Example: {orcl-cloud: {free-tier-retain: true}}

Returns:The system_tags of this Connection.
Return type:dict(str, dict(str, object))
technology_type

[Required] Gets the technology_type of this OracleConnection. The Oracle technology type.

Allowed values for this property are: “AMAZON_RDS_ORACLE”, “OCI_AUTONOMOUS_DATABASE”, “ORACLE_DATABASE”, “ORACLE_EXADATA”, “ORACLE_EXADATA_DATABASE_AT_AZURE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:The technology_type of this OracleConnection.
Return type:str
time_created

[Required] Gets the time_created of this Connection. The time the resource was created. The format is defined by RFC3339, such as 2016-08-25T21:10:29.600Z.

Returns:The time_created of this Connection.
Return type:datetime
time_updated

[Required] Gets the time_updated of this Connection. The time the resource was last updated. The format is defined by RFC3339, such as 2016-08-25T21:10:29.600Z.

Returns:The time_updated of this Connection.
Return type:datetime
username

[Required] Gets the username of this OracleConnection. The username Oracle GoldenGate uses to connect the associated system of the given technology. This username must already exist and be available by the system/application to be connected to and must conform to the case sensitivty requirments defined in it.

Returns:The username of this OracleConnection.
Return type:str
vault_id

Gets the vault_id of this Connection. Refers to the customer’s vault OCID. If provided, it references a vault where GoldenGate can manage secrets. Customers must add policies to permit GoldenGate to manage secrets contained within this vault.

Returns:The vault_id of this Connection.
Return type:str