1. Home
  2. Data Integration Tools
  3. Oracle Data Integrator (ODI) Reviews
  4. User Review of Oracle Data Integrator (ODI)
Oracle Data Integrator enthusiast!
October 25, 2019

Oracle Data Integrator enthusiast!

Holman Cárdenas, M.Eng, TOGAF®, ITIL® | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Data Integrator

Oracle Data Integrator (ODI)is probably the best ETL tool in the market. We use it in order to integrate data from several different sources (mainly Oracle and SQL Server) and load the processed data into our Data Warehouse, applying some basic data quality rules (not the main function of ODI, but it has some small data quality features).
  • Complex transformations.
  • Compatibility with almost any knows valid source.
  • Suited for batch loading processes.
  • Small bugs related to Java.
  • The user interface is not intuitive.
  • The complexity of the tool makes difficult to find qualified people in the market.
  • Expensive.
  • Because of its architecture, ODI requires fewer hardware resources (compared to other ETL tools on the market).
  • Expensive, but it's worth it.
Since our main databses are Oracle, we decided to use this tools. No other tools were evaluated (some research made, though).
Oracle Data Integrator (ODI) is a top choice when you want to integrate data from different and/or heterogeneous sources (any known database and a lot of types of valid files). Not suitable if you don't have well qualified IT professionals in your company since it is a complex tool.