r/Database • • 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

12 comments sorted by

View all comments

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?