OWB 11gR2 – The Right Time with GoldenGate

The right time data warehousing presentation and demonstration using Oracle GoldenGate and OWB 11gR2 data warehouse operators at the recent ODTUG Kaleidoscope conference in Washington DC can be found below. It combines GoldenGate for replicating from a source to a stage system with OWB to process the changes using the dimension operator. I thought it was an awesome conference, useful from an educational and networking perspective I'd recommend others to attend who are looking to roll their sleeves up, learn and have fun.

The OWB 11gR2 right time demo with Oracle GoldenGate is here.

The demo walks through the setup of the extract and replicat processes (see Mark's post here for details on where to download GoldenGate etc thanks Mark), then the design of the mapping which processes customer changes and applies the inserts, updates and deletes using dimensional operators - it also incorporates the orphan management capabilities.

Export001

For you to use this you would need;

  • the ODI 10g JKM for GoldenGate which is patch number 9449058, and
  • the OWB 11gR2 patch 9785600, needed for the GoldenGate JKM to work, fixes a few little bugs.

You can get these from Metalink or eDelivery.

So, this is kind of what you'd expect anyway right with the code template based approach? So how about pushing the envelope, getting under the covers? High performance rich transformations are OWB's bread and butter, mix this with Oracle GoldenGate for replicating and capturing change with a little CDC infrastructure support and do all the stars align? Food for thought.

Comments:

Hi,

For this configuration (OWB with GG), is necesary that source and target servers have installed ODI??

Posted by guest on February 07, 2014 at 03:46 PM PST #

No, ODI was not needed when I did this. I simply used the JKM from ODI.

Cheers
David

Posted by David on February 07, 2014 at 04:42 PM PST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today