SynchDB

About SynchDB

SynchDB is a Open-Source PostgreSQL extension designed to replicate data from one or more heterogeneous databases (such as MySQL, MS SQLServer, Oracle, etc.) directly to PostgreSQL in a fast and reliable way. PostgreSQL serves as the destination from multiple heterogeneous database sources. No middleware or third-party software is required to orchestrate the data synchronization as SynchDB extension itself is capable of handling all the data synchronization needs.

Notable Features

Efficient Data Synchronization

Synchronize data seamlessly with minimal latency and maximum reliability. SynchDB ensures that your PostgreSQL database is always up to date with the latest changes from source systems, optimizing performance for mission-critical applications.

Multiple Heterogeneous Database Sources

Connect to and synchronize data from various database platforms, including MySQL, Oracle, SQL Server, and more. SynchDB bridges the gap between diverse systems, offering seamless interoperability.

Flexible Data Transform Rules

Apply custom transformation rules during synchronization to align data structures and formats with your PostgreSQL schema. SynchDB provides the flexibility needed for complex data integration scenarios.

Built as a PostgreSQL Extension

Integrated directly into PostgreSQL, SynchDB offers superior performance and a native experience. Manage synchronization tasks with PostgreSQL tools, ensuring a seamless workflow.

Hassle-Free System Provisioning

Easily configure and deploy SynchDB with a user-friendly setup process. Its streamlined provisioning minimizes effort, so you can focus on your data, not the deployment.

DDL and DML Replication Support

SynchDB supports both schema changes (DDL) and data modifications (DML) for comprehensive replication capabilities. Keep your PostgreSQL database aligned with source systems, even as they evolve.

Architecture

SynchDB‘s architecture is a powerful blend of Java and C components working together to deliver seamless heterogeneous database replication. At its core, SynchDB utilizes Debezium Embedded, leveraging its mature change-data-capture capabilities. Data is processed, converted, and transformed directly within PostgreSQL, taking full advantage of its robust, feature-rich ecosystem to ensure efficiency, reliability, and scalability in synchronization tasks.

SynchDB Workflow

SynchDB’s workflow begins with capturing change data from heterogeneous databases such as MySQL (binlog) and SQL Server (transaction log CDC) via Debezium. The changes are converted into a generalized JSON structure based on table schema information. This data is then passed to the SynchDB extension, where it undergoes processing and transformation before being seamlessly applied to PostgreSQL, ensuring efficient and accurate synchronization.