Search

Current Release

Version 26.1.9594

Current Release

Version 26.1.9594

Key Features

Added

  • Added Pipelines.
  • Added REST API v2.
  • Added the Apache Iceberg file format for the following destinations:
  • Added support for capturing deletes in reverse ETL jobs using Upsert mode.
    • Exposed Deletion Behavior in Advanced Job Options for reverse ETL Upsert jobs.
    • The default behavior is Skip Delete.
  • Added support for Delete as a reverse ETL transfer mode.
  • Added a warning banner to alert users that are approaching any monthly row limit. A warning email is also sent daily to ensure visibility.
  • Added support for change data capture (CDC) in SAP HANA.
  • Added the HASHBYTES function to the transformation library. Users can add the transformation to all job types.
  • Added the ability to apply a transformation to the primary key. This feature applies to all job types.
  • Added the new job option IncludeBeforeUpdate. This option replicates the before-update value as part of HistoryModeAppendOnly.
  • Added the new job option IgnoreMissingColumns. When AlterSchema is set to false and IgnoreMissingColumns is set to true, Sync does not generate an error if the destination does not include a source column.
  • Enabled the HardDeleteoption for the DB2 for i destination.
  • Added support for cloning enhanced CDC jobs.
  • Added support for specifying custom primary key columns in CDC jobs.

Changed

  • Updated the embedded Jetty server to 12.0.29.
  • Updated Sync to support v25 CData drivers.
  • Combined the Change Data Capture and Enhanced Change Data Capture job types under the Change Data Capture job type.
    • All existing Enhanced Change Data Capture jobs were updated to Change Data Capture.
    • Removed the option to create an Enhanced Change Data Capture job. For all sources that previously supported the Enhanced Change Data Capture job type, Sync determines whether the CDC Engine is required.
    • Removed support for creating a Change Data Capture job for sources that support the CDC Engine. This affects the following sources:
  • Existing Change Data Capture jobs continue to work as usual.
  • Removed limits on the maximum number of roles that can be assigned to a user.
  • Increased the default Java Heap Space allocation for Sync to 60% of available memory.
  • Updated Formula fields for Salesforce:
    • Exposed the SkipFormulaFields job option for all jobs with Salesforce source. The default value is false.
    • Hid the SkipFormulaFields connection property in Salesforce.
    • Improved the performance of listing tables in the salesforce_formulas schema.
  • Updated reverse ETL jobs with Salesforce Pardot destinations to use BulkMode=BulkWaitForResults by default.
  • Updated the column sizes for the macaddr and macaddr8 Postgres types to avoid truncation issues.
  • Updated the automatic retry logic to close and open both source and destination connections before rerunning queries.
  • Updated the NetSuite SuiteAnalytics connector to support more logging.
  • Updated the Port field to be optional for SQL Server destinations, allowing for dynamic port discovery.
  • Updated the CDC Engine so that it resets automatically when an OUT_OF_RANGE error is detected. This behavior triggers a full snapshot for all tasks on the next job run.

Fixed

  • Improved the UI for reverse ETL jobs. Column mapping now identifies columns and static values in source tables.
  • Fixed an issue where the ScheduledCron parameter could not be updated through the Sync API even when isScheduled=false is set.
  • Fixed an issue where Archive was set as the default log clean-up type on the Advanced Settings page. The default type is Delete.
  • Fixed an issue where updating a connector did not properly log the connector name in the Audit logs.
  • Fixed an issue where sorting scheduled jobs by the Next Run Time column did not work.
  • Fixed an issue where DELETE HTTP requests did not always have the correct error responses.
  • Fixed an issue in the Sync API where setting the option IsActive=false was ignored when you create a new task.
  • Fixed an issue where preview queries in tasks did not generate logs even when logging was configured on the connection.
  • Fixed an issue where Enhanced Change Data Capture jobs would continue to display increasing runtime in the Sync UI, even when the CDC Engine was not running.