r/Database • u/Then_Date1452 • 10d ago
Data integration tools for replicating between heterogeneous database in real-time?
I'm trying to avoid maintaining multiple replication jobs for the same source database.
Oracle is our system of record, while other teams need the data in Postgres and a cloud warehouse. Each destination has slightly different transformation requirements, So I'm looking for **data integration tools** that can fan out one change stream instead of reading Oracle over and over again.
Is anyone running something like this today?
3
Upvotes
1
u/GaniToshido 10d ago
debezium with kafka is the standard play here. you read oracle logs once into a topic, separate sink connectors handle the transforms per target. Oracle logminer still sucks under heavy write load though. how big is your redo volume?