Oracle Data Integrator enthusiast!

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.

Oracle Data Integrator Feature Ratings

Pre-built connectors
10
Connector modification
9
Support for real-time and batch integration
10
Data quality services
8
Data security features
8
Monitoring console
9