1. Home
  2. Data Integration Tools
  3. Oracle Data Integrator (ODI) Reviews
  4. User Review of Oracle Data Integrator (ODI)
Only ETL tool I know that works the way it is claimed
August 04, 2014

Only ETL tool I know that works the way it is claimed

Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Data Integrator

ODI is used in our team to deliver Data warehouse reporting data.
  • ELT functionality to improve the performance of the data load
  • Able to work with different rdbms and file structures without any issue.
  • Adaptability to learning the tool and implementing the projects required by the company.
  • The GUI or ODI studio has Garbage Collector problems like freezing up if used for a long time without closing the studio.
  • ODI 12c has got it, but 11g has a restriction in terms of loading data into multiple targets in the same interface.
  • ODI is a low money tool compared to other ETL tools in the market.
  • Over all product development becomes efficient as a result of these low cost tools.
IBM Infosphere, Informatica. I worked on the mentioned tools as well as ODI. I liked ODI because it is easy to use with great features that every other ETL tool has in the market.
The only reason for this rating is I guess the usability of the tool .
The whole knowledge of how ODI works and what customizations can be done using ODI's key metrics. Some key questions to ask are:
Which objects do what in ODI?
How are objects migrated between different environments?
How are agents set up and what are their uses? How do you schedule scenarios?
What different types repositories does ODI use?