We performed a comparison between AWS Database Migration Service, Informatica Cloud Data Integration, and Zapier 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."It's pretty useful when we need to migrate something big from a different type of database that AWS Data Migration Services supports."
"This solution is very good at mini-batch processing."
"The database migration services allow us to do real-time synchronization of on-premise and database to plan out our releases."
"I am very impressed by the scalability of AWS Database Migration Service."
"If your infrastructure is already on Amazon, it simply makes the most sense to use a tool officially provided by them as an additional service, rather than having to rely on a third-party solution."
"The tools are very user-friendly."
"The most valuable feature of AWS Database Migration Service is it catches all the history changes, such as inset, observe, and delete. It tracks everything."
"The solution is instantaneous. We can launch the service and reduce the end number of manpower."
"Data integration is the most valuable feature. The ability to connect to any of the sources and enterprise applications makes our lives easier."
"The most valuable feature is the building of mockups and tasks."
"The solution's initial setup is quite straightforward."
"The features I find most valuable is the synchronization, verification, functionalities and all the data integration features."
"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."
"The support is very good."
"The solution is straightforward."
"I do a quite a lot of data transformations, and the fact that I can do them without changing any of my SQL queries from the code, using the inbuilt tools, is very helpful."
"The connection between Facebook lead forms and MailChimp integrations is the most valuable feature."
"Zapier is a really good tool for connecting multiple different platforms and data sources. For example, with Quickbase, I can easily integrate data from other sources like AWS or task-tracking platforms such as ClickUp or Asana."
"We find it effortless to set up. We really don't have to do anything other than finding the application in the Zapier catalog. And as long as the application has been re-integrated into Zapier, they're able to then just provide the connection details and hook it up."
"Zapier's interface, for me, is the solution's greatest value proposition. It is designed and developed for people who don't have a clue about what they're trying to do. It has a very user-friendly interface."
"The most valuable aspect of this solution is that it is very intuitive and has a very flat learning curve."
"The solution is a SaaS and does not require a complex setup."
"The product's initial setup phase was very easy."
"There are a few valuable features, like the stability that it comes with and also the number of features that it offers. I've used other services like Pabbly, but they don't offer similar numbers of applications that Zapier has or allows to integrate with – it's maximum."
"The cost is a concern. We use DMS because of its simplicity, but the price could definitely be more competitive."
"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."
"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."
"What needs improvement in AWS Database Migration Service is that it lacks a log file validation feature. If the solution could provide more details about a particular transaction, that would be helpful. The stability of AWS Database Migration Service for online CDC records also needs to be improved."
"This solution is compatible with only AWS."
"AWS Database Migration Service can become complex when testing. Other solutions, such as Microsoft Azure makes it easy to do. There are more steps to complete tasks in AWS Database Migration Service than in Microsoft Azure."
"If they had some sort of functionality where, at a specific point in time, if I want to start a new job, it should automatically pick up from where it has been left rather than having people worry about the exact job number and the timing."
"There is room for improvement at the highest level in terms of useability and connectors for various types of new applications. The row processing performance could be better because you experience some latency dealing with high volumes of data. Most organizations will be dealing with multiple cloud applications, so you could see performance issues moving from one system to another."
"User/group administration could use improvement."
"Its features for partitioning and optimization could be better."
"One area where Informatica Cloud Data Integration could improve is in providing more accelerators for certain functionalities."
"Certain shortcomings in the product's UI make it an area where improvements are required."
"The integration process is not easy."
"We would like to have accessibility to the repository."
"The error information provided is not informative, as compared to Power Center."
"Some recent changes to the solution have made it bulky and not as intuitive to use as it previously was."
"The user interface for Zapier could be improved. It also takes some time to sync the data between different environments."
"Zapier needs more YouTube or video tutorials or more training for people. That would help a lot. In particular, Zapier should have documentation for every connector. Its documentation needs to be more detailed and visual."
"It is not worth the money if you have a little bit of a technical mind...Zapier is not able to set up different modules. When automation doesn't work, it's not that easy to find why it didn't work."
"After mapping them out, and they'd worked for a while, I've had Zapier fail."
"Zapier needs to improve in the same way most RPA solutions should, such as Robocorp, Make, or UiPath. They are not good at helping you find the connections that you need for the problem that you have. For example, if need something on Instagram. I'm going to have to do research for hours to be able to find the components or the app, which is going to do what I need it to do. It makes it difficult to use the system when you don't know what to use."
"The solution does not work properly when we apply filters and we get errors."
"The pricing of the solution is quite expensive."
More AWS Database Migration Service Pricing and Cost Advice →
More Informatica Cloud Data Integration Pricing and Cost Advice →