CDC Support in the MS SQL Data Source

The data source for Microsoft SQL now supports the CDC (Change Data Capture) mode of incremental fetching.

CDC Support in the MS SQL Data Source

We are pleased to present a new feature of our Microsoft SQL data source that enables you to leverage the CDC (Change Data Capture) tables to perform incremental syncs.

This mode of incremental fetching is available only for tables for which the CDC is enabled in your server. See the official documentation for more information on the setup on the server side.

The biggest advantage of this approach is that it can quickly capture all changes, including deletes.

For more information about this feature, please refer to our documentation.