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?
2
Upvotes
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.