File Library


GoldenGate and ODI - A Perfect Match for Real-Time Data Warehousing
Topic: Business Intelligence Files
Owner: Michael Rainey
Date: 2013-05-28
Subtopic: Kscope13

Oracle Data Integrator and Oracle GoldenGate excel as standalone products, but paired together they are the perfect match for real-time data warehousing. Following Oracle’s Next Generation Reference Data Warehouse Architecture, this discussion will provide best practices on how to configure, implement, and process data in real-time using ODI and GoldenGate. Attendees will see common real-time challenges solved, including parent-child relationships within micro-batch ETL.

The following key objectives will be the focus of the presentation:
1. Explain how Oracle products such as ODI and GoldenGate are used in implementing the Oracle Next Generation Reference DW Architecture.
2. Describe and demonstrate how to configure GoldenGate for replication to the data warehouse staging and foundation layer schemas.
3. Recommend best practices for developing real-time ETL against Oracle Data Integrator CDC tables.


Download File View File   MRainey.GoldenGateandODI.pdf
Download File   Goldengate.rainey-1.m4v

Become a member of ODTUG to gain access to more than 2,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database


Click here to see the Full Techincal Resource Database