OLTP → ClickHouse Real-Time Sync
Powered by the Altinity ClickHouse Sink Connector
Supported Source Databases
| Source |
Support Level |
Engine |
| PostgreSQL |
Out of the box |
Debezium PostgreSQL Connector |
| MySQL |
Out of the box |
Debezium MySQL Connector |
| SQL Server |
Via Debezium |
Debezium SQL Server Connector |
| Oracle |
Via Debezium |
Debezium Oracle Connector |
| IBM Db2 |
Via Debezium |
Debezium Db2 Connector |
| MongoDB |
Via Debezium |
Debezium MongoDB Connector |
Architecture Overview
┌─────────────┐ CDC ┌──────────────────┐ Stream ┌──────────────┐
│ OLTP DB │ ──WAL──▶ │ Altinity Sink │ ────────▶ │ ClickHouse │
│ (PostgreSQL)│ │ Connector │ │ (OLAP) │
└─────────────┘ └──────────────────┘ └──────────────┘
Source Lightweight Mode Target
(No Kafka needed)
Key Points
Single Docker container — the Altinity Sink Connector runs as a single lightweight Java process. No Kafka, no Zookeeper, no Connect cluster required.
No Kafka needed — in Lightweight Mode, Debezium is embedded directly in the connector. Change events flow straight from the transaction log to ClickHouse.
Near real-time (seconds) — changes in your OLTP database appear in ClickHouse within seconds, not minutes or hours. Perfect for dashboards and analytics.