What is ODI ?

What is ODI ?
  • ODI stands for Oracle Data Integrator. it is used as ETL tool.
  • Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements like

— High-volume batch processing with optimal performance
— trickle-feed integration processes
— high-performance batch loads
— SOA-enabled data services
— This tool supports variety of technologies ranging from all RDBMSs to legacy applications

  • Oracle Data Integrator (ODI) is a data integration platform focused on fast
    bulk data movement and handling complex data transformation.
  • ODI Provide graphical environment to build, manage and maintain data integration processes in Business intelligence systems
Advantage of ODI
• Flow based Declarative User interface
• Reusable Mappings
• Multiple Target Support
Oracle 12c New feature
• Oracle Data Integrator XML Driver Enhancements

• JSON support

• Multi-threaded Target Table Load

• Step-by-Step Debugger

• Enhanced Big Data Support

• ODI Exchange for Sharing Global Oracle Data Integrator Objects

• Enhanced Integration with Oracle Enterprise Data Quality

E-LT vs ETL

ETL

  • Stands for Extract, Transform and Load
  • Here, data is first extracted from various sources, transformed in a
    proprietary middle-tier ETL engine, and finally loaded into the target.
E-LT
  • Stands for Extract, Load and Transform
  • Here, data is first extracted from various sources, loaded into the
    destination server and finally, transformed on the target RDBMS using
    native SQL operators