Oracle Data Integrator: ODI

Why choose ODI:

Faster and simple development: Declarative
Data quality firewall
Better execution performance: ETL architecture based on RDBMS and SQL engines
Simpler and more efficient architecture
Platform Independence
Data Connectivity
Cost-savings

Data integration scenario in recent days:

• DWH
• BI
• MDM
• Big data
• Apps
• SOA

 Components of ODI:

• Repository
• Master : Contains- 
• user privilege, 
• source and target connectivity, 
• subsequent version of objects
• Work : Contains- 
• meta data of source and target definitions,
• transformation and data movement rules
• workflow for orchestration of transformation and data movement
• jobs schedules
• logs
• execution status
• Execution: required for PROD and contains
• operational meta data
• generated code
• execution results
•  statistics
• Studio
• Designer navigator
• Operator Navigator
• Topology Navigator
• Security Navigator
• Agents
• stand alone
• j2ee
• co-located(in 12c)
• Console
• OEM