Re: Future ETL directions w/o CDC...
Date: Mon, 29 Jul 2013 08:51:14 -0700 (PDT)
Message-ID: <1375113074.75795.YahooMailNeo_at_web126106.mail.ne1.yahoo.com>
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:
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 29 2013 - 17:51:14 CEST