Class 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.

Inheritance
System.Object
LinkedService
OracleLinkedService
Inherited Members
Namespace: System.Dynamic.ExpandoObject
Assembly: Azure.Analytics.Synapse.Artifacts.dll
Syntax
[System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.OracleLinkedService/OracleLinkedServiceConverter))]
public class OracleLinkedService : Azure.Analytics.Synapse.Artifacts.Models.LinkedService

Constructors

OracleLinkedService(Object)

Initializes a new instance of OracleLinkedService.

Declaration
public OracleLinkedService (object connectionString);
Parameters
System.Object connectionString

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

connectionString is null.

Properties

AuthenticationType

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

Declaration
public Nullable<Azure.Analytics.Synapse.Artifacts.Models.OracleAuthenticationType> AuthenticationType { get; set; }
Property Value
System.Nullable<OracleAuthenticationType>

ConnectionString

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

Declaration
public object ConnectionString { get; set; }
Property Value
System.Object

CryptoChecksumClient

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.

Declaration
public object CryptoChecksumClient { get; set; }
Property Value
System.Object

CryptoChecksumTypesClient

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.

Declaration
public object CryptoChecksumTypesClient { get; set; }
Property Value
System.Object

EnableBulkLoad

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.

Declaration
public object EnableBulkLoad { 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

EncryptionClient

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.

Declaration
public object EncryptionClient { get; set; }
Property Value
System.Object

EncryptionTypesClient

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.

Declaration
public object EncryptionTypesClient { get; set; }
Property Value
System.Object

FetchSize

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.

Declaration
public object FetchSize { get; set; }
Property Value
System.Object

FetchTswtzAsTimestamp

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.

Declaration
public object FetchTswtzAsTimestamp { get; set; }
Property Value
System.Object

InitializationString

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

Declaration
public object InitializationString { get; set; }
Property Value
System.Object

InitialLobFetchSize

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

Declaration
public object InitialLobFetchSize { 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

Server

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.

Declaration
public object Server { get; set; }
Property Value
System.Object

StatementCacheSize

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.

Declaration
public object StatementCacheSize { get; set; }
Property Value
System.Object

SupportV1DataTypes

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.

Declaration
public object SupportV1DataTypes { get; set; }
Property Value
System.Object

Username

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

Declaration
public object Username { get; set; }
Property Value
System.Object