AWS Glue vs Denodo comparison

Read 34 Denodo reviews

1,661 Views
1,028 Comparison Views

94% willing to recommend

AWS Glue

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 3, 2024

Denodo and AWS Glue compete in the data integration and data virtualization category. Denodo appears to have an advantage in data virtualization and integration capabilities, while AWS Glue has the upper hand in seamless integration with AWS services and serverless capabilities.

Features: Denodo is preferred for its strong data virtualization features, allowing data abstraction and integration with multiple sources, including flat files and cloud databases, without moving data physically. AWS Glue stands out for its serverless architecture and smooth AWS services integration, offering a flexible data processing interface, efficient ETL features, and a robust data catalog.

Room for Improvement: Denodo users suggest enhancements in data catalog capabilities, improved connectivity, and better integration with metadata systems, alongside more comprehensive support and documentation. AWS Glue could benefit from improved user-friendliness, more intuitive documentation, and a smoother experience for non-technical users. Concerns include high costs, rigid pricing structure, and integration challenges with non-AWS tools.

Ease of Deployment and Customer Service: Denodo supports various deployment models such as on-premises, hybrid, and cloud, offering flexibility but sometimes faces integration challenges and mixed customer support reviews. AWS Glue excels in cloud environments and benefits from the AWS ecosystem, yet could improve in responsive support and ease of use for new AWS users. Its deployment is straightforward for existing AWS users but can present a learning curve for newcomers to AWS services.

Pricing and ROI: Denodo can be expensive and often structures pricing on CPU usage, posing predictability challenges, but offers ROI through improved processing times and decision-making abilities. AWS Glue's pay-as-you-go model supports scalability but may incur higher costs during peak usage, justifying expenses through efficient AWS integration. While ROI is visible in data processing, initial costs might be a hurdle for smaller businesses.

To learn more, read our detailed AWS Glue vs. Denodo Report (Updated: December 2024).

AWS Glue vs. Denodo

Download the complete report

Helped 824,053 peers since 2012

Categories and Ranking

AWS Glue

Ranking in Cloud Data Integration

1st

Average Rating

7.8

Reviews Sentiment

7.0

Number of Reviews

Ranking in other categories

No ranking in other categories

Denodo

Ranking in Cloud Data Integration

11th

Average Rating

8.0

Reviews Sentiment

7.0

Number of Reviews

Ranking in other categories

Data Integration (14th), Data Virtualization (1st)

Mindshare comparison

As of December 2024, in the Cloud Data Integration category, the mindshare of AWS Glue is 24.8%, up from 24.8% compared to the previous year. The mindshare of Denodo is 4.6%, up from 3.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Cloud Data Integration

Featured Reviews

Ajaykumar Myana

Senior Software Developer at a computer software company with 10,001+ employees

Provides serverless mechanism, easy data transformation and automated infrastructure management

We no longer had to worry much about infrastructure management because AWS Glue is serverless, and Amazon takes care of the underlying infrastructure. This allowed us to focus on the code and application logic without concerns about scaling, CPU management, or handling fluctuations in flow. The serverless nature of Glue jobs relieved us from these infrastructure-related worries.

Read full review

Dash Bibhuprasad

Lead Solution Architect at a insurance company with 10,001+ employees

Saves our underwriters' time with data virtualization, but could provide more learning resources

As a company, we first did a proof-of-concept for about four months to make sure the product was a perfect fit for us or not, and beyond that I have only used Denodo for another year or so, so I know that we haven't used the product to its fullest yet. Indeed, a lot of Denodo has changed since we had our first presentation on it with the Denodo sales team who gave us a rundown of all the features. Nevertheless, there are multiple ideas I could suggest in terms of improvement. First of all, the visualization and reporting could be better. Of course, the data virtualization is good, but the data visualization could be improved with regards to the real-time dashboarding of the graphs, pie charts, etc. For the real-time data, the dashboard should preferably be updated automatically every hour. Let's say, as a CEO or CFO, I just want to know how much premium the company will get at any hour of the day. This data should be readily available on the dashboard. This is largely why we stick with Power BI's dashboarding features (besides the simple fact that Power BI works well hand-in-hand with Azure), and why we still haven't used Denodo's data visualization features as much as the data virtualization features. Another area we have been struggling with is the integration of Denodo with both Salesforce and MuleSoft, which we use to track the customers in our sales system, such as when sending insurance quotes. When we first tried to integrate Salesforce, we found that there was some type of version incompatibility. We had a hard time talking with Salesforce about this, but eventually we upgraded our version and the integration was resolved. Yet, this was a challenge that I feel we didn't need to go through, as we were not able to quickly map out the issue. And with MuleSoft, we have not been able to integrate it properly at all. I have also seen our users complain about the availability of data sources, where they are sometimes not able to connect to all the sources they need. This kind of complaint, however, is difficult to diagnose, and I don't know for sure whether it is due to how we have Denodo set up in the company, or whether it's an actual issue with Denodo itself. These complaints were mainly made during the first few months of our usage, so it is possible that the problems stemmed from a lack of knowledge on how to use Denodo correctly, especially since the individual feedback would generally be something vague like, "Okay, I'm not able to do this". To help resolve these complaints, I would suggest that Denodo work on better documentation and perhaps some kind of virtual training. For example, there's an insurance software company called Guidewire, and when we first brought Guidewire into the company they sent us a lot of training videos even before the actual integration took place. For Denodo, it would be beneficial to make sure that the team that will be using it has some kind of training on how to use the product at least a month beforehand, and there could even be some kind of feedback or Q&A sessions to go along with the training. If Denodo were able to provide this kind of training, it would be very helpful to users in insurance and banking companies because the staff are typically older and not always technically-minded. They say, "You are pushing us too hard", so they need encouragement when it comes to adoption of a new software product.

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

"You do not need many frameworks to run Glue."

"The solution integrates well with other AWS products or services."

"The best thing about AWS Glue is its scalability and how easy it is to process a large amount of data."

"It is a stable and scalable solution."

"One aspect that I would like to highlight is the Glue Crawler, which we utilize when working with large datasets to ensure the schema updates seamlessly without requiring end-team knowledge."

"It's very good to manage."

"Data catalog and triggers are the two best features for me. AWS Glue has its own data catalog, which makes it great and really easy to use. Triggers are also really good for scheduling the ETL process."

"It is AWS-integrated. There is end-to-end integration with the other AWS services. It is also user-friendly."

More AWS Glue pros

"It can support a number of data sources, and it can pull flat files, from cloud-based databases or from those on-premises. Denodo can pull from any data source and interface with the view. Then, we can publish the view."

"Denodo is lightweight in terms of how it leads you to combine your discrete data systems at one spot."

"The most valuable features are query optimization and the single language independence from the sources we're using to catch data."

"The most valuable aspects of this solution are the short time frame in which you can deliver and connect."

"The most valuable feature is the performance. Denodo is very useful, especially in this huge pharma environment. I've found that older SAP solutions were very tightly coupled to each other, which resulted in data restrictions. Getting data from different sources was tough and tedious. Compared to these old solutions, Denodo is very easy to work with for the analytical team. Now that we've implemented this virtualization layer, we are capable of getting the data very smoothly. We implemented a very small unit, but the performance and integration have been very good."

"Denodo's capabilities offer a strong and intuitive solution for data access."

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

"In PL/SQL, first you need to gather all the data and then start writing the file, but in Denodo you fetch the data and write the data simultaneously. So, for example, if you have 1 million or 2 million records, you don't have to wait to fetch all of the 2 million; you can keep on fetching and writing in the file simultaneously."

More Denodo pros

Cons

"The technical support for this solution could be improved. In future, we would like to connect more services like Athena or Kinesis to help control more loads of data."

"Overall, I consider the technical support to be fine, although the response time could be faster in certain cases."

"We face performance issues when using AWS Glue for data transformation and integration."

"The solution’s stability could be improved."

"If there's a cluster-related configuration, we have to make worker notes, which is quite a headache when processing a large amount of data."

"In terms of performance, if they can further optimize the execution time for serverless jobs, it would be a welcome improvement."

"The solution's visual ETL tool is of no use for actual implementation."

"It is very difficult to learn the tool and remember the syntaxes comparatively."

More AWS Glue cons

"It would be good if the solution provided a much-needed cellular platform."

"Sometimes, Windows-related functions do not work properly in Denodo. The analytic functions in SQL do not work properly."

"I would like to see a proper way to avoid killing the sourcing systems."

"The solution is slow when there are many virtualization layers."

"Denodo currently integrates with ChatGPT, but the ability to manage and utilize them directly within Denodo would be a significant improvement."

"I would like to see a connectivity option with third-party apps, for example, JDBC, and ODBC drivers. Currently, we need to install it separately from the Denodo side and then connect it."

"Tasks such as conversion of a date format or conversion of a number format that can be done in a very easy way in different languages, like SQL or Oracle, are not so easy to do in Denodo. For example, if you want to convert a date from one format to another, in Oracle it's pretty easy; in Denodo, however, it requires so many lines of code. Simple things that can be done very quickly in other database languages require more lines of code in Denodo."

"Denodo has some difficulty supporting large numbers of records."

More Denodo cons

Pricing and Cost Advice

"I rate pricing an eight out of ten."

"I rate the tool's pricing a four out of ten."

"It is an expensive product. I rate its pricing a nine out of ten."

"I would rate the solution a six or seven on a scale of one to ten, with ten being very expensive. Specifically, I rate its pricing a six out of ten."

"I rate the product's pricing a five on a scale of one to ten, where one is a high price, and ten is a low price."

"The solution's pricing is based on DPUs so it is a good idea to optimize use or it can get expensive."

"The pricing is a bit higher than other solutions like Athena and EC2. If the pricing becomes more scaled or flexible, it will be good because you have to pay 44 cents just for one DPU for an hour. If you increase DPUs to 5 or 10, the pricing gets multiplied. There are also some time limits like 0 to 10 minutes or 10 to 20 minutes. If the pricing is according to the minutes, it would be better because you have to limit your job to 10 minutes or 20 minutes."

"I rate the tool an eight on a scale of one to ten, where one is expensive, and ten is expensive."

More AWS Glue pricing and cost advice

"The licensing charges for this solution are payable annually."

"I don't know the actual cost, but it's tens of thousands of dollars per month."

"Denodo provides a lightweight 30-day free trial, but when we do courses on top of it, it costs $150 for each person."

"The cost for Denodo is in line with other similar products."

"The licensing should be improved, as the cost per connector is quite expensive."

"Depending on the size of the client you want to work with, it can be prohibitively expensive at times."

"Cost wise, on a scale from one to five, with one being the cheapest and five being the most expensive, Denodo would be at three. We get all the features in a bundle."

"Talking with my manager and others, nobody has complained about the pricing so far which is a positive sign."

More Denodo 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

824,053 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

22%

Computer Software Company

13%

Manufacturing Company

Insurance Company

Financial Services Firm

21%

Manufacturing Company

10%

Computer Software Company

Energy/Utilities Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

How do you select the right cloud ETL tool?

AWS Glue and Azure Data factory for ELT best performance cloud services.

How does Talend Open Studio compare with AWS Glue?

We reviewed AWS Glue before choosing Talend Open Studio. AWS Glue is the managed ETL (extract, transform, and load) from Amazon Web Services. AWS Glue enables AWS users to create and manage jobs in...

What are the most common use cases for AWS Glue?

AWS Glue's main use case is for allowing users to discover, prepare, move, and integrate data from multiple sources. The product lets you use this data for analytics, application development, or ma...

Does Denodo provide useful data virtualization education? Is it useful to attend their training?

If you are a Denodo user, it makes sense to undergo their training. Different types of professionals can benefit from it, including administrators, developers, and architects. If you are keen on i...

In experience, what might Denodo be lacking or need improvement on?

I like Denodo a lot. It offers quick and easy web service deployment within minutes. There are not any flaws that I think make the product less good or effective. The only thing I can point out is...

Which industries can benefit from Denodo the most?

Denodo is suitable for pretty much all sectors that deal with: Big data Cloud solutions Data governance Logical data fabric Master data management In my opinion, organizations in different fields...

AWS Database Migration Service vs AWS Glue

Comparisons

Compared 35% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs AWS Glue

Compared 7% of the time

Informatica PowerCenter vs AWS Glue

Compared 6% of the time

SSIS vs AWS Glue

Compared 5% of the time

Palantir Foundry vs AWS Glue

Compared 2% of the time

More AWS Glue Competitors

Azure Data Factory vs Denodo

Compared 13% of the time

MuleSoft Anypoint Platform vs Denodo

Compared 9% of the time

Delphix vs Denodo

Compared 8% of the time

Informatica PowerCenter vs Denodo

Compared 6% of the time

Palantir Foundry vs Denodo

Compared 5% of the time

More Denodo Competitors

Product Reports

AWS Glue

Download AWS Glue product report

Download Denodo product report

Learn More

Amazon Web Services (AWS)

Overview

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:

Automatic schema discovery: AWS Glue crawlers connect to the organization's source or target data source through a prioritized list of classifiers to determine the schema for users' data. This feature creates metadata in companies' AWS Glue Data Catalog.
Schemas for data stream management: The AWS Glue Schema Registry enables users to validate and control the evolution of streaming data through registered Apache Avro schemas for no additional charge.
Automatic scaling based on workload: This feature dynamically scales resources up and down based on workload. The feature controls job resources, removing them depending on how much the workload can be split up.
FindMatches: This feature is for machine learning-based data deduplication and cleansing, and works by finding records that are imperfect matches of each other to remove useless data copies.
Edit, debug, and test ETL code: This feature helps users who have chosen to interactively develop their ETL code by providing development endpoints for editing, debugging, and testing the code it generates for them.
AWS Glue DataBrew: An interactive, point-and-click visual interface for specialists to clean and normalize data without the need to write any code.
AWS Glue Interactive Sessions: This feature simplifies the development of data integration jobs by enabling data engineers to interactively prepare and explore data.
AWS Glue Studio Job Notebooks: This AWS Glue feature provides serverless notebooks with minimal setup, allowing developers to start working in a timely manner.
Complex ETL pipeline building: This feature allows the product to be invoked on a schedule, on demand, or based on an event, allowing users to start multiple jobs in parallel or specify dependencies to build complex ETL pipelines.
AWS Glue Studio: This AWS Glue feature allows users to visually transform data through a drag-and-drop interface. The product automatically generates the code for ETL processes for users' data.

AWS Glue Benefits

AWS Glue offers a wide range of benefits for its users. These benefits include:

Users of other AWS products can easily onboard with AWS Glue, as it is integrated across a wide range of the company's services.
The solution is serverless, which allows for a lower total cost of ownership.
AWS Glue offers more power for users, as it automates much of the effort in building, maintaining, and running ETL jobs.
The product allows customers to easily discover and search across all their AWS datasets through AWS Glue Data Catalog.
AWS Glue does not require additional payment for managing and enforcing schemas for data streams.
The solution facilitates the authority of scalable ETL jobs for beginners and non-coding experts through a drag-and-drop interface.

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.

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:

Scalability: Denodo can scale from departmental or project to enterprise-wide with geographically distributed nodes. It can also handle large transactional loads of users, sources, and transactions as well as analytical loads of data volumes.
Query optimizers: This feature offers advanced cost-based and source constraint-based query optimization that includes query rewrite, query delegations, data movements, and join optimization.
Intelligent caching: This feature makes full, portal, and time-based caching possible.
Fine-grained security model: This Denodo feature makes integration with external systems possible.
Monitoring and auditing: Denodo offers enterprise-grade monitoring and auditing, which allows for integration with system management products, including Tivoli, Unicenter, and HP BTO.
Development and deployment support: The product offers full lifecycle support for the development and deployment of applications, providing users with all required tools.

Denodo Benefits

Denodo offers various benefits for its users through its services. Some of the greatest advantages of using this platform include:

The solution accelerates time to market for all types of business data through its services.
Denodo provides IT agility, which helps companies respond to business-changing demands in a timely manner.
Users can decide how much data replication they want to reduce through Denodo and use the product in full control.
The solution meets the industry's security and privacy requirements by providing high-grade protection for users' data.
Users can benefit from centralized control of data query executions for complete governance and full security.
Denodo offers legacy replacement, multi-cloud deployments, and cloud migrations with minimal disruptions and a fair price.
The solution utilizes artificial intelligence (AI) and machine learning (ML) to unlock data potential for customers.

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.

Sample Customers

bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday

Autodesk, VHA, AAA, Sumitomo Mitsui Trust Bank, Caterpillar, European Chemical Agency, Seagate, Nationwide, Time Warner Cable, Pantex, Inditex, BNSF Railways, Vodafone, CIT Group, Jazztel, Wolters Kluwer, Telefonica, TransAlta

AWS Glue vs. Denodo