see on GitHub

Configuration : ETL Options

ETL.SQL.CommandTimeoutInSec

Number of seconds after which the SQL command will timeout.

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

ETL.ExtractAndTransformTimeoutInSec

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

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

ETL.MaxNumberOfExtractedDocuments

Max number of extracted documents in an ETL batch.

  • Type: int
  • Default: null
  • 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.

ETL.MaxNumberOfExtractedItems

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

  • Type: int
  • Default: null
  • 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.

ETL.MaxFallbackTimeInSec

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