We performed a comparison between Denodo and SAP HANA based on real PeerSpot user reviews.
Find out in this report how the two Data Virtualization solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable aspects of this solution are the short time frame in which you can deliver and connect."
"It is a very stable solution."
"The most valuable features are query optimization and the single language independence from the sources we're using to catch data."
"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 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."
"Denodo's best features are its performance, easy data transformation, and the job scheduler."
"It is easy to virtualize data using the solution."
"Using this solution has given us better details for reporting and analytics."
"SAP HANA is one of the best databases known for its performance...The new version of the solution is stable."
"Its in-memory capabilities are good, which is why many companies still use it."
"The solution is easy to scale."
"It's user-friendly so long as you use it frequently."
"The main feature is that the processes are very flexible, they are able to be adapted to the business and their departments."
"The solution is very stable."
"It is a stable solution...It is a scalable solution."
"We occasionally have some integration issues that we need to work through."
"Performance management could be improved."
"There have been some issues when you are at a table. Currently, Denodo exports data sets for a tabular model. When you are finished modeling your database or data warehouse they export a link to be used in Tableau. They should support other tools like Power BI."
"Sometimes, Windows-related functions do not work properly in Denodo. The analytic functions in SQL do not work properly."
"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."
"There are a couple of areas that can be improved in Denodo. From a stability point of view, sometimes we see issues in the data management functionality. This only happens now and then, however, and usually takes place when we add in our own customization."
"Denodo's training documentation could be improved by providing more material. From an administrative standpoint, I've found that only Denodo websites provide the usual tutorials. It may be because it's a bit of a restricted tool, but it results in trouble with learning. Normally, I can find help and solutions from other sources, but I haven't been able to find any for Denodo. Other that, it's fine and it performs well. I only have six months of experience, so I can't accurately suggest improvements."
"The git configuration really should be improved."
"Ease of use could be improved in SAP HANA. I like SAP because SAP solutions can be used by anyone, which means even laymen can start working on SAP tools, but in SAP HANA modeling, you'll need to know some other technologies and sequel scripting, and you need a separate skillset, so if you don't have the skillset, you won't be able to work on SAP HANA. Making SAP HANA low-code would make it even better."
"You cannot apply mulit-join inside the calculation views, for example, when you are joining tables."
"SAP HANA is a very proprietary tool and there's not as much support available for it as there is for an SQL Server (which is more popular)."
"The surface side or Attack dashboard needs improvement because there are some gaps after sales services."
"A documents preview could be helpful."
"There are a few areas wherein there could be a patch upgrade, and that can cover up the country-specific payroll areas."
"SAP HANA isn't user-friendly, and it's very hard to train newcomers to use it."
"I would like to see improvement on the feedback from the road-map; it is currently extremely hard to get insight in this area."
Denodo is ranked 1st in Data Virtualization with 29 reviews while SAP HANA is ranked 2nd in Data Virtualization with 81 reviews. Denodo is rated 7.8, while SAP HANA is rated 8.4. The top reviewer of Denodo writes "Saves our underwriters' time with data virtualization, but could provide more learning resources". On the other hand, the top reviewer of SAP HANA writes "Excellent compatibility between modules and the control". Denodo is most compared with Azure Data Factory, AWS Glue, Delphix, Mule Anypoint Platform and SSIS, whereas SAP HANA is most compared with Oracle Database, SQL Server, MySQL, IBM Db2 Database and Amazon Aurora. See our Denodo vs. SAP HANA report.
See our list of best Data Virtualization vendors.
We monitor all Data Virtualization 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.