Class MicrosoftSqlserverConnection

Represents the metadata of a Microsoft SQL Server Connection.

Inheritance

object

Connection

MicrosoftSqlserverConnection

Inherited Members

Connection.Id

Connection.DisplayName

Connection.Description

Connection.CompartmentId

Connection.FreeformTags

Connection.DefinedTags

Connection.SystemTags

Connection.LifecycleState

Connection.LifecycleDetails

Connection.TimeCreated

Connection.TimeUpdated

Connection.Locks

Connection.VaultId

Connection.KeyId

Connection.IngressIps

Connection.NsgIds

Connection.SubnetId

Connection.RoutingMethod

Connection.DoesUseSecretIds

Connection.SubscriptionId

Connection.ClusterPlacementGroupId

Connection.SecurityAttributes

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 MicrosoftSqlserverConnection : Connection

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

[Required(ErrorMessage = "DatabaseName is required.")]
[JsonProperty(PropertyName = "databaseName")]
public string DatabaseName { get; set; }

Property Value

Type	Description
string	The name of the database.

Remarks

Required

Host

Declaration

[Required(ErrorMessage = "Host is required.")]
[JsonProperty(PropertyName = "host")]
public string Host { get; set; }

Property Value

Type	Description
string	The name or address of a host.

Remarks

Required

PasswordSecretId

Declaration

[JsonProperty(PropertyName = "passwordSecretId")]
public string PasswordSecretId { get; set; }

Property Value

Type	Description
string	The OCID of the Secret that stores the password Oracle GoldenGate uses to connect the associated Microsoft SQL Server. Note: When provided, 'password' field must not be provided.

Port

Declaration

[Required(ErrorMessage = "Port is required.")]
[JsonProperty(PropertyName = "port")]
public int? Port { get; set; }

Property Value

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

Remarks

Required

PrivateIp

Declaration

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

Property Value

Type	Description
string	This property is not available when creating connections. For existing deprecated connections having this value set, the value cannot be updated; set it to empty. For deprecated connections created with this field in the past, either the private IP had to be specified in the connectionString or host field, or the host name had to be resolvable in the target VCN.

SecurityProtocol

Declaration

[Required(ErrorMessage = "SecurityProtocol is required.")]
[JsonProperty(PropertyName = "securityProtocol")]
[JsonConverter(typeof(ResponseEnumConverter))]
public MicrosoftSqlserverConnection.SecurityProtocolEnum? SecurityProtocol { get; set; }

Property Value

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

Remarks

Required

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).

TechnologyType

Declaration

[Required(ErrorMessage = "TechnologyType is required.")]
[JsonProperty(PropertyName = "technologyType")]
[JsonConverter(typeof(ResponseEnumConverter))]
public MicrosoftSqlserverConnection.TechnologyTypeEnum? TechnologyType { get; set; }

Property Value

Type	Description
MicrosoftSqlserverConnection.TechnologyTypeEnum?	The Microsoft SQL Server technology type.

Remarks

Required

Username

Declaration

[Required(ErrorMessage = "Username is required.")]
[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.

Remarks

Required