Key Features

Added

• Added the Enhanced CDC job type for the PostgreSQL and Oracle sources. This new job type uses the CData CDC engine to track and stream changes from the source database. For more details, see Enhanced CDC Jobs in CData Sync
• Added the Associated Jobs and Transformation widget to connections. Now, users can see which jobs and transformations depend on the connection.
• Added the Metadata Caching widget to control how long Sync maintains the in-memory metadata cache for a connection before refreshing it.
• Added a Comments tab to the Connections, Jobs, and Transformations pages.
• Added new sources:
  • Azure Blob Storage
  • CData Connect Cloud
  • Microsoft OneLake
  • SAP Ariba Procurement
  • SAP Ariba Source
• Added new destinations:
  • Couchbase
  • Microsoft OneLake
• Sync now monitors the disk usage where the application directory is located. When disk usage exceeds 95%, Sync pauses the scheduler until more space becomes available. Added the suspenddiskusagethreshold application setting to increase or decrease the threshold.
• Added more options for filtering the Application, Access, and Audit logs.
• Added an Auto Map option for when Sync builds the column mapping for reverse ETL jobs.
• Added the Reset Strategy option for reverse ETL jobs. This option controls how Sync reacts to primary key changes on the source table.
• Added support for replicating a table without a primary key to a table with a primary key (identity column).
• Added support for headless OAuth in Sync. Users can add the OAuthVerifier property to the connection to retrieve the access tokens.

Changed

• Updated Sync to support v24 CData drivers.
• Improved error messaging that occurs when an invalid logs folder is used.
• Updated Google BigQuery so that the default InsertMode value is now Upload.
• Updated the names of Oracle and PostgreSQL to include (Native) to distinguish them from the CData Oracle and PostgreSQL connectors.
• Updated the logs folder to include dated subdirectories.
• Updated the job and transformation history tables to include the instance identifier (Id).
• Improved the error messaging that occurs when Sync cannot load a driver.
• Updated the after-job notification to include the task runtime.
• Updated the installation method for Apache Kafka to include required dependencies.
• Updated the execute-job log message to include the final status of the job (either success or failure) .

Fixed

• Fixed an issue where Sync incorrectly logged that a job was cancelled by another instance.
• Fixed an issue where the API connector did not allow multiple filters on the same column.
• Fixed an issue where MySQL and MariaDB did not include the schema in the Add Tasks dialog box..
• Fixed the sorting on the Connections page.
• Fixed an issue with executing MERGE statements as a transformation.
• Fixed an issue where jobs were not editable when parallel processing was enabled and a Standard license was used.
• Fixed an issue where the test-connection step during job execution was not logged.
• Fixed an issue where Sync would not add multiple CHECKCACHE queries at once.
• Fixed an issue where the Upcoming Job Runs widget did not update the next scheduled jobs properly.
• Fixed an issue where the system locale prevented jobs from running at the correct scheduled time.
• Fixed an issue where the preview tab did not display some exceptions.
• Fixed an issue in Sync Cloud where drivers were not installed in all instances.
• Fixed an issue where environment variables were not included when job executions were retried.
• Fixed an issue that occurred when binary keys were used in change data capture (CDC) jobs.
• Fixed an issue where the row count for transformations counted against the license row limit.
• Fixed an issue where the replicate logs did not always show a warning when a string column might need to be truncated.