Search

Current Release

Version 26.1.9516

Current Release

Version 26.1.9516

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 Deleted.
  • Added support for Delete as a Reverse ETL transfer mode.
  • Added a warning banner to alert users approaching any monthly row limit. A warning email is also sent daily to ensure visibility.
  • Added support for 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 applies to all job types.
  • Added a new Jop Option IncludeBeforeUpdate. This option will replicate the before update value as part of HistoryModeAppendOnly.
  • Added a new Job Option IgnoreMissingColumns. When AlterSchema is set to false and IgnoreMissingColumns is set to true, Sync will not throw an error if the destination does not include a source column.
  • Enabled HardDelete as an option for DB2 for i destination.
  • Added support for cloning Enhanced CDC jobs.
  • Added support for specifying custom Primary Key columns in CDC jobs.

Changed

  • Updated 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 have been updated to Change Data Capture.
    • Removed the option to create an Enhanced Change Data Capture job. All sources that previously supported the Enhanced Change Data Capture job type no, Sync will track if the CDC Engine is required.
    • Removed support for creating a Change Data Capture for sources that support the CDC Engine. This effects the below sources:
  • Existing Change Data Capture jobs will 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. Defaults to false.
    • Hid the SkipFormulaFields connection property in Salesforce.
    • Improved the performance of listing tables in the salesforce_formulas schema.
  • Updated Reverse ETL jobs with SalesforcePardot destinations to use BulkMode=BulkWaitForResults by default.
  • Updated the column sizes for the macaddr and macaddr8 Postgres types to avoid a truncation issues.
  • Updated the automatic retry logic to close and open both source and destination connections before re-running 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 to automatically reset when an OUT_OF_RANGE error is detected. This will trigger a full snapshot for all tasks on the next job run.

Fixed

  • Improved 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.
  • Fixed an issue where Archive was set as the default Log Clean-up type in the Advanced Settings page. The default 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 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 IsActive=false when creating a new Task was ignored.
  • Fixed an issue where preview queries in tasks did no generate logs even is 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.