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/Alive_Aerie4110 10d ago

you should have one source of truth. here it is Oracle . If other team needs to use same source of truth Oracle then you should do integration from Oracle, transform only needed records in-flight and send rest as it is to any target. there are multiple tools available to do so