SqlServerLinkedService Class

public final class SqlServerLinkedService
extends LinkedService

SQL Server linked service.

Constructor Summary

Constructor Description
SqlServerLinkedService()

Creates an instance of SqlServerLinkedService class.

Method Summary

Modifier and Type Method and Description
SqlAlwaysEncryptedProperties alwaysEncryptedSettings()

Get the alwaysEncryptedSettings property: Sql always encrypted properties.

Object applicationIntent()

Get the applicationIntent property: The application workload type when connecting to a server, used by recommended version.

SqlServerAuthenticationType authenticationType()

Get the authenticationType property: The type used for authentication.

Object commandTimeout()

Get the commandTimeout property: The default wait time (in seconds) before terminating the attempt to execute a command and generating an error, used by recommended version.

Object connectionString()

Get the connectionString property: The connection string.

Object connectRetryCount()

Get the connectRetryCount property: The number of re-connections attempted after identifying that there was an idle connection failure, used by recommended version.

Object connectRetryInterval()

Get the connectRetryInterval property: The amount of time (in seconds) between each re-connection attempt after identifying that there was an idle connection failure, used by recommended version.

Object connectTimeout()

Get the connectTimeout property: The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error, used by recommended version.

CredentialReference credential()

Get the credential property: The credential reference containing authentication information.

Object database()

Get the database property: The name of the database, used by recommended version.

Object encrypt()

Get the encrypt property: Indicate whether TLS encryption is required for all data sent between the client and server, used by recommended version.

String encryptedCredential()

Get the encryptedCredential property: The encrypted credential used for authentication.

Object failoverPartner()

Get the failoverPartner property: The name or address of the partner server to connect to if the primary server is down, used by recommended version.

static SqlServerLinkedService fromJson(JsonReader jsonReader)

Reads an instance of SqlServerLinkedService from the JsonReader.

Object hostnameInCertificate()

Get the hostnameInCertificate property: The host name to use when validating the server certificate for the connection.

Object integratedSecurity()

Get the integratedSecurity property: Indicate whether User ID and Password are specified in the connection (when false) or whether the current Windows account credentials are used for authentication (when true), used by recommended version.

Object loadBalanceTimeout()

Get the loadBalanceTimeout property: The minimum time, in seconds, for the connection to live in the connection pool before being destroyed, used by recommended version.

Object maxPoolSize()

Get the maxPoolSize property: The maximum number of connections allowed in the connection pool for this specific connection string, used by recommended version.

Object minPoolSize()

Get the minPoolSize property: The minimum number of connections allowed in the connection pool for this specific connection string, used by recommended version.

Object multipleActiveResultSets()

Get the multipleActiveResultSets property: When true, an application can maintain multiple active result sets (MARS).

Object multiSubnetFailover()

Get the multiSubnetFailover property: If your application is connecting to an AlwaysOn availability group (AG) on different subnets, setting MultiSubnetFailover=true provides faster detection of and connection to the (currently) active server, used by recommended version.

Object packetSize()

Get the packetSize property: The size in bytes of the network packets used to communicate with an instance of server, used by recommended version.

SecretBase password()

Get the password property: The on-premises Windows authentication password.

Object pooling()

Get the pooling property: Indicate whether the connection will be pooled or explicitly opened every time that the connection is requested, used by recommended version.

Object server()

Get the server property: The name or network address of the instance of SQL Server to which to connect, used by recommended version.

JsonWriter toJson(JsonWriter jsonWriter)
Object trustServerCertificate()

Get the trustServerCertificate property: Indicate whether the channel will be encrypted while bypassing walking the certificate chain to validate trust, used by recommended version.

String type()

Get the type property: Type of linked service.

Object username()

Get the username property: The on-premises Windows authentication user name.

void validate()

Validates the instance.

SqlServerLinkedService withAlwaysEncryptedSettings(SqlAlwaysEncryptedProperties alwaysEncryptedSettings)

Set the alwaysEncryptedSettings property: Sql always encrypted properties.

SqlServerLinkedService withAnnotations(List<Object> annotations)

Set the annotations property: List of tags that can be used for describing the linked service.

SqlServerLinkedService withApplicationIntent(Object applicationIntent)

Set the applicationIntent property: The application workload type when connecting to a server, used by recommended version.

SqlServerLinkedService withAuthenticationType(SqlServerAuthenticationType authenticationType)

Set the authenticationType property: The type used for authentication.

SqlServerLinkedService withCommandTimeout(Object commandTimeout)

Set the commandTimeout property: The default wait time (in seconds) before terminating the attempt to execute a command and generating an error, used by recommended version.

SqlServerLinkedService withConnectionString(Object connectionString)

Set the connectionString property: The connection string.

SqlServerLinkedService withConnectRetryCount(Object connectRetryCount)

Set the connectRetryCount property: The number of re-connections attempted after identifying that there was an idle connection failure, used by recommended version.

SqlServerLinkedService withConnectRetryInterval(Object connectRetryInterval)

Set the connectRetryInterval property: The amount of time (in seconds) between each re-connection attempt after identifying that there was an idle connection failure, used by recommended version.

SqlServerLinkedService withConnectTimeout(Object connectTimeout)

Set the connectTimeout property: The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error, used by recommended version.

SqlServerLinkedService withConnectVia(IntegrationRuntimeReference connectVia)

Set the connectVia property: The integration runtime reference.

SqlServerLinkedService withCredential(CredentialReference credential)

Set the credential property: The credential reference containing authentication information.

SqlServerLinkedService withDatabase(Object database)

Set the database property: The name of the database, used by recommended version.

SqlServerLinkedService withDescription(String description)

Set the description property: Linked service description.

SqlServerLinkedService withEncrypt(Object encrypt)

Set the encrypt property: Indicate whether TLS encryption is required for all data sent between the client and server, used by recommended version.

SqlServerLinkedService withEncryptedCredential(String encryptedCredential)

Set the encryptedCredential property: The encrypted credential used for authentication.

SqlServerLinkedService withFailoverPartner(Object failoverPartner)

Set the failoverPartner property: The name or address of the partner server to connect to if the primary server is down, used by recommended version.

SqlServerLinkedService withHostnameInCertificate(Object hostnameInCertificate)

Set the hostnameInCertificate property: The host name to use when validating the server certificate for the connection.

SqlServerLinkedService withIntegratedSecurity(Object integratedSecurity)

Set the integratedSecurity property: Indicate whether User ID and Password are specified in the connection (when false) or whether the current Windows account credentials are used for authentication (when true), used by recommended version.

SqlServerLinkedService withLoadBalanceTimeout(Object loadBalanceTimeout)

Set the loadBalanceTimeout property: The minimum time, in seconds, for the connection to live in the connection pool before being destroyed, used by recommended version.

SqlServerLinkedService withMaxPoolSize(Object maxPoolSize)

Set the maxPoolSize property: The maximum number of connections allowed in the connection pool for this specific connection string, used by recommended version.

SqlServerLinkedService withMinPoolSize(Object minPoolSize)

Set the minPoolSize property: The minimum number of connections allowed in the connection pool for this specific connection string, used by recommended version.

SqlServerLinkedService withMultipleActiveResultSets(Object multipleActiveResultSets)

Set the multipleActiveResultSets property: When true, an application can maintain multiple active result sets (MARS).

SqlServerLinkedService withMultiSubnetFailover(Object multiSubnetFailover)

Set the multiSubnetFailover property: If your application is connecting to an AlwaysOn availability group (AG) on different subnets, setting MultiSubnetFailover=true provides faster detection of and connection to the (currently) active server, used by recommended version.

SqlServerLinkedService withPacketSize(Object packetSize)

Set the packetSize property: The size in bytes of the network packets used to communicate with an instance of server, used by recommended version.

SqlServerLinkedService withParameters(Map<String,ParameterSpecification> parameters)

Set the parameters property: Parameters for linked service.

SqlServerLinkedService withPassword(SecretBase password)

Set the password property: The on-premises Windows authentication password.

SqlServerLinkedService withPooling(Object pooling)

Set the pooling property: Indicate whether the connection will be pooled or explicitly opened every time that the connection is requested, used by recommended version.

SqlServerLinkedService withServer(Object server)

Set the server property: The name or network address of the instance of SQL Server to which to connect, used by recommended version.

SqlServerLinkedService withTrustServerCertificate(Object trustServerCertificate)

Set the trustServerCertificate property: Indicate whether the channel will be encrypted while bypassing walking the certificate chain to validate trust, used by recommended version.

SqlServerLinkedService withUsername(Object username)

Set the username property: The on-premises Windows authentication user name.

SqlServerLinkedService withVersion(String version)

Set the version property: Version of the linked service.

Methods inherited from LinkedService

Methods inherited from java.lang.Object

Constructor Details

SqlServerLinkedService

public SqlServerLinkedService()

Creates an instance of SqlServerLinkedService class.

Method Details

alwaysEncryptedSettings

public SqlAlwaysEncryptedProperties alwaysEncryptedSettings()

Get the alwaysEncryptedSettings property: Sql always encrypted properties.

Returns:

the alwaysEncryptedSettings value.

applicationIntent

public Object applicationIntent()

Get the applicationIntent property: The application workload type when connecting to a server, used by recommended version. Possible values are ReadOnly and ReadWrite. Type: string (or Expression with resultType string).

Returns:

the applicationIntent value.

authenticationType

public SqlServerAuthenticationType authenticationType()

Get the authenticationType property: The type used for authentication. Type: string.

Returns:

the authenticationType value.

commandTimeout

public Object commandTimeout()

Get the commandTimeout property: The default wait time (in seconds) before terminating the attempt to execute a command and generating an error, used by recommended version. Type: integer (or Expression with resultType integer).

Returns:

the commandTimeout value.

connectionString

public Object connectionString()

Get the connectionString property: The connection string. Type: string, SecureString or AzureKeyVaultSecretReference.

Returns:

the connectionString value.

connectRetryCount

public Object connectRetryCount()

Get the connectRetryCount property: The number of re-connections attempted after identifying that there was an idle connection failure, used by recommended version. This must be an integer between 0 and 255. Type: integer (or Expression with resultType integer).

Returns:

the connectRetryCount value.

connectRetryInterval

public Object connectRetryInterval()

Get the connectRetryInterval property: The amount of time (in seconds) between each re-connection attempt after identifying that there was an idle connection failure, used by recommended version. This must be an integer between 1 and 60. Type: integer (or Expression with resultType integer).

Returns:

the connectRetryInterval value.

connectTimeout

public Object connectTimeout()

Get the connectTimeout property: The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error, used by recommended version. Type: integer (or Expression with resultType integer).

Returns:

the connectTimeout value.

credential

public CredentialReference credential()

Get the credential property: The credential reference containing authentication information.

Returns:

the credential value.

database

public Object database()

Get the database property: The name of the database, used by recommended version. Type: string (or Expression with resultType string).

Returns:

the database value.

encrypt

public Object encrypt()

Get the encrypt property: Indicate whether TLS encryption is required for all data sent between the client and server, used by recommended version. Possible values are true/yes/mandatory, false/no/optional and strict. Type: string (or Expression with resultType string).

Returns:

the encrypt value.

encryptedCredential

public String encryptedCredential()

Get the encryptedCredential property: The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string.

Returns:

the encryptedCredential value.

failoverPartner

public Object failoverPartner()

Get the failoverPartner property: The name or address of the partner server to connect to if the primary server is down, used by recommended version. Type: string (or Expression with resultType string).

Returns:

the failoverPartner value.

fromJson

public static SqlServerLinkedService fromJson(JsonReader jsonReader)

Reads an instance of SqlServerLinkedService from the JsonReader.

Parameters:

jsonReader - The JsonReader being read.

Returns:

An instance of SqlServerLinkedService if the JsonReader was pointing to an instance of it, or null if it was pointing to JSON null.

Throws:

IOException

- If the deserialized JSON object was missing any required properties.

hostnameInCertificate

public Object hostnameInCertificate()

Get the hostnameInCertificate property: The host name to use when validating the server certificate for the connection. When not specified, the server name from the Data Source is used for certificate validation, used by recommended version. Type: string (or Expression with resultType string).

Returns:

the hostnameInCertificate value.

integratedSecurity

public Object integratedSecurity()

Get the integratedSecurity property: Indicate whether User ID and Password are specified in the connection (when false) or whether the current Windows account credentials are used for authentication (when true), used by recommended version. Type: Boolean (or Expression with resultType boolean).

Returns:

the integratedSecurity value.

loadBalanceTimeout

public Object loadBalanceTimeout()

Get the loadBalanceTimeout property: The minimum time, in seconds, for the connection to live in the connection pool before being destroyed, used by recommended version. Type: integer (or Expression with resultType integer).

Returns:

the loadBalanceTimeout value.

maxPoolSize

public Object maxPoolSize()

Get the maxPoolSize property: The maximum number of connections allowed in the connection pool for this specific connection string, used by recommended version. Type: integer (or Expression with resultType integer).

Returns:

the maxPoolSize value.

minPoolSize

public Object minPoolSize()

Get the minPoolSize property: The minimum number of connections allowed in the connection pool for this specific connection string, used by recommended version. Type: integer (or Expression with resultType integer).

Returns:

the minPoolSize value.

multipleActiveResultSets

public Object multipleActiveResultSets()

Get the multipleActiveResultSets property: When true, an application can maintain multiple active result sets (MARS). When false, an application must process or cancel all result sets from one batch before it can execute any other batch on that connection, used by recommended version. Type: Boolean (or Expression with resultType boolean).

Returns:

the multipleActiveResultSets value.

multiSubnetFailover

public Object multiSubnetFailover()

Get the multiSubnetFailover property: If your application is connecting to an AlwaysOn availability group (AG) on different subnets, setting MultiSubnetFailover=true provides faster detection of and connection to the (currently) active server, used by recommended version. Type: Boolean (or Expression with resultType boolean).

Returns:

the multiSubnetFailover value.

packetSize

public Object packetSize()

Get the packetSize property: The size in bytes of the network packets used to communicate with an instance of server, used by recommended version. Type: integer (or Expression with resultType integer).

Returns:

the packetSize value.

password

public SecretBase password()

Get the password property: The on-premises Windows authentication password.

Returns:

the password value.

pooling

public Object pooling()

Get the pooling property: Indicate whether the connection will be pooled or explicitly opened every time that the connection is requested, used by recommended version. Type: Boolean (or Expression with resultType boolean).

Returns:

the pooling value.

server

public Object server()

Get the server property: The name or network address of the instance of SQL Server to which to connect, used by recommended version. Type: string (or Expression with resultType string).

Returns:

the server value.

toJson

public JsonWriter toJson(JsonWriter jsonWriter)

Overrides:

SqlServerLinkedService.toJson(JsonWriter jsonWriter)

Parameters:

jsonWriter

Throws:

trustServerCertificate

public Object trustServerCertificate()

Get the trustServerCertificate property: Indicate whether the channel will be encrypted while bypassing walking the certificate chain to validate trust, used by recommended version. Type: Boolean (or Expression with resultType boolean).

Returns:

the trustServerCertificate value.

type

public String type()

Get the type property: Type of linked service.

Overrides:

SqlServerLinkedService.type()

Returns:

the type value.

username

public Object username()

Get the username property: The on-premises Windows authentication user name. Type: string (or Expression with resultType string).

Returns:

the username value.

validate

public void validate()

Validates the instance.

Overrides:

SqlServerLinkedService.validate()

withAlwaysEncryptedSettings

public SqlServerLinkedService withAlwaysEncryptedSettings(SqlAlwaysEncryptedProperties alwaysEncryptedSettings)

Set the alwaysEncryptedSettings property: Sql always encrypted properties.

Parameters:

alwaysEncryptedSettings - the alwaysEncryptedSettings value to set.

Returns:

the SqlServerLinkedService object itself.

withAnnotations

public SqlServerLinkedService withAnnotations(List<Object> annotations)

Set the annotations property: List of tags that can be used for describing the linked service.

Overrides:

SqlServerLinkedService.withAnnotations(List<Object> annotations)

Parameters:

annotations

withApplicationIntent

public SqlServerLinkedService withApplicationIntent(Object applicationIntent)

Set the applicationIntent property: The application workload type when connecting to a server, used by recommended version. Possible values are ReadOnly and ReadWrite. Type: string (or Expression with resultType string).

Parameters:

applicationIntent - the applicationIntent value to set.

Returns:

the SqlServerLinkedService object itself.

withAuthenticationType

public SqlServerLinkedService withAuthenticationType(SqlServerAuthenticationType authenticationType)

Set the authenticationType property: The type used for authentication. Type: string.

Parameters:

authenticationType - the authenticationType value to set.

Returns:

the SqlServerLinkedService object itself.

withCommandTimeout

public SqlServerLinkedService withCommandTimeout(Object commandTimeout)

Set the commandTimeout property: The default wait time (in seconds) before terminating the attempt to execute a command and generating an error, used by recommended version. Type: integer (or Expression with resultType integer).

Parameters:

commandTimeout - the commandTimeout value to set.

Returns:

the SqlServerLinkedService object itself.

withConnectionString

public SqlServerLinkedService withConnectionString(Object connectionString)

Set the connectionString property: The connection string. Type: string, SecureString or AzureKeyVaultSecretReference.

Parameters:

connectionString - the connectionString value to set.

Returns:

the SqlServerLinkedService object itself.

withConnectRetryCount

public SqlServerLinkedService withConnectRetryCount(Object connectRetryCount)

Set the connectRetryCount property: The number of re-connections attempted after identifying that there was an idle connection failure, used by recommended version. This must be an integer between 0 and 255. Type: integer (or Expression with resultType integer).

Parameters:

connectRetryCount - the connectRetryCount value to set.

Returns:

the SqlServerLinkedService object itself.

withConnectRetryInterval

public SqlServerLinkedService withConnectRetryInterval(Object connectRetryInterval)

Set the connectRetryInterval property: The amount of time (in seconds) between each re-connection attempt after identifying that there was an idle connection failure, used by recommended version. This must be an integer between 1 and 60. Type: integer (or Expression with resultType integer).

Parameters:

connectRetryInterval - the connectRetryInterval value to set.

Returns:

the SqlServerLinkedService object itself.

withConnectTimeout

public SqlServerLinkedService withConnectTimeout(Object connectTimeout)

Set the connectTimeout property: The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error, used by recommended version. Type: integer (or Expression with resultType integer).

Parameters:

connectTimeout - the connectTimeout value to set.

Returns:

the SqlServerLinkedService object itself.

withConnectVia

public SqlServerLinkedService withConnectVia(IntegrationRuntimeReference connectVia)

Set the connectVia property: The integration runtime reference.

Overrides:

SqlServerLinkedService.withConnectVia(IntegrationRuntimeReference connectVia)

Parameters:

connectVia

withCredential

public SqlServerLinkedService withCredential(CredentialReference credential)

Set the credential property: The credential reference containing authentication information.

Parameters:

credential - the credential value to set.

Returns:

the SqlServerLinkedService object itself.

withDatabase

public SqlServerLinkedService withDatabase(Object database)

Set the database property: The name of the database, used by recommended version. Type: string (or Expression with resultType string).

Parameters:

database - the database value to set.

Returns:

the SqlServerLinkedService object itself.

withDescription

public SqlServerLinkedService withDescription(String description)

Set the description property: Linked service description.

Overrides:

SqlServerLinkedService.withDescription(String description)

Parameters:

description

withEncrypt

public SqlServerLinkedService withEncrypt(Object encrypt)

Set the encrypt property: Indicate whether TLS encryption is required for all data sent between the client and server, used by recommended version. Possible values are true/yes/mandatory, false/no/optional and strict. Type: string (or Expression with resultType string).

Parameters:

encrypt - the encrypt value to set.

Returns:

the SqlServerLinkedService object itself.

withEncryptedCredential

public SqlServerLinkedService withEncryptedCredential(String encryptedCredential)

Set the encryptedCredential property: The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string.

Parameters:

encryptedCredential - the encryptedCredential value to set.

Returns:

the SqlServerLinkedService object itself.

withFailoverPartner

public SqlServerLinkedService withFailoverPartner(Object failoverPartner)

Set the failoverPartner property: The name or address of the partner server to connect to if the primary server is down, used by recommended version. Type: string (or Expression with resultType string).

Parameters:

failoverPartner - the failoverPartner value to set.

Returns:

the SqlServerLinkedService object itself.

withHostnameInCertificate

public SqlServerLinkedService withHostnameInCertificate(Object hostnameInCertificate)

Set the hostnameInCertificate property: The host name to use when validating the server certificate for the connection. When not specified, the server name from the Data Source is used for certificate validation, used by recommended version. Type: string (or Expression with resultType string).

Parameters:

hostnameInCertificate - the hostnameInCertificate value to set.

Returns:

the SqlServerLinkedService object itself.

withIntegratedSecurity

public SqlServerLinkedService withIntegratedSecurity(Object integratedSecurity)

Set the integratedSecurity property: Indicate whether User ID and Password are specified in the connection (when false) or whether the current Windows account credentials are used for authentication (when true), used by recommended version. Type: Boolean (or Expression with resultType boolean).

Parameters:

integratedSecurity - the integratedSecurity value to set.

Returns:

the SqlServerLinkedService object itself.

withLoadBalanceTimeout

public SqlServerLinkedService withLoadBalanceTimeout(Object loadBalanceTimeout)

Set the loadBalanceTimeout property: The minimum time, in seconds, for the connection to live in the connection pool before being destroyed, used by recommended version. Type: integer (or Expression with resultType integer).

Parameters:

loadBalanceTimeout - the loadBalanceTimeout value to set.

Returns:

the SqlServerLinkedService object itself.

withMaxPoolSize

public SqlServerLinkedService withMaxPoolSize(Object maxPoolSize)

Set the maxPoolSize property: The maximum number of connections allowed in the connection pool for this specific connection string, used by recommended version. Type: integer (or Expression with resultType integer).

Parameters:

maxPoolSize - the maxPoolSize value to set.

Returns:

the SqlServerLinkedService object itself.

withMinPoolSize

public SqlServerLinkedService withMinPoolSize(Object minPoolSize)

Set the minPoolSize property: The minimum number of connections allowed in the connection pool for this specific connection string, used by recommended version. Type: integer (or Expression with resultType integer).

Parameters:

minPoolSize - the minPoolSize value to set.

Returns:

the SqlServerLinkedService object itself.

withMultipleActiveResultSets

public SqlServerLinkedService withMultipleActiveResultSets(Object multipleActiveResultSets)

Set the multipleActiveResultSets property: When true, an application can maintain multiple active result sets (MARS). When false, an application must process or cancel all result sets from one batch before it can execute any other batch on that connection, used by recommended version. Type: Boolean (or Expression with resultType boolean).

Parameters:

multipleActiveResultSets - the multipleActiveResultSets value to set.

Returns:

the SqlServerLinkedService object itself.

withMultiSubnetFailover

public SqlServerLinkedService withMultiSubnetFailover(Object multiSubnetFailover)

Set the multiSubnetFailover property: If your application is connecting to an AlwaysOn availability group (AG) on different subnets, setting MultiSubnetFailover=true provides faster detection of and connection to the (currently) active server, used by recommended version. Type: Boolean (or Expression with resultType boolean).

Parameters:

multiSubnetFailover - the multiSubnetFailover value to set.

Returns:

the SqlServerLinkedService object itself.

withPacketSize

public SqlServerLinkedService withPacketSize(Object packetSize)

Set the packetSize property: The size in bytes of the network packets used to communicate with an instance of server, used by recommended version. Type: integer (or Expression with resultType integer).

Parameters:

packetSize - the packetSize value to set.

Returns:

the SqlServerLinkedService object itself.

withParameters

public SqlServerLinkedService withParameters(Map<String,ParameterSpecification> parameters)

Set the parameters property: Parameters for linked service.

Overrides:

SqlServerLinkedService.withParameters(Map<String,ParameterSpecification> parameters)

Parameters:

parameters

withPassword

public SqlServerLinkedService withPassword(SecretBase password)

Set the password property: The on-premises Windows authentication password.

Parameters:

password - the password value to set.

Returns:

the SqlServerLinkedService object itself.

withPooling

public SqlServerLinkedService withPooling(Object pooling)

Set the pooling property: Indicate whether the connection will be pooled or explicitly opened every time that the connection is requested, used by recommended version. Type: Boolean (or Expression with resultType boolean).

Parameters:

pooling - the pooling value to set.

Returns:

the SqlServerLinkedService object itself.

withServer

public SqlServerLinkedService withServer(Object server)

Set the server property: The name or network address of the instance of SQL Server to which to connect, used by recommended version. Type: string (or Expression with resultType string).

Parameters:

server - the server value to set.

Returns:

the SqlServerLinkedService object itself.

withTrustServerCertificate

public SqlServerLinkedService withTrustServerCertificate(Object trustServerCertificate)

Set the trustServerCertificate property: Indicate whether the channel will be encrypted while bypassing walking the certificate chain to validate trust, used by recommended version. Type: Boolean (or Expression with resultType boolean).

Parameters:

trustServerCertificate - the trustServerCertificate value to set.

Returns:

the SqlServerLinkedService object itself.

withUsername

public SqlServerLinkedService withUsername(Object username)

Set the username property: The on-premises Windows authentication user name. Type: string (or Expression with resultType string).

Parameters:

username - the username value to set.

Returns:

the SqlServerLinkedService object itself.

withVersion

public SqlServerLinkedService withVersion(String version)

Set the version property: Version of the linked service.

Overrides:

SqlServerLinkedService.withVersion(String version)

Parameters:

version

Applies to