Re: Future ETL directions w/o CDC...

From: David Mann <dmann99_at_gmail.com>
Date: Mon, 29 Jul 2013 11:59:24 -0400
Message-ID: <CAGazuyVU_D9GacXAJMtT=tn06Jn+3WuksJvDJBr+baawjZmFBg_at_mail.gmail.com>

Thanks for the replies Alex and Job...
Alex you are right, I do see features deprecated in 9i still in use today. I just get a sinking feeling recommending using something for a new project when I know the feature is deprecated and future of it is uncertain. If we already had CDC running successfully and all the kinks worked out then by all means I would milk it for as long as it makes sense.

Job I was just finishing up with part 3 when your response came through. I didn't know about the tutorial though, that is fantastic. I will check it out and see if it is a possible direction for us. I think either way we need to take a stronger look at ODI, I can see some other projects that may benefit from it and the Reference Architecture.

On Mon, Jul 29, 2013 at 11:51 AM, Job Miller <jobmiller_at_yahoo.com> wrote:

> Oracle Data Integrator has pre-built CDC on top of GG that is all
> controlled through ODI.
> ODI has a "knowledge module" for this.
>
> Mark Rittman blogged a 3 part series about it:
>
>
> http://www.rittmanmead.com/2013/02/goldengate-and-oracle-data-integrator-a-perfect-match-part-1/
>
> There is a tutorial here also:
>
>
> http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_11g/odi_gg_integration/odi_gg_integration.htm
>
> Oracle Data Integrator can be combined with Oracle Golden Gate (OGG) ,
> that provides a cross-platform data replication and changed data capture.
> Oracle Golden Gate worked in a similar way to Oracle’s asynchronous change
> data capture but handles greater volumes and works across multiple database
> platforms. Golden Gate uses its own data logging (or “trails”) to record
> DML and DDL activity on a source database, which it then replays on staging
> and target platforms to replicate changes in real-time. This makes OGG a
> valuable technology, especially if you are have replication performance
> limits. In this OBE, participants use ODI’s Journalizing Knowledge Module
> for OGG to generate OGG scripts based on ODI models and interfaces.
>
>
>
> ------------------------------
> *From:* Alex Fatkulin <afatkulin_at_gmail.com>
> *To:* dmann99_at_gmail.com
> *Cc:* "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
> *Sent:* Monday, July 29, 2013 11:04 AM
> *Subject:* Re: Future ETL directions w/o CDC...
>
> The CDC gets scratched in favor of GoldenGate, yes. The reason is CDC was
> based on Oracle Streams (the async one at least) which are also getting
> scratched in favor of GoldenGate.
>
>
>
>
>

-- 
Dave Mann
General Geekery | www.brainio.us
Database Geekery | www.ba6.us | _at_ba6dotus | http://www.ba6.us/rss.xml

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 29 2013 - 17:59:24 CEST