We performed a comparison between AWS Glue and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable features currently are glue studio, jobs, and triggers."
"The solution is stable and reliable."
"AWS Glue is quite better than other tools, but you have to learn it properly before you start using it."
"The solution is serverless so it allows us to transform data while optimizing the cost and performance of Spark jobs."
"AWS Glue's most valuable features are the data catalog, including crawlers and tables, and Glue Studio, which means you don't have to use custom code."
"It is AWS-integrated. There is end-to-end integration with the other AWS services. It is also user-friendly."
"The key role for Glue is that it hosts our metadata before rolling out our actual data. This is the major advantage of using this solution and our clients client have been very satisfied with it."
"AWS Glue's best features are scalability and cloud-based features."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"The most valuable feature that we use is the Knowledge Modules."
"It has the ability to easily load slowly changing dimensions."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"AWS Glue would be improved by making it easier to switch from single to multi-cloud."
"We face performance issues when using AWS Glue for data transformation and integration."
"On occasion, the solution's dashboard reports that a project failed due to runtime but it actually succeeded."
"There should be more connectors for different databases."
"The solution's visual ETL tool is of no use for actual implementation."
"The interface for AWS Glue could improve, they do not put a lot of details. You can write the code, in PySpark or in Scala, which is a big advantage, it is only easy to use for a developer. It will be difficult for new users to enter the cloud environment."
"The technical support for this solution could be improved. In future, we would like to connect more services like Athena or Kinesis to help control more loads of data."
"Cost-wise, AWS Glue is expensive, so that's an area for improvement. The process for setting up the solution was also complex, which is another area for improvement."
"The price needs to be lowered. It's too expensive."
"The solution lacks some functions and features."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations."
"The performance of the user interface is in need of improvement."
"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."
AWS Glue is ranked 1st in Cloud Data Integration with 37 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews. AWS Glue is rated 7.8, while Oracle Data Integrator (ODI) is rated 8.2. The top reviewer of AWS Glue writes "Provides serverless mechanism, easy data transformation and automated infrastructure management". On the other hand, the top reviewer of Oracle Data Integrator (ODI) writes "Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved". AWS Glue is most compared with AWS Database Migration Service, Informatica PowerCenter, SSIS, Informatica Cloud Data Integration and Matillion ETL, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Informatica PowerCenter, Azure Data Factory and IBM InfoSphere DataStage. See our AWS Glue vs. Oracle Data Integrator (ODI) report.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.