Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace MicrosoftSqlserverConnectionSummary

Summary of the Microsoft SQL Server Connection.

Properties

Optional additionalAttributes

additionalAttributes: Array<NameValuePair>

An array of name-value pair attribute entries. Used as additional parameters in connection string.

compartmentId

compartmentId: string

The OCID of the compartment being referenced.

Const connectionType

connectionType: string = "MICROSOFT_SQLSERVER"

databaseName

databaseName: string

The name of the database.

Optional definedTags

definedTags: undefined | object

Tags defined for this resource. Each key is predefined and scoped to a namespace.

Example: {@code {\"foo-namespace\": {\"bar-key\": \"value\"}}}

Optional description

description: undefined | string

Metadata about this specific object.

displayName

displayName: string

An object's Display Name.

Optional freeformTags

freeformTags: undefined | object

A simple key-value pair that is applied without any predefined name, type, or scope. Exists for cross-compatibility only.

Example: {@code {\"bar-key\": \"value\"}}

host

host: string

The name or address of a host.

id

id: string

The OCID of the connection being referenced.

Optional ingressIps

ingressIps: Array<IngressIpDetails>

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.

Optional keyId

keyId: undefined | string

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.

Optional lifecycleDetails

lifecycleDetails: undefined | string

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.

lifecycleState

lifecycleState: string

Possible lifecycle states for connection.

Optional nsgIds

nsgIds: Array<string>

An array of Network Security Group OCIDs used to define network access for either Deployments or Connections.

port

port: number

The port of an endpoint usually specified for a connection. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional privateIp

privateIp: undefined | string

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.

Optional routingMethod

routingMethod: model.RoutingMethod

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.

securityProtocol

securityProtocol: string

Security Type for Microsoft SQL Server.

Optional shouldValidateServerCertificate

shouldValidateServerCertificate: undefined | false | true

If set to true, the driver validates the certificate that is sent by the database server.

Optional sslCa

sslCa: undefined | string

Database Certificate - The base64 encoded content of a .pem or .crt file. containing the server public key (for 1-way SSL).

Optional subnetId

subnetId: undefined | string

The OCID of the target subnet of the dedicated connection.

Optional systemTags

systemTags: undefined | object

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: {@code {orcl-cloud: {free-tier-retain: true}}}

technologyType

technologyType: string

The Microsoft SQL Server technology type.

timeCreated

timeCreated: Date

The time the resource was created. The format is defined by RFC3339, such as {@code 2016-08-25T21:10:29.600Z}.

timeUpdated

timeUpdated: Date

The time the resource was last updated. The format is defined by RFC3339, such as {@code 2016-08-25T21:10:29.600Z}.

username

username: string

The username Oracle GoldenGate uses to connect to the Microsoft SQL Server. This username must already exist and be available by the Microsoft SQL Server to be connected to.

Optional vaultId

vaultId: undefined | string

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.

Methods

getDeserializedJsonObj

getJsonObj