Key Features

• Added support for Clustering multiple instances of CData Sync.
• Added a new Incremental Replication strategy for SQL Server that uses Change Data Capture.

CData Sync Application

Added

• Added support for running CData Sync using JDK 16.
• Added the option to copy events when you create a job from an existing job.
• Table Name Prefix now supports slash / characters.
• Added support for SQL Server, MySQL, and PostgreSQL databases as AppDb.

Changed

• Improved the Cancel Job operation and added support for canceling jobs running on different instances.
• Improved replication with an integer/long Incremental Check Column:
  • The Replicate Interval Unit option now supports rows as a value.
  • Sync finds the start value if Replicate Start Date is empty.
• UI notifications now pin to the top of the page. This behavior helps prevent users from missing notifications when they scroll down.
• Application logs now include JVM Args on start up.
• Sync now checks for the 2017 VC++ Redistributable during Microsoft Windows installation.
• Changed the application settings Expired Days label to Retention Period (Days).

Source and Destination Connectors

Added

• Added SingleStore as a destination.
• Added support for AzureAD and AzureServicePrincipal AuthSchemes for some Microsoft sources.

Changed

• Renamed the OracleOCI connector to Oracle.
• SAP SuccessFactor now properly shows the Incremental Check Column in Task Settings.

CData Sync API

Added

• Added a new Tasks endpoint to manipulate tasks in a job more easily. The ability to update queries/tasks from jobs has been deprecated.
• Added the Transformations endpoint for CRUD support and transformations.

Changed

• Transformations now support the ability to add queries when the transformation is first created.
• The Sync API now generates a proper error message when the authtoken is incorrect.