We performed a comparison between AWS Database Migration Service, Jitterbit Harmony , 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 most valuable feature of the solution is the one I use for report generation. The security risk is very low."
"It's pretty useful when we need to migrate something big from a different type of database that AWS Data Migration Services supports."
"The tools are very user-friendly."
"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."
"Scalable and stable solution for migrating databases to AWS, with valuable features such as parallel full load and continuous data replication."
"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."
"This solution is very good at mini-batch processing."
"It runs like an appliance and has tremendous throughput."
"We only use small parts of the solution, however, the parts that we use are quite adequate."
"The Cloud Console for monitoring and troubleshooting data operations."
"The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"Jitterbit handles the most lines of data in a .csv and loads the quickest of any data loader I have tried."
"Jitterbit provides the ability to quickly map data between files and databases."
"It is a scalable solution."
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."
"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."
"The most valuable feature of Matillion ETL is the ETL. The solution is open-source which provides advantages, such as good performance and high efficiency. Additionally, it supports three data types which eliminates predefining the data, and we can write script models in Python."
"The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand."
"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."
"It's been able to do everything we require."
"The loading of data is the most valuable feature of Matillion ETL."
"The product's initial setup phase was easy."
"There are a set of complexities and challenges when a user wants to integrate AWS products with Microsoft products."
"This solution can offer more tweaks where the latency can be brought down to fifteen seconds."
"The performance of data migration could be smoother."
"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."
"This solution is compatible with only AWS."
"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."
"Whatever solution worked today can not be reused in the next migration."
"Looping through complex data structures can be difficult."
"There were some bugs in the product. For example if you run a delete query and test, it deletes the actual data."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"I would like the ability to offer a dedicated cloud version for security."
"The initial setup can be a little bit difficult."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"In the next release, we would like to have connections to more databases."
"The product must enhance its near-real-time data capture feature."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."
"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."
"Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more."
"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 cost of the solution is high and could be reduced."
More AWS Database Migration Service Pricing and Cost Advice →
