AWS Database Migration Service and AWS Glue operate in the field of data management and transformation within the AWS ecosystem. AWS Glue holds an advantage with its comprehensive integration and ETL features, making it suitable for complex workflows, despite AWS Database Migration Service's appealing simplicity and cost.
Features: AWS Database Migration Service provides essential database migration capabilities, such as minimal downtime, automatic failovers, and reliable service stability. AWS Glue offers advanced ETL capabilities, extensive integration with AWS services, and a robust data cataloging system, positioning it for complex data workflows.
Room for Improvement: AWS Database Migration Service could benefit from enhanced flexibility for custom migration requirements and expanded support for additional database systems. AWS Glue would improve from simplifying its initial setup process and offering cost-effective solutions for smaller-scale operations.
Ease of Deployment and Customer Service: AWS Database Migration Service is praised for its straightforward deployment and configuration, simplifying database transitions. AWS Glue offers extensive automation but has a steeper learning curve. Both services provide strong customer support, but the simplicity of AWS Database Migration Service makes it more user-friendly initially.
Pricing and ROI: AWS Database Migration Service is typically more cost-effective for straightforward database migrations due to its pay-as-you-go pricing model. AWS Glue may involve higher costs due to its extensive features but offers significant ROI for data transformation and preparation needs. Pricing varies based on specific usage scenarios, making the choice largely dependent on the complexity and scale of the workload involved.
I can specify savings of around 40 to 60%.
I advocate using Glue in such cases.
When working with AWS GovCloud, we often did not get an answer in time because AWS seemed more focused on the commercial side.
I am happy with the technical support from AWS.
Upgrades occur every four months, and new developments coincide with version updates.
Even if there was a failure, we could catch it and rerun it.
AWS's scalable nature involves a human approach, meaning it is not auto-scalable.
While scalability is good, latency exists due to our business nature.
It is beneficial to upgrade jobs, and we conduct extensive testing in development before migrating to production.
It can easily handle data from one terabyte to 100 terabytes or more, scaling nicely with larger datasets.
For DMS version upgrades, we schedule downtime during business hours so that midnight workloads are not interrupted and morning business can run smoothly.
AWS Glue is highly stable, and I would rate its stability as nine.
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.
Migrating jobs from version 3.0 to 4.0 can present compatibility issues.
With AWS, I gather data from multiple sources, clean it up, normalize it, de-duplicate it, and make it presentable.
A more user-friendly and simpler process would help speed up the deployment process.
Costing depends on resource usage, and cost optimization may involve redesigning jobs for flexibility.
AWS charges based on runtime, which can be quite pricey.
The smallest cost for a project is around €700, while the largest can reach up to €7,000 based on the scale of the usage.
AWS offers a way to build jobs that are scalable, expandable for new and current tables, and can be deployed quickly.
You can copy the database at first without impacting your current database, and then use CDC to copy incremental changes.
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.
For ETL, I feel the performance is excellent. If I create jobs in a standard way, the performance is great, and maintenance is also seamless.
AWS Glue's most valuable features include its transformation capabilities, which provide data quality and shape for processing in ML or AI models.
I think if I'm working with big data, common languages like Python work quite nicely, which is advantageous.
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.
AWS Glue is a serverless cloud data integration tool that facilitates the discovery, preparation, movement, and integration of data from multiple sources for machine learning (ML), analytics, and application development. The solution includes additional productivity and data ops tooling for running jobs, implementing business workflows, and authoring.
AWS Glue allows users to connect to more than 70 diverse data sources and manage data in a centralized data catalog. The solution facilitates visual creation, running, and monitoring of extract, transform, and load (ETL) pipelines to load data into users' data lakes. This Amazon product seamlessly integrates with other native applications of the brand and allows users to search and query cataloged data using Amazon EMR, Amazon Athena, and Amazon Redshift Spectrum.
The solution also utilizes application programming interface (API) operations to transform users' data, create runtime logs, store job logic, and create notifications for monitoring job runs. The console of AWS Glue connects all of these services into a managed application, facilitating the monitoring and operational processes. The solution also performs provisioning and management of the resources required to run users' workloads in order to minimize manual work time for organizations.
AWS Glue Features
AWS Glue groups its features into four categories - discover, prepare, integrate, and transform. Within those groups are the following features:
AWS Glue Benefits
AWS Glue offers a wide range of benefits for its users. These benefits include:
Reviews from Real Users
Mustapha A., a cloud data engineer at Jems Groupe, likes AWS Glue because it is a product that is great for serverless data transformations.
Liana I., CEO at Quark Technologies SRL, describes AWS Glue as a highly scalable, reliable, and beneficial pay-as-you-go pricing model.
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.