CData Sync 26.2: Git Version Control, Performance boosts, ClickHouse destination & more…
We’re excited to share the 26.2 release of CData Sync, packed with new capabilities that give you more control, performance, and flexibility across your data pipelines. As always, a full list of updates is available in the latest release documentation.
Release Highlights:
🔀 Git-Based Version Control for Workspaces
CData Sync now ships with native Git integration for workspace configuration. Connect your workspace to GitHub, GitLab, Azure DevOps, or Bitbucket and manage every job, connection, and pipeline setting as a versioned artifact. Commit changes, pull updates from teammates, discard edits, and undo any historical commit, all from within the Sync UI with no command-line knowledge required. For teams in regulated environments, this also means a complete, timestamped audit trail of every configuration change.
📊 ClickHouse Destination
CData Sync now supports ClickHouse as a replication destination. ClickHouse is a columnar, open-source OLAP database built for high-speed analytical queries, ideal for real-time dashboards, observability pipelines, and event analytics. Replicate from any Sync source directly into ClickHouse Cloud or self-hosted, using full load, incremental, or Change Data Capture replication modes.
⚡ Performance Boosts
We’re introducing Parallel Partitioned Reads, a brand-new capability that splits large source tables into partitions read simultaneously across multiple threads. For high-volume workloads, think 100M+ row tables, this can reduce replication time by up to 5x. Supported sources include SQL Server, Oracle, PostgreSQL, DB2, DB2 i, Informix, MySQL, and MariaDB, with per-task configuration built directly into the job UI.
🐍 Python for Sync Events
You can now use Python to power Sync Events, alongside existing support for JavaScript and shell scripts. Run pre- and post-job logic in the language your team already uses, trigger downstream pipelines, validate source data quality, send notifications, or write enriched metrics to your observability stack.
🎨 Refreshed UI and Smarter Workflows
CData Sync has been updated with our new branding. Alongside the refresh, we’ve introduced a new Re-Sync Tasks action (choose re-sync period and write mode without touching job settings), smarter table search that hides empty schemas, and simplified proxy configuration that defaults new connections to your global Sync settings.
🗄 Application Database Migration Wizard
Ready to move from Derby/H2 to a production-grade database? A new guided UI wizard makes it simple to migrate to SQL Server, MySQL, or PostgreSQL with real-time progress, automatic rollback on failure, and step-by-step switchover instructions, all without touching a config file.
🔄 Change Data Capture Enhancements
Oracle CDC jobs can now replicate the ROWID column as a primary key substitute for tables with no defined primary key, and Oracle destination jobs now use temporary tables to eliminate redo log overhead during merge-based replication. For DB2 i, journal selection is enforced at job creation.
These enhancements continue our commitment to making CData Sync the most flexible and reliable platform for data replication and integration. The latest features are available in our newest builds, and existing customers can download the update and generate a new license key through the CData Portal.
As always, our global support team is ready to help if you have any questions or want guidance on getting started with any of these new features.
Thank you for your continued trust in CData Sync, we can’t wait for you to try what’s new! 🚀
The CData Sync Product Team
