> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sync.cdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# January 2026 (26.1.9516)

> Release notes for CData Sync January 2026 (build 26.1.9516).

## Key Features

### Added

* Added [Pipelines](../../getting-started/administration/pipelines-page).
* Added [REST API v2](../../rest-api/rest-api).
* Added the Apache Iceberg file format for the following destinations:
  * [Amazon S3](../../connections/destinations/amazon-s3-destination)
  * [Azure Blob Storage](../../connections/destinations/azure-blob-storage-destination)
  * [Azure Data Lake Storage](../../connections/destinations/azure-data-lake-storage-destination)
  * [Google Cloud Storage](../../connections/destinations/google-cloud-storage-destination)
* Added support for capturing deletes in reverse ETL jobs using Upsert mode.
  * Exposed the **Deletion Behavior** option (in the **Replicate Options** category on the **Advanced** job tab) for reverse ETL Upsert jobs .
  * The default behavior is **Skip Delete**.
* Added support for the **Delete** option 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](../../connections/sources/sap-hana-source).
* 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 `HistoryMmodeIncludeBeforeUpdate`. This option replicates the before-update value as part of the `HistoryModeAppendOnly` option.
* 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 **HardDelete** option 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 change affects the following sources:
    * [MySQL](../../connections/sources/mysql-source)
    * [Oracle](../../connections/sources/oracle-source)
    * [PostgreSQL](../../connections/sources/postgresql-source)
  * 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 the `BulkMode=BulkWaitForResults` option by default.
* Updated the column sizes for the `macaddr` and `macaddr8` PostgreSQL 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.