AWS Database Migration Service vs Matillion ETL comparison

Amazon Web Services (AWS) and Matillion are both solutions in the Cloud Data Integration category. Amazon Web Services (AWS) is ranked #2 with an average rating of 8.2, while Matillion is ranked #5 with an average rating of 8.4. Amazon Web Services (AWS) holds a 21.0% mindshare in CDI, compared to Matillion’s 4.1% mindshare. Additionally, 93% of Amazon Web Services (AWS) users are willing to recommend the solution, compared to 96% of Matillion users who would recommend it.

AWS Database Migration Service

Read 31 AWS Database Migration Service reviews

5,920 Views
4,932 Comparison Views

93% willing to recommend

Matillion ETL

Read 26 Matillion ETL reviews

1,941 Views
1,340 Comparison Views

96% willing to recommend

AWS Database Migration Service

Matillion ETL

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 3, 2024

Matillion ETL and AWS Database Migration Service compete in the data integration and migration market. Matillion ETL stands out due to its seamless AWS integration and wide-table handling capabilities, while AWS Database Migration Service excels in stability and cost-effectiveness, especially for large-scale data within AWS.

Features: Matillion ETL is known for its scheduling capabilities, built-in verification, and agile project management, particularly excelling in wide table imports like those from Salesforce. Additionally, it offers seamless integration with AWS services and supports various data sources. AWS Database Migration Service offers stability, is user-friendly, and features strong real-time replication, suitable for large data migrations within AWS ecosystems.

Room for Improvement: Matillion ETL could enhance integration capabilities for a more end-to-end solution, offer frequent updates for third-party API changes, and improve user documentation. AWS Database Migration Service could expand support beyond AWS ecosystems, add more integration options, and simplify configuration for non-standard AWS formats. Better error messaging and troubleshooting would benefit users.

Ease of Deployment and Customer Service: Matillion ETL, primarily deployed in public clouds, offers flexibility and strong, responsive technical support with comprehensive documentation. AWS Database Migration Service, offering on-premises, hybrid, private, and public cloud deployment, is versatile and is praised for its excellent customer service, indicating strong user satisfaction.

Pricing and ROI: Matillion ETL operates on a pay-as-you-go model linked to the virtual machine size and data team, offering flexibility despite initial higher costs. It's acknowledged for value in large data processing. AWS Database Migration Service is generally less expensive, especially for simple migrations, but cost varies with bandwidth needs, providing savings over competitors and faster ROI.

To learn more, read our detailed AWS Database Migration Service vs. Matillion ETL Report (Updated: January 2025).

Buyer's Guide

AWS Database Migration Service vs. Matillion ETL

January 2025

Download the complete report

Helped 831,020 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

AWS Database Migration Service

Ranking in Cloud Data Integration

2nd

Average Rating

8.0

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

No ranking in other categories

Matillion ETL

Ranking in Cloud Data Integration

5th

Average Rating

8.4

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of January 2025, in the Cloud Data Integration category, the mindshare of AWS Database Migration Service is 21.0%, down from 21.2% compared to the previous year. The mindshare of Matillion ETL is 4.1%, down from 5.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Cloud Data Integration

Featured Reviews

StevenLai

Sr. Data Engineer at Amrock

Straightforward to set up with easy of capturing database changes and secure storage

Sometimes we encounter errors, and the error messages from DMS are very ambiguous and sometimes misleading. For example, if we connect to an incorrect instance with incorrect setups, it will not say the connection failed. Instead, it says the DMS task failed with an unclear error message like 'subtask AWS failed', which does not help. The connection should fail if we are connecting to the wrong instance, but the endpoint connection still succeeds.

Read full review

Tomáš Hronek

Data Engineer at Merck

Used for wrangling or transforming data from sources like S3 and Databricks

I use Matillion ETL for wrangling or transforming data from sources like S3 and Databricks The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation. Sometimes, we have issues with the solution's stability and need to restart it for…

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"The initial setup is simple. Not that much complex."

"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."

"I like that I can focus on the logic and I don't have to worry about the administration stuff. AWS handles that for me."

"This solution is very good at mini-batch processing."

"I am very impressed by the scalability of AWS Database Migration Service."

"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 product's initial setup phase was very easy."

"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."

More AWS Database Migration Service pros

"The product has a good user interface."

"Matillion ETL has great Git integration that is perfect and convenient to use."

"The simplicity of this tool is nice. It has a good graphical user interface. You can also do a lot of generic stuff in the tool. If there is good connectivity to a cloud database, such as Snowflake, and you can have a lot of Snowflake functionality in the tool."

"The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand."

"It has improved the costs of managing my customer’s data."

"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."

"The loading of data is the most valuable feature of Matillion ETL."

"The product's initial setup phase was easy."

More Matillion ETL pros

Cons

"The initial setup can be difficult for beginners in AWS Database Migration Service. You will need the training to complete it."

"This solution can offer more tweaks where the latency can be brought down to fifteen seconds."

"There could be enhancements in the product intelligently covering more scenarios to prevent crashes or failures."

"The solution’s scalability and performance could be improved."

"The cost is a concern. We use DMS because of its simplicity, but the price could definitely be more competitive."

"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."

"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."

"Sometimes, the migration processes are not manageable"

More AWS Database Migration Service cons

"In the next release, we would like to have connections to more databases."

"While the UI is good, it could be improved in its efficiency and made easier to use."

"The improvement area could be possible if the tool provides better integration capabilities with other ecosystems, including governance tools or data cataloging tools, as it is currently an area where the solution is lacking."

"One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems."

"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."

"It needs integration with more data sources."

"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."

More Matillion ETL cons

Pricing and Cost Advice

"AWS Database Migration Service is very inexpensive."

"I would rate the pricing a seven out of ten."

"The pricing is on the higher side."

"In terms of pricing, I'd rate it an eight out of ten, considering it's a well-priced solution."

"Pricing can be improved."

"The product is pretty expensive"

"Pricing for the solution is reasonable, but could still be reduced."

"The solution’s pricing is reasonable."

More AWS Database Migration Service pricing and cost advice

"It is not necessarily a cheap solution. However, it's reasonable priced, especially with the smaller machines that we run it on."

"The product must improve its pricing."

"It is cost-effective. Based on our use case, it's efficient and cheap. It saves a lot of money and our upfront costs are less."

"I have heard from my manager and other higher ups, "This product is cheaper than other things on the market," and they have done the research."

"The pricing depends on what edition the customer opts for. For example, the standard edition is priced at $2.00 per credit. And you are only charged when you use it. You're not charged when it's idle."

"The prices needs to be lower."

"The solution is very cheap. You're paying $2.50 an hour and if you set your service up, which you can do, you're not getting charged. Currently, our ETL process is just an overnight process that runs for about an hour. I can start and stop my server just for an hour if I want to and spent $2.50 a day for an ETL solution. There are no additional costs."

"Its price depends on what you expect. You pay on a monthly basis, but there is a possibility to have special contracts depending on the installation."

More Matillion ETL pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.

See recommendations

831,020 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

21%

Computer Software Company

15%

Manufacturing Company

Government

Financial Services Firm

17%

Computer Software Company

14%

Manufacturing Company

Government

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What resources can you use to learn how to utilize AWS Database Migration Service?

As with all AWS products, you are given very useful documentation with AWS Database Migration Service. Before we started using this product, we went over it and we were able to learn the basics an...

See all answers

Would you recommend AWS Database Migration Service as a cloud data integration tool?

My current company started using AWS Database Migration Service upon my recommendation, and I continue telling people how good of a product it is. However, users should keep in mind a few things. ...

See all answers

Is AWS Database Migration Service an affordable solution?

Compared to similar solutions, AWS Database Migration Service falls somewhere in the middle price-wise, at least from my experience. This being said, it is not a very affordable solution, especial...

See all answers

What do you like most about Matillion ETL?

The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.

See all answers

What is your experience regarding pricing and costs for Matillion ETL?

The solution's pricing is not based on the licensing cost but on the running hours when the Matillion instance is up and running. Its pricing model is different from the traditional pricing models ...

See all answers

What needs improvement with Matillion ETL?

Depending on the use case, the solution's pricing could be improved. Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems.

See all answers

Comparisons

AWS Glue vs AWS Database Migration Service

Compared 47% of the time

Oracle GoldenGate vs AWS Database Migration Service

Compared 14% of the time

Qlik Replicate vs AWS Database Migration Service

Compared 11% of the time

Fivetran vs AWS Database Migration Service

Compared 8% of the time

JumpMind SymmetricDS vs AWS Database Migration Service

Compared 1% of the time

More AWS Database Migration Service Competitors

Azure Data Factory vs Matillion ETL

Compared 14% of the time

SSIS vs Matillion ETL

Compared 10% of the time

AWS Glue vs Matillion ETL

Compared 10% of the time

Snowflake vs Matillion ETL

Compared 8% of the time

Informatica PowerCenter vs Matillion ETL

Compared 6% of the time

More Matillion ETL Competitors

Product Reports

Buyer's Guide

AWS Database Migration Service

January 2025

Download AWS Database Migration Service product report

Buyer's Guide

Matillion ETL

December 2024

Download Matillion ETL product report

Also Known As

AWS Data Migration Service

Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery

Learn More

Amazon Web Services (AWS)

Matillion

Overview

AWS Database Migration Service, also known as AWS DMS, is a cloud service that facilitates the migration of relational databases, NoSQL databases, data warehouses, and other types of data stores. The product can be used to migrate users' data into the AWS Cloud or between combinations of on-premises and cloud setups. The solution allows migration between a wide variety of sources and target endpoints; the only requirement is that one of the endpoints has to be an AWS service. AWS DMS cannot be used to migrate from an on-premises database to another on-premises database.

AWS Database Migration Service allows users to perform one-time migrations, as well as replications of ongoing changes to keep sources and targets in sync. Organizations can utilize the AWS Schema Conversion Tool to translate their database schema to a new platform and then use AWS DMS to migrate the data. The product offers cost efficiency as a part of the AWS Cloud, as well as speed to market, flexibility, and security.

The main use cases of AWS Database Migration Service include:

Migrating from legacy or on-premises databases to managed cloud services through a simplified migration process.
Reliable replication of backup files to minimize downtime and data loss.
Improvement of integration through building of data lakes and performing real-time processing on change data from users' data stores.

AWS Database Migration Service Components

AWS Database Migration Service consists of various components which function together to achieve users’ data migration. A migration on AWS DMS is structured in three levels: a replication instance, source and target endpoints, and a replication task. The components include the following actions:

Replication instance: AWS Database Migration Service provides users with a variety of replication instances, allowing them to select the optimal configuration for their use case. Depending on the instance class an organization selects, their replication instance provides a different amount of data storage.
Endpoint: AWS DMS uses an endpoint to access users' source or target data stores. The connection information is different and depends on the specific data store, but it usually consists of the following information: endpoint type, engine type, server name, port, encryption, and credentials. This information can easily be managed through the AWS DMS console.
Replication tasks: AWS Database Migration Service replication tasks can be used to move a set of data from the source endpoint to the target endpoint. The creation of a replication task is the last required step before starting a migration. Each replication task requires the following settings to be set: replication instance, source endpoint, target endpoint, and migration type options.
Ongoing replication or change data capture (CDC): AWS DMS also has the capacity to capture ongoing changes to the source that is stored while users migrate their data to a target.
Schema and code migration: The product requires assistance from tools such as MySQL Workbench, pgAdmin III, and Oracle SQL Developer to perform schema or code conversion, as it cannot do it on its own.

AWS Database Migration Service Benefits

AWS Database Migration Service offers its users a wide range of benefits. Among them are the following:

The solution ensures minimal downtime, as it continuously replicates the changes to the user’s source database during migration.
AWS DMS provides users with flexibility, as it supports many commonly used databases, including commercial and open-source ones.
The product is user friendly, as it offers an easy set of tasks in the AWS Management Console.
Users of Aurora, Redshift, DocumentDB, and DynamoDB can benefit from the free use of AWS DMS.
AWS Database Migration Service is very reliable because it is a self-healing service that automatically restarts in cases of interruptions.
The product supports both homogenous migrations and heterogenous migrations.
AWS DMS accelerates business growth, as it scales businesses at an affordable price.

Reviews from Real Users

Vishal S., an infrastructure lead at a computer software company, likes AWS Database Migration Service because it is easy to use and set up.

Vinod K., a data analyst at AIMLEAP, describes AWS DMS as an easy solution to save and extract data.

Matillion ETL is a powerful tool for extracting, transforming, and loading large amounts of data from various sources into cloud data warehouses like Snowflake. Its ability to load data dynamically and efficiently using metadata is a standout feature, as is its open-source ETL with good performance and high efficiency.

The solution has a graphical interface for jobs, is easily adjustable and extensible, and allows for scheduling and error reporting. Matillion ETL has helped organizations move to a cloud-based solution, bridge the gap between on-premises and on-cloud, and perform complex migration projects.

Sample Customers

Veoci, Trimble, Nasdaq, shaadi.com, Hotelbeds, SysAid, Verizon, Expedia, Pega

Thrive Market, MarketBot, PWC, Axtria, Field Nation, GE, Superdry, Quantcast, Lightbox, EDF Energy, Finn Air, IPRO, Twist, Penn National Gaming Inc

Buyer's Guide

AWS Database Migration Service vs. Matillion ETL

January 2025

Free Report: AWS Database Migration Service vs. Matillion ETL

Find out what your peers are saying about AWS Database Migration Service vs. Matillion ETL and other solutions. Updated: January 2025.

DOWNLOAD NOW

831,020 professionals have used our research since 2012.

See our AWS Database Migration Service vs. Matillion ETL report.

See our list of best Cloud Data Integration vendors.

We monitor all Cloud Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.