July 2023

Version 24.2.8969


July 2023

Version 24.2.8969


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