Theory Question/Discussion regarding Replication Tools
From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Mon, 3 Apr 2023 14:29:19 -0400
Message-ID: <CAP79kiR1sQD0bPG2tJeRyOxkg1WcHTwF6AZU_8z3GkafwqZ57g_at_mail.gmail.com>
Find myself in an interesting position where multiple databases need to be kept in sync with transactions. Primarily caused by corporate acquisitions.
Date: Mon, 3 Apr 2023 14:29:19 -0400
Message-ID: <CAP79kiR1sQD0bPG2tJeRyOxkg1WcHTwF6AZU_8z3GkafwqZ57g_at_mail.gmail.com>
Find myself in an interesting position where multiple databases need to be kept in sync with transactions. Primarily caused by corporate acquisitions.
Having dealt with replication in the past with both Goldengate and IBM's QRep, is it just me, or is replication a "band-aid/bandage" for a bad design when multiple end points need to be kept in sync?
Seems to me replication is what you slap-on to feed a data mart, or a postgres or a Snowflake when you don't have some kind of central hub that is responsible for sending those transactions to their appropriate end points.
I'm curious what solutions what you guys have seen and if any of your platforms are using a central type hub to send transactions out to different end points when those end points are databases such as Oracle, Postgres, Snowflake?
Am I crazy, or is everyone else? :D
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 03 2023 - 20:29:19 CEST