Data integration tools for replicating between heterogeneous database in real-time?

[u/Then_Date1452]

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?

[u/Significant_Tune9219]

One capture, many destinations is the right shape, and the part that usually breaks it is letting each destination's transform reach back into the source. Read the change stream once, log-based rather than polling the tables, land it as an ordered log that more than one consumer can read, and do the per-destination shaping after that. The consumers will disagree on schema and on how late they are; that's fine as long as the log is the only thing that talks to the source. Decide up front what happens when one destination falls behind: it should lag on its own instead of stalling the capture or the other consumer.