Support for open Delta tables, AS400/iSeries CDC, and Salesforce formula-only replication highlight a release built for both modern lakehouses and mission-critical legacy systems.
Analytics teams often struggle with data files that are slow to query, fragile when schemas evolve, or inconsistent when multiple tools try to access them. The result is broken dashboards, unreliable reports, and time lost reshaping data just to make it usable.
CData Sync’s Q3 release addresses this challenge with native support for open Delta Lake tables across key cloud storage destinations, including Amazon S3, Azure Blob Storage, Google Cloud Storage, and Azure Data Lake Storage. This update also extends to our Open Mirroring destination, offering broader flexibility for customers adopting Microsoft Fabric OneLake.
Open Delta tables bring the ACID reliability of a database to the flexibility of an open file format. Every write is transactional, with no partial loads or corrupted files. Schema changes are enforced and managed at the table level, keeping downstream analytics consistent as source systems evolve. Because Delta is an open standard, data written by Sync can be queried immediately by engines and BI tools ranging from Databricks and Fabric to Spark, Trino, and Power BI.
With this release, Sync provides customers with a reliable foundation for lakehouse architectures. Beyond query engines, Delta support enables consistent pipelines for Spark-based ML, federated query frameworks, downstream BI platforms, and AI training workflows that depend on clean, versioned data.
CDC improvements for critical systems
Enterprises still running core processes on legacy databases often must choose between batch extracts that lag by hours and heavyweight integration tools that are costly to deploy and maintain.
CData Sync’s Q3 release continues to close those gaps with the addition of IBM DB2 AS400/iSeries as a new Change Data Capture (CDC) source, giving enterprises near real-time replication from mission-critical legacy systems into modern platforms.
With new support for both IBM DB2 AS400/iSeries and MySQL, Sync strengthens its role as a single platform that spans legacy and mainstream databases, helping customers unify pipelines without relying on separate, heavyweight tools.
This release also builds on earlier support for DB2 LUW, introduced earlier this year, showing Sync’s continued investment in the DB2 family. Enhanced CDC for MySQL adds faster and more reliable incremental replication from one of the most widely used open-source databases.
And with new hard delete tracking across all CDC sources, downstream systems can now reflect the true source-of-record state without manual cleanup.
Reverse ETL expansion
This release marks an important step forward for Reverse ETL in Sync with the addition of Sage Intacct as our first ERP destination.
By extending Reverse ETL beyond CRM and marketing into ERP, Sync enables finance teams to act on trusted warehouse data directly within their core accounting system — a new direction that broadens the impact of operationalized data.
We’ve also added Veeva Vault CRM, expanding into life sciences and giving pharmaceutical and biotech organizations a direct path to push analytics-ready data back into the systems they rely on for regulated content and customer engagement.
On the marketing front, Sync now supports Pardot and Salesforce Marketing Cloud, joining existing connectors like HubSpot to give marketing teams more choice in how they activate data from the warehouse.
Here’s Sync's full Reverse ETL library:
Sources | Destinations |
Snowflake | Salesforce |
SQL Server | Dynamics365 |
Redshift | HubSpot |
PostgreSQL | Zoho CRM |
Oracle | Kintone |
BigQuery | Pardot |
| Sage Intacct |
| Salesforce Marketing Cloud |
| Veeva Vault CRM |
Dedicated Salesforce formulas schema
Salesforce objects are notoriously bloated, with thousands of columns most teams never touch. What analysts really need are the formula and roll-up fields — the KPIs and business logic defined in Salesforce itself.
Sync now provides a dedicated Salesforce_Formulas schema that replicates only calculated fields plus the primary key.
This keeps incremental jobs lean and fast while refreshing formulas on their own cadence. New formulas created in Salesforce automatically appear downstream, with no manual remapping.
The result is a cleaner warehouse schema that captures the intelligence of Salesforce without the noise, giving customers control over how Salesforce data lands and ensuring downstream analytics reflect business logic rather than raw system bloat.
To access the newly released features, download the latest version of Sync. For the full list of updates and technical details, see the release notes.
