CData Sync
Change Data Capture for near real‑time replication
Stream inserts, updates, and deletes directly from source logs into your downstream systems. Sync delivers reliable, low-latency Change Data Capture with predictable, scalable pricing, without elevated admin rights or rigid normalization.
What CDC Does
Sync uses log-based CDC to identify inserts, updates, and deletes without scanning tables. Changes are delivered continuously to your downstream systems, so analytics, operations, and AI workloads always reflect current activity.
Log-based capture
Reads write-ahead logs (WAL), redo logs, binary logs, or native change-tracking features to identify row-level changes without running queries against tables.
Near real-time replication
Maintains the current log position and applies changes as they occur to continuously refresh downstream data.
Governed delivery
Delivers changes with retries, ordering guarantees, and optional change history to support audit, lineage, and recovery requirements.
Why CDC matters
CDC is designed for systems where data needs to stay current without placing unnecessary load on production databases. By moving only what changed, CDC avoids repeated full refreshes and keeps downstream systems aligned as data volumes and change rates grow.
- Reducing source impact compared to frequent table scans or reloads
- Keeping analytics, operations, and AI workloads in sync with live activity
- Scaling efficiently as databases grow and change frequency increases
- Supporting continuous data movement without unpredictable compute costs
Top CDC use cases
Change Data Capture is most valuable when freshness and scale matter.
- Keep operational dashboards aligned with live transactional activity
- Maintain current data in warehouses and lakehouses without full reloads
- Power AI pipelines, vector indexes, and RAG systems with up-to-date context
- Replicate high-volume systems such as ERP, order management, and logistics platforms
Supported Sources
Sync supports CDC replication across major operational databases.
Key CDC Features
Log-based replication
Reads database transaction logs directly to capture changes efficiently while minimizing the source load.
Incremental delivery
Applies only new or changed rows by using maintained log positions to reduce latency and compute cost.Built for high-volume change
Designed to handle sustained change rates across large operational systems without degrading performance or reliability.Automatic resume
Automatically resumes job processing from the last recorded log-sequence number (LSN) offset to maintain continuity after interruptions.Change history tracking
Optionally stores change events for audit reviews, debugging, and rollback workflows.Unified monitoring
Provides dashboards that display latency, throughput, and processed rows across all CDC jobs.CDC delivers at scale in the real world
A large transportation network adopted Sync to modernize its change-driven replication across dozens of operational systems. This organization runs more than 400,000 CDC jobs each month and processes approximately 80 billion replicated rows. Using Sync CDC helps the organization keep shipment, routing, and compliance data consistently current at a predictable, scalable cost.
As a result, the team reduced pipeline development time by 50%, which improved financial forecasting accuracy and delivered more reliable dashboards to more than 2,000 business users. Sync CDC supports timely decisions related to staffing, capacity, and customer commitments.
How to Create a CDC Job
- Enable CDC for the source system.
- Create a new job in Sync and select CDC-enabled source and your destination.
- Choose Change Data Capture as the replication type.
- Add tasks for schemas and tables to include in the pipeline.
Learn more about Change Data Capture
What Is Change Data Capture and How Does It Work
Start your CDC pipelines with CData Sync
Run Enhanced CDC for a key table and measure end-to-end freshness, latency, and source impact.
