Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace UpdateMicrosoftSqlserverConnectionDetails

The information to update a 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.

Const connectionType

connectionType: string = "MICROSOFT_SQLSERVER"

Optional databaseName

databaseName: undefined | 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.

Optional displayName

displayName: undefined | 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\"}}

Optional host

host: undefined | string

The name or address of a host.

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 nsgIds

nsgIds: Array<string>

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

Optional password

password: undefined | string

The password Oracle GoldenGate uses to connect the associated Microsoft SQL Server.

Optional port

port: undefined | 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.

Optional securityProtocol

securityProtocol: undefined | 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 username

username: undefined | 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