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.
• 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.