The latest release of SynchDB 1.4 brings significant enhancements for developers replicating data from heterogeneous sources into PostgreSQL or IvorySQL. This open-source extension now fully supports Oracle Container Database (CDB/PDB) architecture, secures snapshot transfers, and delivers improved stability under continuous load.
Key Changes in SynchDB 1.4
Oracle CDB/PDB Support Everywhere: SynchDB now works with Oracle deployments using the Container Database architecture across all three replication paths: change data capture via the embedded Debezium engine, initial snapshots through
oracle_fdw, and log-based replication with Openlog Replicator (OLR). Specify the source in CDB/PDB format (e.g.,FREE/FREEPDB1) when creating a connector, and SynchDB automatically connects to the correct PDB service. This path has been tested against Oracle 23ai.TLS-Secured FDW Snapshots: Initial snapshots taken via foreign data wrappers can now run over encrypted connections. TLS is supported for MySQL and PostgreSQL sources, while Oracle Wallet secures connections for Oracle and OLR sources. Configuration is done through the new
syncsettings, ensuring data integrity and privacy during initial loads.Stability Improvements: SynchDB 1.4 includes fixes to maintain stable replication under sustained load, reducing the risk of connection drops or lag during high-volume transfers.
Why This Matters for Developers
For teams running Oracle databases in modern containerized environments, the CDB/PDB support eliminates a major barrier to real-time replication into PostgreSQL. It simplifies migration and integration projects, especially with the latest Oracle 23ai. The new TLS and Oracle Wallet options address security concerns for initial data loads, which previously traveled over unencrypted channels. This is crucial for compliance with data protection regulations. Overall, SynchDB 1.4 makes heterogeneous replication more robust, secure, and ready for production use.