Oracle Data Integrator (ODI) Manufacturing Reviews & Insights

Score6.2 out of 10

126 Reviews and Ratings

Community insights

TrustRadius Insights for Oracle Data Integrator (ODI) are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

User-Friendly Interface: Reviewers have consistently praised the simplicity and user-friendliness of the interface, making it easy to navigate and utilize efficiently. The neat and clean design enhances the overall user experience, with users finding it particularly intuitive for extracting, transforming, and loading data.

Abundance of Transformation Options: Many users have highlighted the wide range of transformation options available, which significantly aids in completing tasks effectively and efficiently. These diverse options cater to different data handling needs, allowing users to work with large volumes of data from multiple sources seamlessly.

Scalability and Performance: The scalability and performance of the product have been commended by reviewers for handling high-volume batch load ETL processes and providing flexibility with big-data extractions. Users appreciate the top-notch scalability that enables them to tackle complex data integration tasks within one efficient tool.

Oracle Data Integrator (ODI) Reviews

2 Reviews

ManufacturingFood Production1Biotechnology1

Oracle Data Integrator is great for any ETL use cases

Rating: 8 out of 10

Incentivized

December 4, 2020

Use Cases and Deployment Scope

There are many products that do extract, transform, and load on data sets. It is a core task for any data engineer or data analyst. Alongside Oracle Cloud, we use Oracle Data Integrator to run ETL processes on our data. We use it widely to maintain our business intelligence systems.

Pros

High-volume, batch load ETL processes
Data transformations before data warehousing
Flexible big-data extractions

Cons

More easily used in other clouds/platforms
More features in UI
Updated flow of ETL processes in UI

Likelihood to Recommend

Oracle Data Integrator is well suited for any extract, transform, and load processes someone needs. It is very versatile and allows for even very large amounts of data to be uploaded and transformed. It is especially useful for big data transformations. Any cloud users will find this tool very useful.

Cameron Gable

Software Engineer III in Research & Development at Serimmune Inc. (Biotechnology, 11-50 employees)

Vetted Review

1 year of experience

View profile

Easily integrates data, but could perform better

Rating: 7 out of 10

Incentivized

May 25, 2020

Use Cases and Deployment Scope

We often work with Oracle database products and Oracle Data Integrator has been really useful for EPMA integration. It allows us to have a vivid understanding of topological data. It helps us clarify loose ends as it concerns the plotting of data modules. It provides a significant improvement in clarity that helps us identify issues at job locations. It has been really helpful in visualizing the data set and centralizing company data.

Pros

With Oracle Data Integrator, we get platform independence as it supports a wide range of platforms.
The FCP makes it easy to administer infrastructure and visualize data flows.
It is cost-effective.

Cons

I think it still has a lot of work to do in terms of speed of access and operation. That is why it rates a "7 out of 10" for me.
The quality of support can also be improved.
It can take longer than usual to generate documentation.
Generated code can also be complicated even for technical users.

Likelihood to Recommend

It is best to use Oracle Data Integrator when you need a data consolidation solution. It works effectively in that sense. We have also used it for multiple data integration projects where we had to load data warehouses. It worked efficiently. I would not recommend it if you are working with multiple SDLCs. It is not the best tool for multi-user development environments.

Verified User

Manager in Information Technology (Food Production company, 10,001+ employees)

Vetted Review

2 years of experience