OracleSource interface

Package:

@azure/synapse-artifacts

A copy activity Oracle source.

Extends

CopySource

Properties

additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).
numberPrecision	The decimal precision used to represent Oracle NUMBER type without precision and scale. The range is 1 to 256 and default value is 256 if not specified. Type: integer (or Expression with resultType integer). Only used for Version 2.0.
numberScale	The decimal scale used to represent Oracle NUMBER type without precision and scale. The range is 0 to 130 and default value is 130 if not specified. Type: integer (or Expression with resultType integer). Only used for Version 2.0.
oracleReaderQuery	Oracle reader query. Type: string (or Expression with resultType string).
partitionOption	The partition mechanism that will be used for Oracle read in parallel.
partitionSettings	The settings that will be leveraged for Oracle source partitioning.
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])).
type	Polymorphic discriminator, which specifies the different types this object can be

Inherited Properties

maxConcurrentConnections	The maximum concurrent connection count for the source data store. Type: integer (or Expression with resultType integer).
sourceRetryCount	Source retry count. Type: integer (or Expression with resultType integer).
sourceRetryWait	Source retry wait. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])).

Property Details

additionalColumns

Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).

additionalColumns?: any

Property Value

any

numberPrecision

The decimal precision used to represent Oracle NUMBER type without precision and scale. The range is 1 to 256 and default value is 256 if not specified. Type: integer (or Expression with resultType integer). Only used for Version 2.0.

numberPrecision?: any

Property Value

any

numberScale

The decimal scale used to represent Oracle NUMBER type without precision and scale. The range is 0 to 130 and default value is 130 if not specified. Type: integer (or Expression with resultType integer). Only used for Version 2.0.

numberScale?: any

Property Value

any

oracleReaderQuery

Oracle reader query. Type: string (or Expression with resultType string).

oracleReaderQuery?: any

Property Value

any

partitionOption

The partition mechanism that will be used for Oracle read in parallel.

partitionOption?: string

Property Value

string

partitionSettings

The settings that will be leveraged for Oracle source partitioning.

partitionSettings?: OraclePartitionSettings

Property Value

OraclePartitionSettings

queryTimeout

Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])).

queryTimeout?: any

Property Value

any

type

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

type: "OracleSource"

Property Value

"OracleSource"

Inherited Property Details

maxConcurrentConnections

The maximum concurrent connection count for the source data store. Type: integer (or Expression with resultType integer).

maxConcurrentConnections?: any

Property Value

any

Inherited From CopySource.maxConcurrentConnections

sourceRetryCount

Source retry count. Type: integer (or Expression with resultType integer).

sourceRetryCount?: any

Property Value

any

Inherited From CopySource.sourceRetryCount

sourceRetryWait

Source retry wait. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])).

sourceRetryWait?: any

Property Value

any

Inherited From CopySource.sourceRetryWait