Package version:

Interface OracleLinkedService

Oracle database. This linked service has supported version property. The Version 1.0 is scheduled for deprecation while your pipeline will continue to run after EOL but without any bug fix or new features.

interface OracleLinkedService {
    annotations?: any[];
    authenticationType?: string;
    connectionString?: any;
    connectVia?: IntegrationRuntimeReference;
    cryptoChecksumClient?: any;
    cryptoChecksumTypesClient?: any;
    description?: string;
    enableBulkLoad?: any;
    encryptedCredential?: string;
    encryptionClient?: any;
    encryptionTypesClient?: any;
    fetchSize?: any;
    fetchTswtzAsTimestamp?: any;
    initializationString?: any;
    initialLobFetchSize?: any;
    parameters?: {
        [propertyName: string]: ParameterSpecification;
    };
    password?: AzureKeyVaultSecretReference;
    server?: any;
    statementCacheSize?: any;
    supportV1DataTypes?: any;
    type: "Oracle";
    username?: any;
    version?: string;
}

Hierarchy (view full)

Properties

annotations? authenticationType? connectionString? connectVia? cryptoChecksumClient? cryptoChecksumTypesClient? description? enableBulkLoad? encryptedCredential? encryptionClient? encryptionTypesClient? fetchSize? fetchTswtzAsTimestamp? initializationString? initialLobFetchSize? parameters? password? server? statementCacheSize? supportV1DataTypes? type username? version?

Properties

Optionalannotations

annotations?: any[]

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

OptionalauthenticationType

authenticationType?: string

Authentication type for connecting to the Oracle database. Only used for Version 2.0.

OptionalconnectionString

connectionString?: any

The connection string. Type: string, SecureString or AzureKeyVaultSecretReference. Only used for Version 1.0.

OptionalconnectVia

connectVia?: IntegrationRuntimeReference

The integration runtime reference.

OptionalcryptoChecksumClient

cryptoChecksumClient?: any

Specifies the desired data integrity behavior when this client connects to a server. Supported values are accepted, rejected, requested or required, default value is required. Type: string. Only used for Version 2.0.

OptionalcryptoChecksumTypesClient

cryptoChecksumTypesClient?: any

Specifies the crypto-checksum algorithms that client can use. Supported values are SHA1, SHA256, SHA384, SHA512, default value is (SHA512). Type: string. Only used for Version 2.0.

Optionaldescription

description?: string

Linked service description.

OptionalenableBulkLoad

enableBulkLoad?: any

Specifies whether to use bulk copy or batch insert when loading data into the database, default value is true. Type: boolean. Only used for Version 2.0.

OptionalencryptedCredential

encryptedCredential?: string

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

OptionalencryptionClient

encryptionClient?: any

Specifies the encryption client behavior. Supported values are accepted, rejected, requested or required, default value is required. Type: string. Only used for Version 2.0.

OptionalencryptionTypesClient

encryptionTypesClient?: any

Specifies the encryption algorithms that client can use. Supported values are AES128, AES192, AES256, 3DES112, 3DES168, default value is (AES256). Type: string. Only used for Version 2.0.

OptionalfetchSize

fetchSize?: any

Specifies the number of bytes that the driver allocates to fetch the data in one database round-trip, default value is 10485760. Type: integer. Only used for Version 2.0.

OptionalfetchTswtzAsTimestamp

fetchTswtzAsTimestamp?: any

Specifies whether the driver returns column value with the TIMESTAMP WITH TIME ZONE data type as DateTime or string. This setting is ignored if supportV1DataTypes is not true, default value is true. Type: boolean. Only used for Version 2.0.

OptionalinitializationString

initializationString?: any

Specifies a command that is issued immediately after connecting to the database to manage session settings. Type: string. Only used for Version 2.0.

OptionalinitialLobFetchSize

initialLobFetchSize?: any

Specifies the amount that the source initially fetches for LOB columns, default value is 0. Type: integer. Only used for Version 2.0.

Optionalparameters

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

Parameters for linked service.

Optionalpassword

password?: AzureKeyVaultSecretReference

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

Optionalserver

server?: any

The location of Oracle database you want to connect to, the supported forms include connector descriptor, Easy Connect (Plus) Naming and Oracle Net Services Name (Only self-hosted IR). Type: string. Only used for Version 2.0.

OptionalstatementCacheSize

statementCacheSize?: any

Specifies the number of cursors or statements to be cached for each database connection, default value is 0. Type: integer. Only used for Version 2.0.

OptionalsupportV1DataTypes

supportV1DataTypes?: any

Specifies whether to use the Version 1.0 data type mappings. Do not set this to true unless you want to keep backward compatibility with Version 1.0's data type mappings, default value is false. Type: boolean. Only used for Version 2.0.

type

type

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

Optionalusername

username?: any

The Oracle database username. Type: string. Only used for Version 2.0.

Optionalversion

version?: string

Version of the linked service.

Settings

Member Visibility