We performed a comparison between AWS Database Migration Service, Boomi AtomSphere Integration, and Informatica Cloud Data Integration 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."What I like about AWS Database Migration Service is that it's a good product that allows you to migrate terabytes of data. My team was able to migrate almost 16TB of data using AWS Database Migration Service. The solution works fine for my use case."
"Even if it does break down, it will automatically recover itself and resumes from where it stopped."
"The database migration services allow us to do real-time synchronization of on-premise and database to plan out our releases."
"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."
"The solution is stable and reliable."
"Scalable and stable solution for migrating databases to AWS, with valuable features such as parallel full load and continuous data replication."
"The product's initial setup phase was very easy."
"I am very impressed by the scalability of AWS Database Migration Service."
"The most valuable feature of the solution is its monitoring part to debug certain issues and find problems."
"I really appreciate the on-the-go access through the browser and the B2B integration."
"It is easy to learn and implement."
"This is a fairly easy-to-use tool for integration which can be self-taught for those with a bit of a technical background."
"It's very user-friendly and designed to be easy to use for the end user."
"This solution has a user-friendly interface and very good documentation with solutions that helped us in working with the tool efficiently."
"The iPaaS functionality is very mature. The browser based IDE is also very mature and stable."
"It is a low-code and high-configuration platform, which is very valuable. Develop once and run anywhere is another useful feature. It also has connectors for more than 200 applications. It provides value for money. Our customers who have implemented this solution have a very high ROI."
"We have a lot of integrations, and it's very easy to create integrations. They have a lot of connectors."
"The support is very good."
"The solution's initial setup is quite straightforward."
"The program is stable and scalable."
"It has a more UI-based tool, and the scripting is good."
"Data synchronization tasks."
"The Mapping Designer allows for declarative ETL development (visual scripting) that leverages a wide array of different transformations."
"Their new licensing is very flexible. With Informatica Cloud, you have plenty of items under the same umbrella, such as services, offerings, data quality, and data masking. You have also got master data management and API management. What I really like about them is that you don't need to go to Informatica and say that you need a data integration module. You would say that you need iPaaS or Informatica Cloud. They'll then try to understand your needs and give you IPUs, which are the processing units. If I purchased a hundred IPUs from Informatica as a customer, I can use 70 IPUs for data integration. I would also need data quality, so I can use 10 IPUs for data quality. I can use the remaining 20 IPUs for API management. Down the line, if I see that my initial data integration needs for the development phase are met, then out of the 70 IPUs assigned for data integration, I can use 30 IPUs for data masking. I can shuffle these numbers in any way within the Informatica Cloud umbrella for the tenure for which I have subscribed to these IPUs. I can use all services the way I want. This flexibility is what I really love about Informatica. It also has got good connectors."
"As a solution, the better thing is if more platforms come with direct compatibility, like connecting to different data sources. The basic problem I faced the most was while transferring and reading data from Excel. So, one time, I found that all the components I had declared in my scripts were able to take it. And after some patching happens, it is not able to support that. Again, we need to update the version of Excel. So, it's not like a plug-in type place where you have done the solution and are confident that it will work. So, this is an area of improvement."
"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."
"We would like to see some improvement in the performance of large scale procedures, such as when we migrate from Oracle to csSQL."
"One area that AWS DMS can improve on is its conversion of data types. For example, in Oracle, you have a data type called RAW, but in PostgreSQL there is no such thing. Thus, AWS DMS doesn't know what type I want to use when migrating from Oracle to PostgreSQL, and when performing the migration, AWS DMS changed the RAW data type to the byte data type, which isn't what I wanted."
"This solution is compatible with only AWS."
"Support could be more expedient. Right now I am waiting on support for an extension."
"The initial setup can be difficult for beginners in AWS Database Migration Service. You will need the training to complete it."
"There are still some areas that need improvement. For example, when updates are going on, the product becomes very slow."
"There should be more scripting possibilities."
"Lots of enhancements are needed in the API portal so that the developers can view the definitions, try out the APIs, etc."
"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."
"Documentation could be improved."
"There are very few string handling functions and few mathematical functions are available."
"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."
"They need to introduce more configurable functions to remove scripting or coding. Scripting should be minimized. It should have exhaustive functions. Currently, it lacks in this aspect."
"A general improvement in icons and the virtual interface would be good."
"The biggest challenge I see is the IDE's for the cloud and automization are different."
"With the solution, we had some issues, and we have every day, and we used to open a ticket. Sometimes, there are data issues and transformation issues."
"The vendor should have more training resources: online classes, free tutorial videos, etc."
"Error reporting and debugging need improvement."
"It needs to be a little more intuitive but it’s really not bad."
"Connectivity could be improved, it can be a little slow."
"Its features for partitioning and optimization could be better."
More AWS Database Migration Service Pricing and Cost Advice →
More Informatica Cloud Data Integration Pricing and Cost Advice →