UseIncrementalStatements

The UseIncrementalStatements parameter specifies whether to run queries that identify new/updated and deleted records.

  • When UseIncrementalStatements=False, the connector performs a full synchronize every time the task runs, using the query specified by the SQL parameter.
  • When UseIncrementalStatements=True, the connector only performs a full synchronize the first time the synchronize task runs:

Using incremental mode can be more efficient if the database has items stored by modified date, because the connector doesn't need to rescan the entire database.

Type: Boolean
Default: False
Required: No
Configuration Section: TaskName or FetchTasks
Example: UseIncrementalStatements=True
See Also:

InitialStatement

AddedAndUpdatedStatement

DeletedStatement