Sync mechanisms

Supported SQL Server data synchronization mechanisms¶

The SQL Server Database connector plugin for Sidra supports different modes of data synchronization, which also depend on the mechanisms configured on the source system or Sidra:

• Full load data synchronization.

• Incremental load data synchronization. . For incremental load to work, there must be a defined mechanism to capture updates in the source system. For incremental load data synchronization, two possible types of mechanisms are supported:

  • Incremental Load with built-in SQL Server Change Tracking (CT). This is achieved by directly activating Change Tracking in the source database.

  • Incremental Load non-Change Tracking related (non-CT). This is achieved by specific configurations in the Sidra Metadata tables and includes a Non-Change Tracking custom mechanism enabled by Sidra option.