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 is infinite per 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