Re: Replacement for CDC (Change Data Capture)

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Fri, 5 Sep 2014 10:36:03 -0500
Message-ID: <CAEueRAX3sw0aetCrehnC3rqVseb1m8vKQ6mzVuH3XZS0OXZFaw_at_mail.gmail.com>



Matt,

I would suggest taking a serious look at Dbvisit. These guys and the products are solid and significantly cheaper. http://www.dbvisit.com/products/dbvisit_replicate_real_time_oracle_database_replication/

Seth Miller

On Fri, Sep 5, 2014 at 10:23 AM, McPeak, Matt <vxsmimmcp_at_subaru.com> wrote:

> 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:36:03 CEST

Original text of this message