Denodo and AWS Database Migration Service compete in the data integration and virtualization market. Denodo holds an advantage in terms of robust data virtualization capabilities.
Features: Denodo is known for its strong data virtualization, ease of data integration from various sources, and advanced features like data cataloging and lineage. AWS Database Migration Service provides effective cloud-based solutions, real-time data synchronization, and backup automation for simplified database migrations.
Room for Improvement: Denodo requires enhancements in data catalog functionalities, documentation, and support services. AWS Database Migration Service needs improved endpoint support, transparency, and more competitive pricing for non-AWS integrations.
Ease of Deployment and Customer Service: Denodo supports on-premises and hybrid cloud environments, with generally reliable support but occasional delays. AWS focuses on public cloud use and benefits from close alignment with its tech support, although clearer initial configuration guidance could be beneficial.
Pricing and ROI: Denodo is costly with licensing and CPU usage fees but offers valuable ROI by improving data processing times. AWS Database Migration Service is more affordable, reducing operational costs over on-premises solutions, but users seek further price reductions for broader appeal.
I can specify savings of around 40 to 60%.
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.
They have a good methodology for learning how to use the tool.
Denodo's customer support team is very competent and responsive.
If we raise a ticket, it can be resolved or addressed within a reasonable time frame, so support is good.
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.
For huge data requests, it cannot scale automatically; admin action is required.
While the solution scales well on a single machine, I have doubts about its scalability when deployed as part of a Java component cluster.
Its complexity in configuring and the requirement to install different connectors for different sources affects its scalability.
For DMS version upgrades, we schedule downtime during business hours so that midnight workloads are not interrupted and morning business can run smoothly.
I would rate it nine out of ten because it is very reliable, always performing as expected.
If JVM does not function properly, it may cause Denodo to fail to connect to different sources.
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.
Ensuring data caching is up to date is critical.
Denodo needs better communication on how the product can be deployed for specific solutions.
The system has dependencies on other environments, like JVM, which can affect its performance.
Denodo is considered pricey, limiting its use to large enterprises or government organizations that can afford its comprehensive setup.
Denodo's pricing is not affordable for small companies and is more suitable for medium to large enterprises.
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.
Denodo's ability to connect to multiple data sources and perform extract-transform-load (ETL) operations on the fly is noteworthy.
The most valuable feature of Denodo is its uniformity of self-site data access types, which allows it to connect to almost any storage technology and feed it transparently.
Denodo supports SQL base, so if you want to join two tables or two views, you can use SQL, which is an advantage as most developers or business people know SQL.
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.
Denodo is a leading data integration, management, and delivery platform that uses a logical approach to enable data science, hybrid and multi-cloud data integration, self-service BI, and enterprise data services. Organizations of different sizes across various industries utilize the product to get above the data silos. The solution offers organizations the freedom to migrate data to the cloud, or logically unify data warehouses and data lakes, without affecting business. This can ultimately result in the evolution of data strategies.
The platform accelerates data provisioning through reduced data replication, provides business users the freedom to select their preferred applications, and enables consistent security and governance across multiple systems. The solution offers one of the leading logical data fabric solutions by initiating data virtualization and eliminating the complexity and exposing the data in business-friendly formats.
Denodo also offers modern data integration and management for hybrid and multi-cloud environments for Denodo Platform for Cloud. This service can be purchased through the bring-your-own-license (BYOL) option. Users seeking faster deployment can license the product to popular cloud providers, including Amazon AWS, Google Cloud Platform, and Microsoft Azure. The solution integrates, manages, and delivers data in complex environments with high performance, governance, and security. It also offers additional solutions, such as the Denodo Platform for Cloud Modernization, the Denodo Platform for Cloud Data Integration, and the Denodo Platform for Cloud Analytics, which overcome common cloud data challenges.
Denodo Features
At the beginning of 2022, version 8.0 of Denodo introduced several new key features of the platform. These include:
Denodo Benefits
Denodo offers various benefits for its users through its services. Some of the greatest advantages of using this platform include:
Reviews from Real Users
Naresh M., a senior application developer at a financial services firm, appreciates Denodo because it offers quick and simple web services creation.
Alisson M., a senior BigData DevOps engineer at Schaeffler, says that Denodo is great for queries and scouting data.
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.