# Oracle Data Integrator Reviews 2026. Verified Reviews, Pros & Cons | Capterra

> Is Oracle Data Integrator the right Integration solution for you? Explore 20 verified user reviews from people in industries like yours to make a confident choice.

Source: https://www.capterra.com/p/72010/Oracle-Data-Integrator/reviews

---

Oracle Data Integrator

4.4 (20)

[View alternatives](https://www.capterra.com/p/72010/Oracle-Data-Integrator/alternatives/)

Provider data verified by our Software Research team, and reviews moderated by our Reviews Verification team. [Learn more](https://www.capterra.com/our-story/)

* * *

Last updated January 15th, 2026

# Reviews of Oracle Data Integrator

Ease of use

3.6

Customer Service

3.5

## Showing most helpful reviews

Showing 1-20 of 20 Reviews

Sort by:

Most Helpful

Rating

Company Size

Reviewer's Role

Length of Use

Frequency of Use

Jorge C.  
Co-Founder & Infrastrucure Manager  
  
Used the software for: 6-12 months

### "ODI is a complete product in terms of data transformation tools. "

July 9, 2018

5.0

Mainly performance. Reliability and robustness An endorsement of a brand. flexibility Ability to integrate with other tools

Pros

Some benefits of the product are the capacity of integration with multiple sources of data, using connectors. It supports a wide variety of data sources and destinations. It has robust qualities such as programming of transformation tasks, as well as the tracking of said processes. ODI has precedents in terms of performance, that is, if the priority of an organization is the processing of information volumes, having at hand a robust but flexible tool then ODI is a great option. The way in which ODI is built in its architecture, allows changes to be made quickly, with ease from a technical perspective but with a great impact for business areas. ODI offers a really competitive tool to integrate with 3rd parties sources such: IBM DB2, Teradata, Sybase IQ and another protocols like plain text files, ERP, LDAP and XML.

Cons

Access to documentation, but is rewarded by the wide range of courses offered by Oracle to specialists in the area

Review Source

VR

Verified Reviewer  
Systems Support Engineer - Managed Services  
Information Technology and Services  
Used the software for: 6-12 months

### "Best data integration platform"

September 28, 2019

5.0

We are one of the largest telecommunication services provider in Asia. We have a multi-million customer base. So the Big data team wanted an ETL tool which can manipulate the high volume of data with high performance. After long research, we chose ODI. We have installed the ODI in a clustered environment. Basically it runs on top of the Oracle Weblogic Server. However, install installation was quite hard. But we were able to manage that. We could able to interface ODI with hundreds of supported data sources. Finally, I can say this the best and most advanced ETL tool I have ever worked.

Pros

+Support thousands of data sources. +Deployment time could be cut down +Can be interface with many 3rd party tools. +High performance and flexibility.

Cons

+Implentation is hard. +Not supported on Solaris OS. + Lack of community support. +High license cost.

Alternatives considered

[PowerCenter](https://www.capterra.com/p/117/PowerCenter/)

Reason for choosing Oracle Data Integrator

+Supports SOA enabled data integration +Comprehensive documentation +Can be integrated with many 3rd party tools

Review Source

DILIP G.  
Middleware Administrator / Developer  
Financial Services  
Used the software for: Less than 6 months

### "It's very heavy product to use, implementation and troubleshooting makes cumber-sum for the users. "

April 19, 2018

2.0

Pros

In latest version it comes up with integrating with Oracle Service Oriented Architecture services, and vice versa and it enables users to automate end to end business functionality across the products.

Cons

Not easy to use, requires proper understanding on the tool how it works and also requires more resources

Review Source

Antonino S.  
Senior Consultant  
  
Used the software for: 2+ years

### "A complete ETL for DWH and EPM tools"

February 20, 2018

4.0

Pros

ODI allows to choose where collocate the trasformation area (Source, Target or other). ODI has so many connectors for the main data sources / destinations. ODI allow to customize the behavior the own connectors

Cons

Very few update for connectors. Very high pricing if not in bundle with other products. SAP connectors very expensive and hard to use

Review Source

VR

Verified Reviewer  
Assistant Manager - MIS Analyst  
Logistics and Supply Chain  
Used the software for: 2+ years

### "Oracle Data Integrator - My Choice"

May 5, 2019

4.0

My over all experiences about the product is a great. It's complete on my quality.

Pros

Yes, It's amazing data integration tool for new customers. It's easily connect to many database like MySql, SQL Server etc. It's completely user friendly. We can easily manage to packages, ETL and Procedures. Over all very good data mearging tool.

Cons

We can easily create the ETL and schedules. We can check logs on daily basis.

Review Source

VR

Verified Reviewer  
COO & EA Manager  
Computer Software  
Used the software for: 1-2 years

### "Best World class solution for integrating data from many sources"

September 26, 2018

5.0

In general, my experience was great. I created Knowledges Modules based in templates, interfaces, scenarios, etc. and the data integration from may source was possible thanks to ODI.

Pros

Flexibility with the Knowledge Modules, besides the available tools in Designer for building my interfaces; the experience was really great.

Cons

I worked in version 11g, the audit module wasn't too clear sometimes. It was a little hard for debugging failed instances

Review Source

VR

Verified Reviewer  
Team Lead, Reporting and Analytics  
Higher Education  
Used the software for: 6-12 months

### "A great tool for moving and transforming data"

December 5, 2018

5.0

Pros

This product is very robust and has so many features to move and transform data. Once set up, it is very easy to grab data from many different sources. Allows us to group data ETL processes by project and automate the transfers

Cons

The product is quite confusing to use. lots of small parts that need to be set up in the right order. I found added Oracle packages to the mappings wasn't as straight forward as I would have liked.

Review Source

VR

Verified Reviewer  
Manager  
Computer Software  
Used the software for: 6-12 months

### "Oracle Data integrator"

January 15, 2019

5.0

It's good tool

Pros

It's good ETL tool and easy to define mapping and fetch the data.

Cons

Need some drag and drop features for objects and qualifier we use in comparison to other ETL tools.

Review Source

dK

divya K.  
Assossiate system engineer  
Insurance  
Used the software for: 6-12 months

### "Oracle Data Integrator 11g"

May 3, 2019

4.0

Pros

Its capacity to store,maipulate and processing the data, It is helpful to process huge amounts of data.

Cons

It is a bit slow, I would rather recommend a newer version ODI 12 c which is much easier to use.

Review Source

Burak C.  
Accounts Payable Analyst  
Food & Beverages  
Used the software for: Less than 6 months

### "Define and Integrate"

September 28, 2020

5.0

Pros

Trainings and tutorials of Oracle Data Integrator can be found easily and doesn't need an IT expert to do the work. All can be tested in a virtual environment too. Recommended for small or medium businesses but for big projects like defining what data you have and understanding the process of integration. The results are easy for the management to have the helicopter view.

Cons

Oracle Data Integrator can be used for spesific tasks and projects. No free or trial versions are available.

Review Source

AC

Arianna C.  
Manager  
Management Consulting  
Used the software for: 1-2 years

### "Scalabile e flessibile "

April 30, 2023

4.0

In diverse realtà con la necessità di integrare dati complessi da varie fonti e destinazione abbiamo proposto e settato l’uso di Oracle Data Integrator. Una volta installato e settato il tutto, operazione non banale, gli utenti hanno potuto accedere velocemente a tutte le loro informazioni, con gran soddisfazione.

Pros

Oracle Data Integrator è una piattaforma di integrazione dati che offre un’architettura flessibile e scalabile e che permette di eseguire processi ETL su vari sistemi distribuiti, riducendo il carico di lavoro e migliorando l’efficienza. Data Integrator utilizza un approccio di elaborazione “set-based” per ottimizzare le prestazioni e questo consente di elaborare una grande quantità di dati in modo veloce e ridurre il processo di esecuzione del ETL. Io software, inoltre, integra una buona funzione di gestione degli errori che permette agli utenti di identificare e risolvere velocemente i problemi.

Cons

Il processo di installazione e configurazione iniziale richiede molto tempo ed il software, per utenti poco esperti, può risultare complesso da usare.

Review Source

SB

Sabrina B.  
Risk Manager  
Financial Services  
Used the software for: 1-2 years

### "Ottimo strumento, facile da usare e funziona sul cloud "

November 19, 2023

5.0

Sono soddisfatta dell’esperienza con ODI. Li sto usando principalmente per traferire i dati dalla piattaforma big data al data-warehouse dell’azienda.

Pros

Oracle Data Integrator è uno strumento user-friendly con molte possibilità per sviluppatori e analisti di dati. È semplice da usare per l'integrazione e la migrazione dei dati tra diverse fonti.

Cons

Vorrei che ci fosse un modo più semplice per migrare gli scenari di ODI 11g alle nuove versioni di ODI 12c.

Review Source

BA

Beena A.  
Business Intelligence Consultant  
Information Technology and Services  
Used the software for: Less than 6 months

### "We use ODI to for our data warehouse."

May 6, 2018

4.0

ODI is much better and faster tha OWB and it can connect to any RDBMS and we can use any programming language to communicate with ODI

Pros

We converted our datwarehouse from OWB to ODI. ODI is faster than OWB. Learning curve was easier and lots of resources available online and the Oracle team was really helpful .

Cons

cloud Services were down without informing us. Uploading binary files to ODI was not easy and we had to raise a service request and use the sqlplus for loading the binary file. SCD's are handles differently in ODI than OWB.

Review Source

Marco R.  
Coordinatore Area Business Intelligence  
Pharmaceuticals  
Used the software for: 1-2 years

### "An excellent ETL tool, deeply integrated with Oracle solutions"

September 11, 2018

5.0

I will definitely use it again

Pros

It is a very powerful tool, deeply integrated with the Oracle world. Very often it is inserted in solutions such as BI

Cons

the price is not very low so its adoption must be carefully evaluated

Review Source

AK

Amresh K.  
Architect  
Information Technology and Services  
Used the software for: 1-2 years

### "Good"

January 24, 2019

4.0

Pros

Easy to load the data including text, CSV or XML file

Cons

Too much effort to implement the code in higher environment, It can be made user friendly

Review Source

VR

Verified Reviewer  
Solutions Architect | BPM/SOA/EAI  
  
Used the software for: Less than 6 months

### "Excelent Software "

March 31, 2018

5.0

Pros

Flexible, easy to use, learn and work in it, I like the way you get to customize it, it has out of the box connectors that make your life easier

Cons

The use of the ODI studio, because it is slow and you end up without RAM and it force you to restart the program and that makes your work slow

Review Source

VR

Verified Reviewer  
Software Quality Assurance Specialist  
Government Administration  
Used the software for: Less than 6 months

### "Standard Data Integration"

January 10, 2019

4.0

Decent entry into the data integration landscape

Pros

It provided the basic levels of functionality associated with data integration. The functionality is best associated with Oracle-related data sources.

Cons

The product is somewhat too tightly aligned with the Oracle platform

Review Source

OL

Osa L.  
Marketing  
Marketing and Advertising  
Used the software for: Less than 6 months

### "It's complicated but it gets the work done"

December 6, 2018

5.0

It's amazing when you have the power to aggregate data and make decisions from the aggregated data. This software truly is amazing, once you get past the learning curve.

Pros

It's not as intuitive as I would like, but it gets the work done

Cons

It's not as intuitive, but it's extremely powerful

Review Source

HF

Heshan F.  
Snr HR Execuive  
Human Resources  
Used the software for: 6-12 months

### "Oracle data intigrator"

May 25, 2020

4.0

Over all it’s a bit of a hassle to use as it has many approval processes

Pros

The bulk upload by the admin and the capability of users to be given specific admin rights to update their own changes

Cons

Intigrating issues some after approval has not changed in the system

Review Source

SH

Scott H.  
DData activation lead  
Marketing and Advertising  
Used the software for: Less than 6 months

### "Oracle service is lacking"

October 7, 2016

4.0

I have used the Data Integrator on a regular basis, and have had nothing but issues with the service team. Rumor has it that in 2017 service will be a premium, paid feature. No thanks!

Pros

Integration with Oracle products

Cons

Lack of support from Oracle.

Review Source

Similar Products

Featured