Share via


MySqlLinkedService Class

Definition

Linked service for MySQL data source.

public class MySqlLinkedService : Azure.ResourceManager.DataFactory.Models.DataFactoryLinkedServiceProperties, System.ClientModel.Primitives.IJsonModel<Azure.ResourceManager.DataFactory.Models.MySqlLinkedService>, System.ClientModel.Primitives.IPersistableModel<Azure.ResourceManager.DataFactory.Models.MySqlLinkedService>
public class MySqlLinkedService : Azure.ResourceManager.DataFactory.Models.DataFactoryLinkedServiceProperties
type MySqlLinkedService = class
    inherit DataFactoryLinkedServiceProperties
    interface IJsonModel<MySqlLinkedService>
    interface IPersistableModel<MySqlLinkedService>
type MySqlLinkedService = class
    inherit DataFactoryLinkedServiceProperties
Public Class MySqlLinkedService
Inherits DataFactoryLinkedServiceProperties
Implements IJsonModel(Of MySqlLinkedService), IPersistableModel(Of MySqlLinkedService)
Public Class MySqlLinkedService
Inherits DataFactoryLinkedServiceProperties
Inheritance
Implements

Constructors

MySqlLinkedService()

Initializes a new instance of MySqlLinkedService.

Properties

AdditionalProperties

Additional Properties

To assign an object to the value of this property use FromObjectAsJson<T>(T, JsonSerializerOptions).

To assign an already formatted json string to this property use FromString(String).

Examples:

  • BinaryData.FromObjectAsJson("foo"): Creates a payload of "foo".
  • BinaryData.FromString("\"foo\""): Creates a payload of "foo".
  • BinaryData.FromObjectAsJson(new { key = "value" }): Creates a payload of { "key": "value" }.
  • BinaryData.FromString("{\"key\": \"value\"}"): Creates a payload of { "key": "value" }.

(Inherited from DataFactoryLinkedServiceProperties)
AllowZeroDateTime

This allows the special “zero” date value 0000-00-00 to be retrieved from the database. Type: boolean.

Annotations

List of tags that can be used for describing the linked service.

To assign an object to the element of this property use FromObjectAsJson<T>(T, JsonSerializerOptions).

To assign an already formatted json string to this property use FromString(String).

Examples:

  • BinaryData.FromObjectAsJson("foo"): Creates a payload of "foo".
  • BinaryData.FromString("\"foo\""): Creates a payload of "foo".
  • BinaryData.FromObjectAsJson(new { key = "value" }): Creates a payload of { "key": "value" }.
  • BinaryData.FromString("{\"key\": \"value\"}"): Creates a payload of { "key": "value" }.

(Inherited from DataFactoryLinkedServiceProperties)
ConnectionString

The connection string. Type: string, SecureString or AzureKeyVaultSecretReference.

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.

ConnectVia

The integration runtime reference.

(Inherited from DataFactoryLinkedServiceProperties)
ConvertZeroDateTime

True to return DateTime.MinValue for date or datetime columns that have disallowed values. Type: boolean.

Database

Database name for connection. Type: string.

Description

Linked service description.

(Inherited from DataFactoryLinkedServiceProperties)
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.

EncryptedCredential

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

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.

LinkedServiceVersion

Version of the linked service.

(Inherited from DataFactoryLinkedServiceProperties)
Parameters

Parameters for linked service.

(Inherited from DataFactoryLinkedServiceProperties)
Password

The Azure key vault secret reference of password in connection string.

Port

The port for the connection. Type: integer.

Server

Server name for connection. Type: string.

SslCert

The path to the client’s SSL certificate file in PEM format. SslKey must also be specified. Type: string.

SslKey

The path to the client’s SSL private key in PEM format. SslCert must also be specified. Type: string.

SslMode

SSL mode for connection. Type: integer. 0: disable, 1: prefer, 2: require, 3: verify-ca, 4: verify-full.

TreatTinyAsBoolean

When set to true, TINYINT(1) values are returned as booleans. Type: bool.

Username

Username for authentication. Type: string.

UseSystemTrustStore

Use system trust store for connection. Type: integer. 0: enable, 1: disable.

Methods

JsonModelWriteCore(Utf8JsonWriter, ModelReaderWriterOptions)
JsonModelWriteCore(Utf8JsonWriter, ModelReaderWriterOptions) (Inherited from DataFactoryLinkedServiceProperties)

Explicit Interface Implementations

IJsonModel<DataFactoryLinkedServiceProperties>.Create(Utf8JsonReader, ModelReaderWriterOptions)

Reads one JSON value (including objects or arrays) from the provided reader and converts it to a model.

(Inherited from DataFactoryLinkedServiceProperties)
IJsonModel<DataFactoryLinkedServiceProperties>.Write(Utf8JsonWriter, ModelReaderWriterOptions)

Writes the model to the provided Utf8JsonWriter.

(Inherited from DataFactoryLinkedServiceProperties)
IJsonModel<MySqlLinkedService>.Create(Utf8JsonReader, ModelReaderWriterOptions)

Reads one JSON value (including objects or arrays) from the provided reader and converts it to a model.

IJsonModel<MySqlLinkedService>.Write(Utf8JsonWriter, ModelReaderWriterOptions)

Writes the model to the provided Utf8JsonWriter.

IPersistableModel<DataFactoryLinkedServiceProperties>.Create(BinaryData, ModelReaderWriterOptions)

Converts the provided BinaryData into a model.

(Inherited from DataFactoryLinkedServiceProperties)
IPersistableModel<DataFactoryLinkedServiceProperties>.GetFormatFromOptions(ModelReaderWriterOptions)

Gets the data interchange format (JSON, Xml, etc) that the model uses when communicating with the service.

(Inherited from DataFactoryLinkedServiceProperties)
IPersistableModel<DataFactoryLinkedServiceProperties>.Write(ModelReaderWriterOptions)

Writes the model into a BinaryData.

(Inherited from DataFactoryLinkedServiceProperties)
IPersistableModel<MySqlLinkedService>.Create(BinaryData, ModelReaderWriterOptions)

Converts the provided BinaryData into a model.

IPersistableModel<MySqlLinkedService>.GetFormatFromOptions(ModelReaderWriterOptions)

Gets the data interchange format (JSON, Xml, etc) that the model uses when communicating with the service.

IPersistableModel<MySqlLinkedService>.Write(ModelReaderWriterOptions)

Writes the model into a BinaryData.

Applies to