Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Configuring Oracle GoldenGate OGG 11gR2 local integrated capture and using OGG for mapping and transformations – DOWNLOAD

Configuring Oracle GoldenGate OGG 11gR2 local integrated capture and using OGG for mapping and transformations – DOWNLOAD

In the article you will have a look at an OGG configuration example for local integrated capture and discover how to deploy some of the powerful OGG features related to data mapping and transformation. Starting from OGG 11gR2 Oracle implemented an integrated capture, in addition to the already existing transaction log capture now a day called classic capture, only from Oracle RDBMS data sources by integrating the OGG extract with the database logmining server. OGG mapping and transformation is a feature that works with both classic and integrated capture enabling complex transactions to be replicated across heterogeneous environments. I will cover each topic separately in the following sub-sections.

  • Example of local integrated capture using OGG 11gR2
  • Example of mapping and transformation using OGG 11gR2

The article is based on OGG 11gR2 environment configuration previously described here.

Read online from here or download Oracle GoldenGate OGG 11gR2 local integrated capture

October 26, 2012 Posted by | oracle | Leave a comment

Configuring Oracle GoldenGate OGG 11gR2 local integrated capture and using OGG for mapping and transformations

Configuring Oracle GoldenGate OGG 11gR2 local integrated capture and using OGG for mapping and transformations

In the article you will have a look at an OGG configuration example for local integrated capture and discover how to deploy some of the powerful OGG features related to data mapping and transformation. Starting from OGG 11gR2 Oracle implemented an integrated capture, in addition to the already existing transaction log capture now a day called classic capture, only from Oracle RDBMS data sources by integrating the OGG extract with the database logmining server. OGG mapping and transformation is a feature that works with both classic and integrated capture enabling complex transactions to be replicated across heterogeneous environments. I will cover each topic separately in the following sub-sections.

  • Example of local integrated capture using OGG 11gR2
  • Example of mapping and transformation using OGG 11gR2

The article is based on OGG 11gR2 environment configuration previously described here.
Continue reading

October 26, 2012 Posted by | oracle | 1 Comment