Oracle Data Integrator (ODI) - The ELT tool
November 19, 2025

Oracle Data Integrator (ODI) - The ELT tool

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

Overall Satisfaction with Oracle Data Integrator (ODI)

We use Oracle Data Integrator (ODI) as one of our ELT tools, the major difference stating that this is a ELT tool when compared to the traditional ETL tool. Oracle Data Integrator (ODI) helps us moving data from heterogenous sources along with the concept of creating loop through logic across similar data instances without much of a hassle.

Pros

  • Integrating Operational Data
  • Integration Time keeping Data
  • Integrating Financial Data

Cons

  • Since this is a Java based tool, resource utilization is a key
  • Easier trouble shooting methods
  • Positive would be ability to handle high volume data
  • Negative impact is the learning curve
  • Resource intensive solution
Oracle Data Integrator (ODI) is a reliable ELT tool, supporting data loads from various heterogenous sources. It is effective both for structured as well as non structured data. Its works well for creating translations and transformation and also aids in the data quality checks when combined with an MDM solution. Troubleshooting issues can be of a challenge if it is not configured properly.
I have used tools like Streamsets for streaming data sources and in the past used Informatica Power Center for moving data from sources and applying the necessary transformation.

Do you think Oracle Data Integrator (ODI) delivers good value for the price?

Yes

Are you happy with Oracle Data Integrator (ODI)'s feature set?

Yes

Did Oracle Data Integrator (ODI) live up to sales and marketing promises?

Yes

Did implementation of Oracle Data Integrator (ODI) go as expected?

Yes

Would you buy Oracle Data Integrator (ODI) again?

Yes

Oracle Data Integrator (ODI) works good in scenarios where data needs to be sourced from multiple heterogenous data sources. This works well with projects to mastering data for MDM solutions as well in the case of Enterprise Data warehousing solutions leveraging its high-performance Extract, Load, Transform (ELT) capabilities to push transformations to the database. This can be also helpful for non structured data sources as well.

Oracle Data Integrator (ODI) Feature Ratings

8.0
Connect to traditional data sources
8
Connecto to Big Data and NoSQL
8
8.0
Simple transformations
8
Complex transformations
8
7.4
Data model creation
8
Metadata management
8
Business rules and workflow
7
Collaboration
7
Testing and debugging
7
7.0
Integration with data quality tools
7
Integration with MDM tools
7

Comments

More Reviews of Oracle Data Integrator (ODI)

  1. Home
  2. Data Integration Tools
  3. Oracle Data Integrator (ODI) Reviews
  4. User Review of Oracle Data Integrator (ODI)