Tuesday, October 2, 2012

Oracle Data Integrator Overview, What i done.

Oracle Data Integrator Overview

I need to share my knowledge of Oracle Data Integrator, what I done before.
Currently I’m using two different purposes for Database Integration.

1.       Database consolidation

In this time, I’m consolidating about 100 tables from 30 databases in whole country. The following picture shows you overall process of database consolidation.



Also we are consolidating tables to two different type of way.
  • Bulk load and insert (Select, Truncate, Insert)
  • Get only changed data (CDC – Changed Data Capture)

Because some calculated tables should to use first way. But it is not appropriate for big data. Therefor we are using second way.
The following picture shows concept of Changed Data Capture functionality.



2.       Big Table creation

Some specific reports need well transformed table structure. It means, when we are using Oracle Business Intelligence, it is requiring STAR TRANSFORMATION of tables.


Oracle Data Integrator Deployment Overview

Currently we are using following deployment architecture for above scenarios. We recommended using latest version of Oracle Data Integrator, which is 11.1.1.6.0. Because when we were using 11.1.1.5, there is some bug on Changed Data Capture side.



Oracle Data Integration Installation Plan

I just described short installation plan of Oracle Data Integrator on client and server side.

Server side:
  • 1.       Install Oracle Database
  • 2.       Install RCU 11.1.1.6.0 (Oracle Data Integrator module) (Oracle RCU Installation Guide)
  • 3.       Install JDK 1.6 or higher
  • 4.       Install Oracle Data Integrator 11.1.1.6.0 (Java EE Agent, ODI Console, Public Web Service etc…)
Client side
  • 1.       Install JDK 1.6 or higher
  • 2.       Install Oracle Data Integrator 11.1.1.6.0 (ODI Studio)


Thank you for your visit in my short post. :-). If you have an any questions, please comment here.

Best regards,
Erdenebayar