Bucardo vs CData Sync

Bucardo is a free, open-source system for asynchronous PostgreSQL replication in multi-source and multi-target arrangements. It supports multi-way synchronization and one-direction master-standby replication. Users define named syncs that copy selected tables between a server and other servers. A Perl daemon listens for NOTIFY requests and connects to remote databases to copy data. Multi-source setups can use a standard conflict handler or a custom handler assigned per table. Configuration and replication databases require PostgreSQL 8.1 or later, while the configuration database also needs PL/pgSQL and PL/PerlU. The daemon needs a Unix-like operating system, is tested mainly on Linux and macOS, and does not run natively on Windows. Installation is available from source, RPM or Debian packages, and FreeBSD Ports. Bucardo does not replicate DDL or schema changes. The listed latest release is 5.6.0.

CData Sync replicates data from databases, SaaS applications and APIs to databases, data lakes and data warehouses. CData says it supports over 250 sources and offers a catalog of cloud and on-premises destinations. Pipelines can use incremental loading and, for supported sources, real-time Change Data Capture. ETL and ELT transformations are available through SQL or dbt Core and Cloud. Users can schedule pipelines and receive email, Slack or Teams notifications when workflows finish or fail. Sync can run on premises, in cloud environments or through CData-hosted Sync Cloud, and is listed for Linux, Windows, web, API and self-hosted use. Its APIs and scripting can manage connections and jobs, inspect status and history, download logs, and run custom behavior around jobs. It can adjust destination schemas when source schemas change; its overview says it does not delete destination columns or reduce their size. CData documents TLS/SSL encryption and encrypted sensitive configuration values and reports third-party SOC 2 Type II and ISO/IEC 27001:2022 audits. A 14-day trial is available; there is no free plan.