Configuration: ETL Options

Number of seconds after which the SQL command will timeout.

• Type: int
• Default: null (use provider default)
• Scope: Server-wide or per database

Number of seconds after which extraction and transformation will end and loading will start.

• Type: int
• Default: 30
• Scope: Server-wide or per database

Max number of extracted documents in an ETL batch.

• Type: int
• Default: 8192
• Scope: Server-wide or per database

If value is not set, or set to null, the number of extracted documents fallbacks to ETL.MaxNumberOfExtractedItems value.

Max number of extracted items (documents, counters, etc) in an ETL batch.

• Type: int
• Default: 8192
• Scope: Server-wide or per database

If value is not set, or set to null, the number of extracted items isn't limited in the processed ETL batch.

Maximum size in megabytes of a batch of data (documents and attachments) that will be sent to the destination as a single batch after transformation.

• Type: Size
• Size Unit: Megabytes
• Default: 64
• Scope: Server-wide or per database

If value is not set, or set to null, the size of the batch isn't limited in the processed ETL batch.

Maximum number of seconds the ETL process will be in a fallback mode after a load connection failure to a destination. The fallback mode means suspending the process.

• Type: int
• Default: 900
• Scope: Server-wide or per database