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."AWS Glue is a good solution for developers, they have the ability to write code in different languages and other software."
"The solution is highly user-friendly, and its features are easy to use. The new addition of AWS Glue Data Catalog is also very beneficial, making the tool even more helpful for its users."
"AWS Glue is fast and managed by AWS. Hence, you don't have to worry about capacity and the performance of Glue jobs. It has integrations with other data stores of AWS. The product offers metadata management, logging, and ETL processing capabilities. It comes with a powerful feature, Glue Studio, which helps to do queries interactively within the community. It is a managed service and very secure. Another popular and mature service is S3."
"What I like best about AWS Glue is its real-time data backup feature. Last week, there was a production push, and what used to take almost ten days to send out around fifty-six thousand emails now takes only two hours."
"It is AWS-integrated. There is end-to-end integration with the other AWS services. It is also user-friendly."
"The most valuable feature of AWS Glue is that it provides a GUI format with a drag-and-drop feature."
"The most valuable feature of AWS Glue is its ease of use and good documentation. Additionally, we can do all the transformations that we need."
"Transformations are valuable because you can modify or override complex data logic from an open source or Spark to solve issues."
"It has the ability to easily load slowly changing dimensions."
"One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"The product has an ELT approach."
"The initial setup is easy."
"The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"The product is expensive for data streaming. This area needs improvement."
"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."
"It would be better if it were more user-friendly. The interesting thing we found is that it was a little strange at the beginning. The way Glue works is not very straightforward. After trying different things, for example, we used just the console to create jobs. Then we realized that things were not working as expected. After researching and learning more, we realized that even though the console creates the script for the ETL processes, you need to modify or write your own script in Spark to do everything you want it to do. For example, we are pulling data from our source database and our application database, which is in Aurora. From there, we are doing the ETL to transform the data and write the results into Redshift. But what was surprising is that it's almost like whatever you want to do, you can do it with Glue because you have the option to put together your own script. Even though there are many functionalities and many connections, you have the opportunity to write your own queries to do whatever transformations you need to do. It's a little deceiving that some options are supposed to work in a certain way when you set them up in the console, but then they are not exactly working the right way or not as expected. It would be better if they provided more examples and more documentation on options."
"The mapping area and the use of the data catalog from Glue could be better."
"I would like to see stable libraries at the moment they are not there."
"In terms of improvement, the performance of AWS Glue could be faster."
"Currently, it supports only two languages in the background: Python and Scala. From our customization point of view, it would be helpful if it can also support Java in the background."
"The solution should offer features for streaming data in addition to batching data."
"The performance of the user interface is in need of improvement."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"The solution lacks some functions and features."
"Stability could be improved because some operators have issues."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"It needs easier security."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"The initial setup is a bit complex compared to other tools."
AWS Glue is ranked 1st in Cloud Data Integration with 37 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 68 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, Informatica Cloud Data Integration, SSIS and IBM InfoSphere DataStage, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, Informatica PowerCenter, SSIS, Azure Data Factory and SAP Data Services. 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.