Replacement for CDC (Change Data Capture)

From: McPeak, Matt <vxsmimmcp_at_subaru.com>
Date: Fri, 5 Sep 2014 15:23:09 +0000
Message-ID: <D7864FA3E7830B428CB2A5A5301B63EE01BC84B9B1_at_S7041VA005.soa.soaad.com>



Experts,

I do not have access to a 12c instance yet, but it seems from the documentation that Oracle Change Data Capture is not delivered as part of 12c. I mean: not merely deprecated, but gone.

Is that true? If so, what are your thoughts on replacing that functionality? GoldenGate is not an option due to the price, and Streams is either gone or deprecated in 12c, so we don't want to go there even if we could.

I am thinking something along the lines of database triggers to enqueue messages to an Advanced Queue (AQ), and then use AQ functionality to implement the publish-subscribe model that CDC had.

But "solutions" involving database triggers always seem amateurish to me (maybe wrongly). So, I'm asking the group for better ideas.

Any thoughts?

Thanks in advance!

Matt

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 05 2014 - 17:23:09 CEST

Original text of this message