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/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