We performed a comparison between AWS Database Migration Service, Boomi AtomSphere Integration, and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration."The process is now simplified because there won't be maintenance. Usually we can take a snapshot of the number I need. We can automate the backup snapshots and we can restore it very quickly. We get many benefits from the application."
"We particularly like that this solution has the facility to integrate with all ETL tools."
"The initial setup is simple. Not that much complex."
"The installation is easy."
"The product's initial setup phase was very easy."
"The fact that it's well-integrated into multiple targets that are good for different use cases is pretty good."
"The tools are very user-friendly."
"The most valuable features of the AWS Database Migration Service are the ease of migration, beneficial storage system, security, and simple instance creation. Additionally, the cloud that is provided is more complete than other solutions."
"We work on the flow between systems and the most valuable features for that purpose are the mapping of data, interface mapping, and data integration."
"The solution has a lot of connectors, which is quite helpful."
"The most valuable feature of the solution is its monitoring part to debug certain issues and find problems."
"It is easy to learn and implement."
"This solution has a user-friendly interface and very good documentation with solutions that helped us in working with the tool efficiently."
"The product's initial setup phase was easy."
"It has been a stable product."
"The platform is user-friendly."
"It's completely user-friendly."
"The installation of the client ODI Studio is easy."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"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."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"The scalability is great. It's one of the reasons we chose the solution."
"Whatever solution worked today can not be reused in the next migration."
"Database Migration Service could be more integrated. I think that it makes sense to add integration to these functions. For example, AWS Glue has a feature called Orchestrator to create data flows, and that's more straightforward."
"The names of the services need improvement since AWS doesn't indicate what the function of the product is presently. You need to read a lot to find the service that you want in the product."
"The cost is a concern. We use DMS because of its simplicity, but the price could definitely be more competitive."
"The performance of data migration could be smoother."
"There are a set of complexities and challenges when a user wants to integrate AWS products with Microsoft products."
"Support could be more expedient. Right now I am waiting on support for an extension."
"The product's performance could be a little bit better."
"The solution is complex. There's a few items and features that are hard to understand. They should work to simplify the functionality so new users don't struggle."
"There is no validation in the mapping profile custom scripting, such as IntelliSense or advanced error checking."
"There are very few string handling functions and few mathematical functions are available."
"There are more mature (dedicated) API management and master data management (MDM) solutions available in the market."
"Have to create some of our own pre-built connectors."
"In day-to-day operations, tracking transactions is a major challenge. It takes hours to track a single transaction. It is not a straightforward process."
"The deployment was simple, but the implementation is missing a lot of capabilities."
"The API can use some work to come up to speed with the competition but Dell has plans and is working on resolving that."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"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 solution lacks some functions and features."
"The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"The resource management aspect of the solution could be improved."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
More AWS Database Migration Service Pricing and Cost Advice →