Class MySqlLinkedService
Linked service for MySQL data source.
Inherited Members
Namespace: System.Dynamic.ExpandoObject
Assembly: Azure.Analytics.Synapse.Artifacts.dll
Syntax
[System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.MySqlLinkedService/MySqlLinkedServiceConverter))]
public class MySqlLinkedService : Azure.Analytics.Synapse.Artifacts.Models.LinkedServiceConstructors
MySqlLinkedService()
Properties
AllowZeroDateTime
This allows the special “zero” date value 0000-00-00 to be retrieved from the database. Type: boolean.
Declaration
public object AllowZeroDateTime { get; set; }Property Value
|
System.Object
|
ConnectionString
The connection string.
Declaration
public object ConnectionString { get; set; }Property Value
|
System.Object
|
ConnectionTimeout
The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error. Type: integer.
Declaration
public object ConnectionTimeout { get; set; }Property Value
|
System.Object
|
ConvertZeroDateTime
True to return DateTime.MinValue for date or datetime columns that have disallowed values. Type: boolean.
Declaration
public object ConvertZeroDateTime { get; set; }Property Value
|
System.Object
|
Database
Database name for connection. Type: string.
Declaration
public object Database { get; set; }Property Value
|
System.Object
|
DriverVersion
The version of the MySQL driver. Type: string. V1 or empty for legacy driver, V2 for new driver. V1 can support connection string and property bag, V2 can only support connection string.
Declaration
public object DriverVersion { get; set; }Property Value
|
System.Object
|
EncryptedCredential
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string).
Declaration
public object EncryptedCredential { get; set; }Property Value
|
System.Object
|
GuidFormat
Determines which column type (if any) should be read as a GUID. Type: string. None: No column types are automatically read as a Guid; Char36: All CHAR(36) columns are read/written as a Guid using lowercase hex with hyphens, which matches UUID.
Declaration
public object GuidFormat { get; set; }Property Value
|
System.Object
|
Password
The Azure key vault secret reference of password in connection string.
Declaration
public Azure.Analytics.Synapse.Artifacts.Models.AzureKeyVaultSecretReference Password { get; set; }Property Value
|
AzureKeyVaultSecretReference
|
Port
The port for the connection. Type: integer.
Declaration
public object Port { get; set; }Property Value
|
System.Object
|
Server
Server name for connection. Type: string.
Declaration
public object Server { get; set; }Property Value
|
System.Object
|
SslCert
The path to the client’s SSL certificate file in PEM format. SslKey must also be specified. Type: string.
Declaration
public object SslCert { get; set; }Property Value
|
System.Object
|
SslKey
The path to the client’s SSL private key in PEM format. SslCert must also be specified. Type: string.
Declaration
public object SslKey { get; set; }Property Value
|
System.Object
|
SslMode
SSL mode for connection. Type: integer. 0: disable, 1: prefer, 2: require, 3: verify-ca, 4: verify-full.
Declaration
public object SslMode { get; set; }Property Value
|
System.Object
|
TreatTinyAsBoolean
When set to true, TINYINT(1) values are returned as booleans. Type: bool.
Declaration
public object TreatTinyAsBoolean { get; set; }Property Value
|
System.Object
|
Username
Username for authentication. Type: string.
Declaration
public object Username { get; set; }Property Value
|
System.Object
|
UseSystemTrustStore
Use system trust store for connection. Type: integer. 0: enable, 1: disable.
Declaration
public object UseSystemTrustStore { get; set; }Property Value
|
System.Object
|