Try our new research platform with insights from 80,000+ expert users

AWS Data Pipeline [EOL] vs Oracle Data Integrator (ODI) comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

AWS Data Pipeline [EOL]
Average Rating
8.0
Number of Reviews
2
Ranking in other categories
No ranking in other categories
Oracle Data Integrator (ODI)
Average Rating
8.2
Reviews Sentiment
6.8
Number of Reviews
70
Ranking in other categories
Data Integration (6th)
 

Featured Reviews

Geoffrey Leigh - PeerSpot reviewer
A stable, scalable, and reliable solution for moving and processing data
We're only considering enhancing the presentation layer to give a more multidimensional OLAP view that AWS seems to have decided on. Redshift with the data mart structure is like an OLAP cube. Oracle Analytics Cloud is an over-code killer and is not what we need. I was looking at Mondrian, which used to be part of the open-source stack from another vendor that works. Still, I am also looking at some of the other OLAP environments like Kaiser and perhaps decided to go to Azure with Microsoft Azure analysis cloud, but that's not multidimensional either as SSAS used to be. We tried the Mondrian, and that didn't perform how we expected. So, we are looking at resetting something to perform as an OLAP in the cloud, particularly AWS, so that we might consider an Azure solution.
Jagadish Sau - PeerSpot reviewer
Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved
My company has around ten users of Oracle Data Integrator (ODI). A team of two to five people handles the deployment and maintenance of the solution. The current client of my company has this plan of moving to the cloud, with the possibility of replacing the ETL tool altogether, which could mean that more data is coming up, so there may be a plan to increase the usage of Oracle Data Integrator (ODI). My advice to others looking into implementing Oracle Data Integrator (ODI) is that if your database is on Oracle or SQL server, then Oracle Data Integrator (ODI) is a good tool to use. My rating for Oracle Data Integrator (ODI) is seven out of ten.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The most valuable feature of the solution is that orchestration and development capabilities are easier with the tool."
"It is a stable solution...It is a scalable solution."
"The most valuable feature that we use is the Knowledge Modules."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"It effectively manages errors through its logging and exception-handling capabilities."
"It has the ability to easily load slowly changing dimensions."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"It's completely user-friendly."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
 

Cons

"The user-defined functions have shortcomings in AWS Data Pipeline."
"It's almost semi-automatic because you must review and approve code push, which works well. Still, we had many problems getting there during the deployment process, but we got there."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"We used a third party to do the implementation of ODI."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
 

Pricing and Cost Advice

"The way we use it, I think it is fair as we're getting a good value for money compared to having a server or some other data pipeline."
"I rate the pricing between six to eight on a scale from one to ten, where one is low price, and ten is high price."
"The Oracle Data Integrator (ODI) pricing isn't expensive, but it's not cheap, so it's in the middle. I'd rate the pricing as three out of five."
"I have yet to determine the exact figure for Oracle Data Integrator (ODI) pricing, but it has lower pricing than Informatica."
"The solution is very expensive."
"Per user, it is $900 USD per year, though they will give some discount. However, even a 60% to 70% of discount for each won't help us much. On top of that, there is the perpetual license you must pay at the outset."
"I rate the platform pricing as five out of ten."
"The license can be costly, but in certain complex cases, ODI proves to be the optimal solution."
"There is a standard license to use the solution but there are other costs in addition, such as hardware and operating system."
"We found that the cost compared to other integration tools is a little high, but the solution works great."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Comparison Review

it_user99375 - PeerSpot reviewer
Mar 31, 2014
Oracle GoldenGate vs. Oracle Active Dataguard
As an Oracle DBA, while working upon high availability of your database you may stumble upon various Oracle strategic capabilities that fall into categories of Oracle Replication. Oracle provides various technologies for replication like GoldenGate, streams, and Active Dataguard. Replication…
 

Top Industries

By visitors reading reviews
Financial Services Firm
21%
Computer Software Company
20%
Government
9%
Manufacturing Company
5%
Financial Services Firm
16%
Computer Software Company
14%
Government
9%
Manufacturing Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about AWS Data Pipeline?
The most valuable feature of the solution is that orchestration and development capabilities are easier with the tool.
What is your experience regarding pricing and costs for AWS Data Pipeline?
I rate the pricing between six to eight on a scale from one to ten, where one is low price, and ten is high price.
What needs improvement with AWS Data Pipeline?
The user-defined functions have shortcomings in AWS Data Pipeline. The user-defined functions could be one of the areas where I can write a custom function and embed it as a part of AWS Data Pipeli...
What's the difference between Oracle Integration Cloud Service and Oracle Data Integrator (ODI)?
Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for those who might find the setup to be challenging. There are complications that c...
What do you like most about Oracle Data Integrator (ODI)?
ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases.
What is your experience regarding pricing and costs for Oracle Data Integrator (ODI)?
The pricing of Oracle Cloud Services is not favorable as it charges daily regardless of usage, unlike competitors who charge only for days used.
 

Also Known As

No data available
ODI
 

Overview

 

Sample Customers

bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday
Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Find out what your peers are saying about AWS Data Pipeline [EOL] vs. Oracle Data Integrator (ODI) and other solutions. Updated: March 2024.
816,406 professionals have used our research since 2012.