Overview

Rivery’s CDC Database Replication delivers real-time change data capture from source databases (e.g., MySQL, PostgreSQL, SQL Server, Oracle, MongoDB) into cloud data warehouses. It ensures fast, incremental streams using Write-Ahead Logs or native APIs, capturing inserts, updates, deletes, and schema changes without batch loads. The fully-managed, SaaS-based solution supports SSH/SSL/VPN topologies, offers precise recovery via point-in-time positioning, and includes metadata for transactional ordering. It scales efficiently with low latency, enabling robust near‑real‑time analytics and migration workflows.

Features and Capabilities

• **Real‑Time Streaming: **Continuously streams only data changes—no full-table reloads for updates.
• **Point‑in‑Time Recovery: **Ability to restart from exact log positions for data sync and recovery.
• **Transactional Metadata: **Appends __transaction_id and __transaction_order for accurate ordering across devices and streams.
• **Multi‑Topology Connectivity: **Supports SSH tunnels, SSL, VPN; ideal for on‑premise or VPC‑restricted databases.
• **Broad DB Coverage: **Native CDC support for PostgreSQL (logical replication / WAL), MySQL, SQL Server, Oracle, MongoDB, and more.
• **Incremental & Full Migration: **Initial migration via FileZone snapshot, followed by incremental CDC merging/upserts.
• **Scalable Architecture: **Built in Go with multithreading and flip-flop queues to handle large-scale, low-latency data ingestion.
• **Centralized Management: **SaaS platform offering managed connectors, logging, monitoring, and advanced error messaging.