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."Its user interface is quite good. You just need to choose some options to create a job in AWS Glue. The code-generation feature is also useful. If you don't want to customize it and simply want to read a file and store the data in the database, it can generate the code for you."
"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."
"The most valuable feature of AWS Glue is that it provides a GUI format with a drag-and-drop feature."
"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's best features are scalability and cloud-based features."
"The solution's technical support is good. Whenever we raise a use case where we face an issue in our company, we get a response from the solution's technical team."
"The most valuable features currently are glue studio, jobs, and triggers."
"It is a stable and scalable solution."
"Besides loading data, we do most of our transformations in ODI."
"The most valuable feature is Data movement."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The scalability is great. It's one of the reasons we chose the solution."
"The product has an ELT approach."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"It's completely user-friendly."
"The solution should offer features for streaming data in addition to batching data."
"The product has only a few built-in transformations."
"On occasion, the solution's dashboard reports that a project failed due to runtime but it actually succeeded."
"The mapping area and the use of the data catalog from Glue could be better."
"The price of the solution could improve."
"The solution's visual ETL tool is of no use for actual implementation."
"We face performance issues when using AWS Glue for data transformation and integration."
"AWS Glue is more costly compared to other tools like Airflow."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"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."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"If you have something like Cisco on top of it, you will have endless problems."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"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."
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.