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."The initial setup is simple. Not that much complex."
"This solution is very good at mini-batch processing."
"Scalable and stable solution for migrating databases to AWS, with valuable features such as parallel full load and continuous data replication."
"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."
"It's pretty useful when we need to migrate something big from a different type of database that AWS Data Migration Services supports."
"I am very impressed by the scalability of AWS Database Migration Service."
"The most valuable feature of the solution is the one I use for report generation. The security risk is very low."
"The database migration services allow us to do real-time synchronization of on-premise and database to plan out our releases."
"Data integration is the most valuable feature. The ability to connect to any of the sources and enterprise applications makes our lives easier."
"It is one of the best tools available for data integration."
"The mass ingestion functionality and the elasticity of the solution are great."
"Informatica Cloud Data Integration is stable."
"It has a more UI-based tool, and the scripting is good."
"The program is stable and scalable."
"Replication allows us to fully replicate all objects from Shop Floor Data Collection (SFDC) to in-house/on-premises database in one job."
"The features I find most valuable is the synchronization, verification, functionalities and all the data integration features."
"The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand."
"It's been able to do everything we require."
"The product has a good user interface."
"The product's initial setup phase was easy."
"It has helped us to get onto the cloud quickly."
"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."
"Matillion ETL is one hundred percent stable."
"The technical support treats us well. They already have a support portal, and they are responsive, which helps."
"The initial setup can be difficult for beginners in AWS Database Migration Service. You will need the training to complete it."
"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."
"The server has limits on how many can connect to the database."
"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."
"The live duplication has a delay of two minutes, which can be an issue."
"Support could be more expedient. Right now I am waiting on support for an extension."
"Migrating from here and pushing the data from on-premise to AWS cloud is a big challenge and a few more services from AWS would be helpful. For example, we are currently using ILDB internet tools which move data from on-premise to the AWS cloud. A few more services would be really helpful for me to move the master data."
"User/group administration could use improvement."
"I would also like to have profiling functionalities and quality transformations in the cloud."
"I would like to see support for more data sources."
"The current features are a bit complicated, and we need to write big scripts and test."
"I would like to see more functionality added so that it is a bit closer to how much you can do with Informatica PowerCenter."
"Informatica Cloud Data Integration could improve the price by making it less expensive."
"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 biggest challenge I see is the IDE's for the cloud and automization are different."
"Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more."
"It can have multi-environment support. We should be able to deploy it in different environments. Its integration with SAP connection is not so nice, which should be improved. It can also support an on-prem database."
"Matillion’s on-premises capabilities don’t allow you to build something customized."
"The product must enhance its near-real-time data capture feature."
"Performance can be improved for efficiency, and it can be made faster."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"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."
"Unlike Snowflake which automatically takes care of upgrading to the latest version and includes additional features, with Matillion ETL we need to do this ourselves."
More AWS Database Migration Service Pricing and Cost Advice →
More Informatica Cloud Data Integration Pricing and Cost Advice →