Class UpdateMicrosoftSqlserverConnectionDetails

The information to update a Microsoft SQL Server Connection.

Inheritance

object

UpdateConnectionDetails

UpdateMicrosoftSqlserverConnectionDetails

Inherited Members

UpdateConnectionDetails.DisplayName

UpdateConnectionDetails.Description

UpdateConnectionDetails.FreeformTags

UpdateConnectionDetails.DefinedTags

UpdateConnectionDetails.VaultId

UpdateConnectionDetails.KeyId

UpdateConnectionDetails.NsgIds

UpdateConnectionDetails.SubnetId

UpdateConnectionDetails.RoutingMethod

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.GoldengateService.Models

Assembly: OCI.DotNetSDK.Goldengate.dll

Syntax

public class UpdateMicrosoftSqlserverConnectionDetails : UpdateConnectionDetails

Properties

AdditionalAttributes

Declaration

[JsonProperty(PropertyName = "additionalAttributes")]
public List<NameValuePair> AdditionalAttributes { get; set; }

Property Value

Type	Description
List<NameValuePair>	An array of name-value pair attribute entries. Used as additional parameters in connection string.

DatabaseName

Declaration

[JsonProperty(PropertyName = "databaseName")]
public string DatabaseName { get; set; }

Property Value

Type	Description
string	The name of the database.

Host

Declaration

[JsonProperty(PropertyName = "host")]
public string Host { get; set; }

Property Value

Type	Description
string	The name or address of a host.

Password

Declaration

[JsonProperty(PropertyName = "password")]
public string Password { get; set; }

Property Value

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

Port

Declaration

[JsonProperty(PropertyName = "port")]
public int? Port { get; set; }

Property Value

Type	Description
int?	The port of an endpoint usually specified for a connection.

PrivateIp

Declaration

[JsonProperty(PropertyName = "privateIp")]
public string PrivateIp { get; set; }

Property Value

Type

Description

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.

SecurityProtocol

Declaration

[JsonProperty(PropertyName = "securityProtocol")]
[JsonConverter(typeof(StringEnumConverter))]
public MicrosoftSqlserverConnection.SecurityProtocolEnum? SecurityProtocol { get; set; }

Property Value

Type	Description
MicrosoftSqlserverConnection.SecurityProtocolEnum?	Security Type for Microsoft SQL Server.

ShouldValidateServerCertificate

Declaration

[JsonProperty(PropertyName = "shouldValidateServerCertificate")]
public bool? ShouldValidateServerCertificate { get; set; }

Property Value

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

SslCa

Declaration

[JsonProperty(PropertyName = "sslCa")]
public string SslCa { get; set; }

Property Value

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

Username

Declaration

[JsonProperty(PropertyName = "username")]
public string Username { get; set; }

Property Value

Type	Description
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.