Try our new research platform with insights from 80,000+ expert users

Denodo vs SAS Data Integration Server comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024

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

Denodo
Ranking in Data Integration
9th
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
37
Ranking in other categories
Data Virtualization (1st), Cloud Data Integration (6th)
SAS Data Integration Server
Ranking in Data Integration
37th
Average Rating
7.2
Reviews Sentiment
6.5
Number of Reviews
4
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of August 2025, in the Data Integration category, the mindshare of Denodo is 1.9%, down from 1.9% compared to the previous year. The mindshare of SAS Data Integration Server is 0.6%, up from 0.5% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Atanu Chatterjee - PeerSpot reviewer
Data virtualization and integration enabled while caching and scalability room for improvement
In terms of improvements for Denodo, regarding performance, in cases where there are multiple virtualizations—such as reading from one Denodo view that is virtualized, and from that view there's also virtualization, and another team is reading from that view—if multiple virtualizations happen with no caching in between, it becomes slow. This occurs because it is cascading; whenever at the top level someone is reading data, that request is getting cascaded to the nth level, causing issues, especially in cases such as Power BI reports. We need to consider implementing some persistent layer in between. The scaling process should improve because many things are getting automated. The scale-out part needs to be automated, though I am uncertain whether Denodo has already implemented that feature.
NN
Offloads processes on the server side but needs better installation syntax
One area for improvement is the installation process. Another point could be the syntax, as it sometimes involves using syntax names that are not intuitive. For example, to calculate the difference between two dates, the general syntax in SAS is called the data difference or data net function. However, another name is used, such as NF and INK. Without knowledge of SAS programming, it becomes unclear what these functions mean. It is not good to define function names this way.

Quotes from Members

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

Pros

"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."
"The performance and the speed to market are the most valuable features of this solution."
"The most valuable feature is Data Catalogs."
"The best thing about Denodo is that creating and deploying a web service can be done in about 10 minutes, compared to a whole day when it comes to other solutions (such as when deploying with Java and AWS)."
"It provides useful APIs and integrates with other systems."
"The data catalog feature is valuable as it helps define data structures without storing data."
"The logical data warehouse functionality is fantastic. It truly stands out. The ClearOptimizer and Virtual Cache are great features. They work together seamlessly to optimize performance."
"The most valuable features of Denodo are the extraction option for adapters, and there are many things for the views, that are cached. Denodo is not storing the data, it looks first to tune the query, and these things are for the agents."
"A key feature allows us to enhance job performance by offloading processing to the server side, rather than processing on the server itself."
"A key feature allows us to enhance job performance by offloading processing to the server side, rather than processing on the server itself."
"The solution offers very good data manipulation and loading."
"The solution is very stable."
"A key feature allows us to enhance job performance by offloading processing to the server side, rather than processing on the server itself."
"The most valuable feature of the solution is its amazing capabilities in regard to data handling."
 

Cons

"The integration could use improvement, it's a lot of non-speed line processes that we have discovered, in the country. The configurations could use a lot more improvement."
"Sometimes, Windows-related functions do not work properly in Denodo. The analytic functions in SQL do not work properly."
"The data catalog certainly has room for improvement. It is functional but we look forward to development. We are in constant contact with Denodo and they are fully aware of our needs."
"Monitoring event logs can be improved. In the older version, there was a monitoring schedule to get event reports and properly audit the reports. In the newer version, it is not there, and we have to manually configure data and audit events."
"User-specific security at the column and row levels needs to be improved. Instead of applying security at every individual level, it would be better if it were at the group or tier level. It will save a lot of time."
"Documentation needs to be improved"
"The support is not the best and should be improved."
"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."
"The initial setup of SAS Data Integration Server was complex."
"One area for improvement is the installation process."
"The initial setup had issues, and even after using it for about one year, it was still not fixed."
"The initial setup had issues, and even after using it for about one year, it was still not fixed."
"So I would like to see improved integration with other software."
"The transform tool has limited access. They should make it more flexible."
 

Pricing and Cost Advice

"I don't know the actual cost, but it's tens of thousands of dollars per month."
"I am not super familiar with the pricing, but so far, it seems good. We have been happy. We haven't seen any problems. The only time we had to pay extra was during the upgrade. We didn't upgrade at the time they told us to upgrade, and we had to pay extra to keep the service. They had stopped the support for the older version and moved to the newer version. It was not their fault. It was our fault because we didn't get on board quickly."
"There is an express edition and a licensed enterprise edition."
"Depending on the size of the client you want to work with, it can be prohibitively expensive at times."
"The licensing charges for this solution are payable annually."
"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."
"The licensing should be improved, as the cost per connector is quite expensive."
"The pricing is pretty good, and I would rate it at four out of five."
"It is an expensive program."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
865,140 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
23%
Manufacturing Company
10%
Computer Software Company
9%
Government
7%
Financial Services Firm
27%
Computer Software Company
9%
Government
7%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

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...
What do you like most about SAS Data Integration Server?
The most valuable feature of the solution is its amazing capabilities in regard to data handling.
What is your experience regarding pricing and costs for SAS Data Integration Server?
I don't handle the cost and budget part. From the tool's perspective, I can say that it is an amazing product.
What needs improvement with SAS Data Integration Server?
One area for improvement is the installation process. Another point could be the syntax, as it sometimes involves using syntax names that are not intuitive. For example, to calculate the difference...
 

Also Known As

No data available
SAS Enterprise Data Integration Server, Enterprise Data Integration Server
 

Overview

 

Sample Customers

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
Credit Guarantee Corporation, Cr_dito y Cauci‹n, Delaware State Police, Deutsche Lufthansa, Directorate of Economics and Statistics, DSM, Livzon Pharmaceutical Group, Los Angeles County, Miami Herald Media Company, Netherlands Enterprise Agency, New Zealand Ministry of Health, Nippon Paper, West Midlands Police, XS Inc., Zenith Insurance
Find out what your peers are saying about Denodo vs. SAS Data Integration Server and other solutions. Updated: August 2025.
865,140 professionals have used our research since 2012.