Matillion Data Productivity Cloud and AWS Database Migration Service are competitors in the cloud data integration and migration market. AWS Database Migration Service appears to have an advantage due to its robust support for seamless data migration and real-time replication, which users find particularly beneficial.
Features: Matillion offers an extensive range of pre-built integrations, allowing rapid data import and effective AWS Redshift and Excel integration. Built-in verification and user-friendly design make it a preferred choice for data engineers. AWS Database Migration Service excels in supporting large-scale data migrations and easy integration within the AWS ecosystem, offering capabilities like live replication and schema transformation without the need for manual interventions.
Room for Improvement: Matillion needs more frequent API updates to match third-party changes, better database integration, and stronger marketing efforts. Enhanced UI flexibility and improved on-premises functionality would also benefit users. AWS Database Migration Service requires better data type conversion integration and clearer error messaging. Users suggest enhanced compatibility with non-AWS platforms and improved customer support to overcome operational challenges.
Ease of Deployment and Customer Service: Matillion provides effective public cloud deployment with proactive customer feedback systems supported by quick response times and detailed documentation. AWS Database Migration Service offers multiple deployment options catering to both public and private clouds. While AWS provides responsive customer service, users wish for improved tracking and resolution of complex issues.
Pricing and ROI: Matillion is priced based on team size, offering discounts for long-term commitments and provides value particularly for AWS users. AWS Database Migration Service's usage-based pricing is seen as fair though it could be more cost-effective in certain regions. Both solutions report fast ROI with substantial savings in operational and administrative expenses.
I can specify savings of around 40 to 60%.
Consequently, we adjusted our processes to use Matillion Data Productivity Cloud only for extraction and ingestion, while Snowflake handled all transformations and jobs.
I am happy with the technical support from AWS.
When working with AWS GovCloud, we often did not get an answer in time because AWS seemed more focused on the commercial side.
They communicate effectively and respond quickly to all inquiries.
Even if there was a failure, we could catch it and rerun it.
While scalability is good, latency exists due to our business nature.
AWS's scalable nature involves a human approach, meaning it is not auto-scalable.
The autoscale process works well, allowing the system to start another node automatically if the first machine reaches 80% capacity.
For DMS version upgrades, we schedule downtime during business hours so that midnight workloads are not interrupted and morning business can run smoothly.
DMS works within AWS ecosystem, but they also have to look for third party solutions. Now Snowflake is a bigger player, or Databricks.
Sometimes, those who implement the service face problems and resolve it, but I may not even know what problems they faced.
Connections to BigQuery for extracting information are complex.
Matillion Data Productivity Cloud offers discounts and special deals, especially when dealing with high-volume clients or fewer existing clients in specific regions, like Spain.
The scalability option is another valuable feature because AWS provides its own compute behind it, so I can scale up and scale down at any given point.
You can copy the database at first without impacting your current database, and then use CDC to copy incremental changes.
AWS offers a way to build jobs that are scalable, expandable for new and current tables, and can be deployed quickly.
Matillion Data Productivity Cloud is effective for ingest functions, particularly when moving information to Snowflake and performing many transformations.
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:
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:
AWS Database Migration Service Benefits
AWS Database Migration Service offers its users a wide range of benefits. Among them are the following:
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 Data Productivity Cloud features an intuitive graphical interface, seamless AWS integration, and efficient data management. Its tools streamline complex tasks for SFDC, RDS, Marketo, Facebook, and Google AdWords.
Matillion Data Productivity Cloud provides fast transformations with built-in verification, easy scheduling, and sampling. With automatic scalability and diverse data source support, it simplifies complex data tasks. Users benefit from cloud data warehousing and integrating data into Snowflake while appreciating its ease of use by non-technical teams. Enhancements can focus on frequent API adjustments, improved documentation, faster performance with less latency, and better error handling.
What are the key features of Matillion Data Productivity Cloud?
What benefits and ROI should users seek in reviews?
In industries such as technology, finance, and healthcare, Matillion Data Productivity Cloud is implemented to streamline ETL processes, optimize data pipeline construction, and enhance data migration efforts. It supports efficient data loading and integration between cloud and on-premises databases, aiding industries in managing data-driven projects.
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.