Best For

Designed for all business sizes, it is a data integration platform that helps extract, load and transform data across multiple applications.

Product Details

Extract Load and Transform technology that improves performance and reduces data integration costs across heterogeneous systems.

Contact Details

Oracle

http://www.oracle.com

Founded in 1977

Located in United States

Starting Price

  • Not provided by vendor
  • Contact Oracle for pricing details.

Platform

  • Installed - Mac
  • Cloud, SaaS, Web
  • Installed - Windows
  • Mobile - iOS Native
  • Mobile - Android Native

Oracle Data Integrator Features

Dashboard
ETL - Extract / Transfer / Load
Metadata Management
Multiple Data Sources
Web Services

Oracle Data Integrator Reviews

Overall
4.5/5
Ease of Use
3.5/5
Customer Service
3.5/5

Showing Most Helpful

Showing 14 of 14 reviews

Showing Most Helpful

Showing 14 of 14 reviews

Sort by:

Filter By:

Rating
Company Size
Reviewer's Role
Length of Use
Frequency of Use
Verified Reviewer
Logistics and Supply Chain, 1001-5000 employees
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
5/5
Customer Service
4/5
Features
4/5
Value for Money
3/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
May 5, 2019

“Oracle Data Integrator - My Choice”

OverallMy over all experiences about the product is a great. It's complete on my quality.
ProsYes, 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.
ConsWe can easily create the ETL and schedules. We can check logs on daily basis.
Reviewer Source 
Source: Capterra
May 5, 2019
Antonino S.
Senior Consultant
Unspecified
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
3/5
Customer Service
2/5
Features
4/5
Value for Money
3/5
Reviewer Source 
Source: Capterra
February 20, 2018

“A complete ETL for DWH and EPM tools”

ProsODI 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
ConsVery few update for connectors. Very high pricing if not in bundle with other products. SAP connectors very expensive and hard to use
Reviewer Source 
Source: Capterra
February 20, 2018
Avatar Image
Jorge C.
Co-Founder & Infrastrucure Manager
11-50 employees
Used the software for: 6-12 months
Overall Rating
5/5
Ease of Use
4/5
Customer Service
4/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
July 9, 2018

“ODI is a complete product in terms of data transformation tools. ”

Overall 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.
ConsAccess to documentation, but is rewarded by the wide range of courses offered by Oracle to specialists in the area
Reviewer Source 
Source: Capterra
July 9, 2018
Verified Reviewer
Computer Software, 11-50 employees
Used the software for: 1-2 years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
5/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
September 26, 2018

“Best World class solution for integrating data from many sources”

OverallIn 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.
ProsFlexibility with the Knowledge Modules, besides the available tools in Designer for building my interfaces; the experience was really great.
ConsI worked in version 11g, the audit module wasn't too clear sometimes. It was a little hard for debugging failed instances
Reviewer Source 
Source: Capterra
September 26, 2018
divya k.
Assossiate system engineer
Insurance, 10,001+ employees
Used the software for: 6-12 months
Overall Rating
4/5
Ease of Use
4/5
Customer Service
3/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
May 3, 2019

“Oracle Data Integrator 11g”

ProsIts capacity to store,maipulate and processing the data, It is helpful to process huge amounts of data.
ConsIt is a bit slow, I would rather recommend a newer version ODI 12 c which is much easier to use.
Reviewer Source 
Source: Capterra
May 3, 2019
Beena A.
Business Intelligence Consultant
Information Technology and Services, 51-200 employees
Used the software for: Less than 6 months
Overall Rating
4/5
Ease of Use
3/5
Customer Service
3/5
Features
4/5
Value for Money
3/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
May 5, 2018

“We use ODI to for our data warehouse.”

OverallODI 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
ProsWe 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 .
Conscloud 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.
Reviewer Source 
Source: Capterra
May 5, 2018
Verified Reviewer
Higher Education, 1001-5000 employees
Used the software for: 6-12 months
Overall Rating
5/5
Ease of Use
2/5
Features
4/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
December 5, 2018

“A great tool for moving and transforming data”

ProsThis 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
ConsThe 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.
Reviewer Source 
Source: Capterra
December 5, 2018
Amresh K.
Architect
Information Technology and Services, 10,001+ employees
Used the software for: 1-2 years
Overall Rating
4/5
Ease of Use
4/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
January 24, 2019

“Good”

ProsEasy to load the data including text, CSV or XML file
ConsToo much effort to implement the code in higher environment, It can be made user friendly
Reviewer Source 
Source: Capterra
January 24, 2019
Osa L.
Marketing
Marketing and Advertising, Self-employed
Used the software for: Less than 6 months
Overall Rating
5/5
Ease of Use
3/5
Customer Service
4/5
Features
5/5
Value for Money
2/5
Likelihood to Recommend
7/10
Reviewer Source 
Source: Capterra
December 5, 2018

“It's complicated but it gets the work done”

OverallIt'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.
ProsIt's not as intuitive as I would like, but it gets the work done
ConsIt's not as intuitive, but it's extremely powerful
Reviewer Source 
Source: Capterra
December 5, 2018
Avatar Image
Marco R.
Coordinatore Area Business Intelligence
Pharmaceuticals, 1001-5000 employees
Used the software for: 1-2 years
Overall Rating
5/5
Ease of Use
3/5
Customer Service
5/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
September 11, 2018

“An excellent ETL tool, deeply integrated with Oracle solutions”

OverallI will definitely use it again
ProsIt is a very powerful tool, deeply integrated with the Oracle world. Very often it is inserted in solutions such as BI
Consthe price is not very low so its adoption must be carefully evaluated
Reviewer Source 
Source: Capterra
September 11, 2018
Verified Reviewer
51-200 employees
Used the software for: Less than 6 months
Overall Rating
5/5
Ease of Use
5/5
Customer Service
3/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
March 31, 2018

“Excelent Software ”

ProsFlexible, 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
ConsThe 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
Reviewer Source 
Source: Capterra
March 31, 2018
Verified Reviewer
Government Administration, 201-500 employees
Used the software for: Less than 6 months
Overall Rating
4/5
Ease of Use
3/5
Features
3/5
Likelihood to Recommend
5/10
Reviewer Source 
Source: Capterra
January 9, 2019

“Standard Data Integration”

OverallDecent entry into the data integration landscape
ProsIt provided the basic levels of functionality associated with data integration. The functionality is best associated with Oracle-related data sources.
ConsThe product is somewhat too tightly aligned with the Oracle platform
Reviewer Source 
Source: Capterra
January 9, 2019
Scott H.
DData activation lead
Marketing and Advertising, 201-500 employees
Used the software for: Less than 6 months
Overall Rating
4/5
Ease of Use
3/5
Customer Service
2/5
Features
2/5
Value for Money
3/5
Likelihood to Recommend
4/10
Source: Capterra
October 7, 2016

“Oracle service is lacking”

OverallI 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!
ProsIntegration with Oracle products
ConsLack of support from Oracle.
Recommendations to other buyersLook elsewhere. Staq makes a great product.
Source: Capterra
October 7, 2016
DILIP G.
Middleware Administrator / Developer
Financial Services, 501-1000 employees
Used the software for: Less than 6 months
Overall Rating
2/5
Ease of Use
2/5
Customer Service
2/5
Features
2/5
Value for Money
2/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
April 19, 2018

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

ProsIn 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.
ConsNot easy to use, requires proper understanding on the tool how it works and also requires more resources
Reviewer Source 
Source: Capterra
April 19, 2018