Key Features

Added

• Added support for the Labels feature, a new way to tag and organize connections, jobs, and transformations.
• Added the Saved Filters feature to the Jobs, Connections, and Transformation pages. After you set multiple filters, you can save and quickly reference them at a later time.
• Enhanced in-flight (ETL) transformations with a library of SQL functions.
• Enhanced filtering on the Jobs, Connections and Transformation pages.
• Added the ability to clone a connection to help you quickly create multiple connections that share connection properties.
• Added the Job Creator role.
• The Sync API now supports the creation of users.
  • Create a single user.
  • Create multiple users.
• Added extra validation for certain inputs (for example, a Cron statement or an IP address).
• Added a new Health-Check endpoint (/src/ping.rst) to validate that the Sync instance is running.

Changed

• Enhanced history mode with Change Data Capture (CDC) jobs. The destination table now includes the _cdatasync_operation and _cdatasync_version columns.
• Added support for regional settings for datetime values in the UI.
• Deleting a task from a Change Data Capture job clears the saved status.
• Info logging now includes the column metadata in the replication log (previously required Verbose logging).
• The Operator role is renamed to Job Operator.

Fixed

• Fixed an issue where the SSO tab would reload after a successful connection.
• Fixed an issue where the access logs were double-logging the requests.
• Fixed an issue where the Status Connection drop-down list did not show the connection name.
• Fixed an issue where the run details did not properly show all log files that are generated.
• Fixed an issue where the Source tab showed two different Oracle options.
• Fixed an issue where the UI showed the wrong scheduled time when the Job schedule is set to Daily.
• Fixed an issue where the UI showed the wrong runtime when the job execution took longer than one hour.
• Fixed an issue with multiple links that were not generating when you use baseurl and run Sync with a proxy.
• Fixed an issue where saving advanced settings for transformations sometimes reverted the schedule.
• Fixed an issue where the run details for a Load Folder job did not include the status of each file.
• Fixed an issue where jobs with hyphens did not show in the job history.
• Fixed an issue where Username and Password properties were marked required when you set up your SMTP server.

Connectors

Added

• Sync now includes the CData 2023 drivers.
• The Google BigQuery destination supports the MERGE SQL statement based on the source primary keys. This feature requires InsertMode=Upload in your BigQuery connection and MergeWithSourceKey=true in Advanced Job Options.
• The Kafka destination now supports history mode.
• The Azure Data Lake Store destination connector can now be used as a source.
• The DB2 source driver changed to the native IBM driver.
• Support was added for the UUID data type in PostgreSQL.

Fixed

• Fixed an issue where Postgres CDC did not consume WAL logs properly.
• Fixed an invalid query that occurred when you connect to Oracle 11g (and earlier versions) and you use Oracle CDC.
• Fixed an issue in the SQL Server destination where the milliseconds were not included in datetime values.
• Fixed an issue where the IMAGE type in SQL Server did not map properly VARBINARY data type.
• Fixed an issue where disconnecting from QuickBooks Online did not remove the Sync application properly from the QBO company.