We performed a comparison between AWS Database Migration Service, Informatica Cloud Data Integration, and Matillion ETL 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."For our simple requirement of migration, DMS is just a typical AWS RDS with an IPSec tunnel to Oracle. The most valuable features for us are the networking capabilities like VPCs and VPNs."
"The database migration services allow us to do real-time synchronization of on-premise and database to plan out our releases."
"The solution is stable and reliable."
"The installation is easy."
"The fact that it's well-integrated into multiple targets that are good for different use cases is pretty good."
"As the solution is on the cloud, we don't have to worry about the maintenance of software."
"I am very impressed by the scalability of AWS Database Migration Service."
"The initial setup is very straightforward."
"Data integration is the most valuable feature. The ability to connect to any of the sources and enterprise applications makes our lives easier."
"Data synchronization tasks."
"The solution has the best feature for parameterization."
"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 features I find most valuable is the synchronization, verification, functionalities and all the data integration features."
"The user interface which is very easy to use if we have any problems to solve."
"Informatica Cloud Data Integration is stable."
"Replication allows us to fully replicate all objects from Shop Floor Data Collection (SFDC) to in-house/on-premises database in one job."
"The loading of data is the most valuable feature of Matillion ETL."
"It has good integrations with Amazon Redshift and other AWS services."
"It has helped us to get onto the cloud quickly."
"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."
"Matillion ETL has great Git integration that is perfect and convenient to use."
"It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."
"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."
"The most valuable feature of Matillion ETL is its ease of use. If you have had some experience with other solutions, such as Snowflake, the use of this solution will be simple."
"The product's performance could be a little bit better."
"The cost is a concern. We use DMS because of its simplicity, but the price could definitely be more competitive."
"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."
"The way that the task settings work, specifically for logging, is really poor."
"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 can offer more tweaks where the latency can be brought down to fifteen seconds."
"We would like to see some improvement in the performance of large scale procedures, such as when we migrate from Oracle to csSQL."
"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 cloud version could be better in terms of pricing."
"There may be some types of limitations with the performance."
"The error information provided is not informative, as compared to Power Center."
"The current features are a bit complicated, and we need to write big scripts and test."
"User/group administration could use improvement."
"I would like to see more functionality added so that it is a bit closer to how much you can do with Informatica PowerCenter."
"Certain shortcomings in the product's UI make it an area where improvements are required."
"The integration process is not easy."
"The cost of the solution is high and could be reduced."
"In the next release, we would like to have connections to more databases."
"Matillion’s on-premises capabilities don’t allow you to build something customized."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"When using the SQL loader type there were not a lot of pre-processing features for the data. For example, if there is a table with twenty columns, but we only want to load ten columns. In that case, we can use a security script to select the specific columns needed. However, if we want to perform extensive pre-processing of the data, I faced some challenges with Matillion ETL. I did not encounter many challenges, but my overall experience is limited as I only have three years of experience."
"The product must enhance its near-real-time data capture feature."
"There are certain functions that are available in other ETL tools which are still not present in Matillion ETL. It would be good to have more features."
"Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level."
More AWS Database Migration Service Pricing and Cost Advice →
More Informatica Cloud Data Integration Pricing and Cost Advice →
