Package version:

Interface MySqlLinkedService

Linked service for MySQL data source.

interface MySqlLinkedService {
    allowZeroDateTime?: any;
    annotations?: any[];
    connectionString?: any;
    connectionTimeout?: any;
    connectVia?: IntegrationRuntimeReference;
    convertZeroDateTime?: any;
    database?: any;
    description?: string;
    driverVersion?: any;
    encryptedCredential?: string;
    guidFormat?: any;
    parameters?: {
        [propertyName: string]: ParameterSpecification;
    };
    password?: AzureKeyVaultSecretReference;
    port?: any;
    server?: any;
    sslCert?: any;
    sslKey?: any;
    sslMode?: any;
    treatTinyAsBoolean?: any;
    type: "MySql";
    username?: any;
    useSystemTrustStore?: any;
    version?: string;
}

Hierarchy (view full)

Properties

allowZeroDateTime? annotations? connectionString? connectionTimeout? connectVia? convertZeroDateTime? database? description? driverVersion? encryptedCredential? guidFormat? parameters? password? port? server? sslCert? sslKey? sslMode? treatTinyAsBoolean? type username? useSystemTrustStore? version?

Properties

OptionalallowZeroDateTime

allowZeroDateTime?: any

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

Optionalannotations

annotations?: any[]

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

OptionalconnectionString

connectionString?: any

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

OptionalconnectionTimeout

connectionTimeout?: any

The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error. Type: integer.

OptionalconnectVia

connectVia?: IntegrationRuntimeReference

The integration runtime reference.

OptionalconvertZeroDateTime

convertZeroDateTime?: any

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

Optionaldatabase

database?: any

Database name for connection. Type: string.

Optionaldescription

description?: string

Linked service description.

OptionaldriverVersion

driverVersion?: any

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.

OptionalencryptedCredential

encryptedCredential?: string

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

OptionalguidFormat

guidFormat?: any

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.

Optionalparameters

parameters?: {
    [propertyName: string]: ParameterSpecification;
}

Parameters for linked service.

Optionalpassword

password?: AzureKeyVaultSecretReference

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

Optionalport

port?: any

The port for the connection. Type: integer.

Optionalserver

server?: any

Server name for connection. Type: string.

OptionalsslCert

sslCert?: any

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

OptionalsslKey

sslKey?: any

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

OptionalsslMode

sslMode?: any

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

OptionaltreatTinyAsBoolean

treatTinyAsBoolean?: any

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

type

type

Polymorphic discriminator, which specifies the different types this object can be

Optionalusername

username?: any

Username for authentication. Type: string.

OptionaluseSystemTrustStore

useSystemTrustStore?: any

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

Optionalversion

version?: string

Version of the linked service.

Settings

Member Visibility