Configuration: ETL Options

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.
• If value is not set, or set to null, the number of extracted documents fallbacks to ETL.MaxNumberOfExtractedItems value.

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

• 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.
• If value is not set, or set to null, the size of the batch isn't limited in the processed ETL batch.

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

• 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

• Max number of extracted items (documents, counters, etc) in an ETL batch.
• If value is not set, or set to null, the number of extracted items isn't limited in the processed ETL batch.

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

Max number of extracted documents in OLAP ETL batch.

• Type: int
• Default: 64 * 1024
• Scope: Server-wide or per database

Lifespan of a message in the queue.

• Type: int
• Default: 604800 (7 days)
• Scope: Server-wide or per database

How long a message is hidden after being retrieved but not deleted.

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

Timeout to initialize transactions for the Kafka producer.

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

Number of seconds after which the SQL command will timeout.

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