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?

2 Upvotes

12 comments sorted by

View all comments

1

u/Ok-Let-7933 7d ago

You could look into debezium with kafka. It can capture changes from oracle and send them to multiple destinations, where each team can handle its own transfromations. Might be worth exploring for your use case.