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

SAP HANA vs Vertica comparison

 

Comparison Buyer's Guide

Executive Summary

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

SAP HANA
Average Rating
8.2
Reviews Sentiment
6.5
Number of Reviews
84
Ranking in other categories
Data Virtualization (2nd), Embedded Database (4th), Relational Databases Tools (4th)
Vertica
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Data Warehouse (5th), Cloud Data Warehouse (11th)
 

Mindshare comparison

SAP HANA and Vertica aren’t in the same category and serve different purposes. SAP HANA is designed for Embedded Database and holds a mindshare of 8.7%, down 12.4% compared to last year.
Vertica, on the other hand, focuses on Data Warehouse, holds 8.6% mindshare, down 8.7% since last year.
Embedded Database
Data Warehouse
 

Featured Reviews

Jayarami Reddy Pujeri - PeerSpot reviewer
Comprehensive system with real-time analytics for versatile industry applications
Our primary use case is working with various clients in industries such as pharmaceuticals and other services. We support clients as implementers of SAP HANA, providing expertise in functionality, finance, logistics, and processes The solution is very user-friendly and supports all kinds of…
T Venkatesh - PeerSpot reviewer
Processes query faster through multiple systems simultaneously, but it could support different data types
We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…

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 of SAP HANA is the modeling of the databases."
"The solution is easy to scale."
"A very feature-rich solution with excellent performance."
"The most valuable features are the flexibility and the integration with other solutions in data quality."
"We have found the solution to be customizable and it is beneficial it comes as a bundled package. Additionally, it is user-friendly."
"The in-memory database is excellent."
"It is very stable and very innovative. You can integrate many applications with it."
"The solution is marvelous because it controls everything including workflow and that makes our company more productive."
"Vertica uses advanced Azure technologies to compress raw data using indexing, allowing a large amount of data to be stored with minimal physical space. Advanced algorithms are employed in data compression."
"The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage."
"Eighty percent of the ETL operations have improved since implementing this solution."
"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure."
"Allows us to take volumes and process them at a very high speed."
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
 

Cons

"The installation process could be more straightforward."
"Per SAP, you can do both transactional and analytical processes in SAP HANA. Though that's true, the speed is slower when you combine the two functions, so this is what I'd like SAP to improve in SAP HANA. In the next release, I want to see better diagrams in SAP HANA and a more user-friendly interface."
"SAP HANA's long run time to extract data could be improved upon."
"The relationship with a partner that sells SAP could be better. We depend much more on our own development, and the partner is for selling us the solutions, so we need them to be able to supply help and answers. The partner isn't very helpful, and we have to rely on our own knowledge and research."
"In terms of improvement, the speed is not as good as we thought it would be. That is why we are trying different solutions that will be built with different technologies."
"A documents preview could be helpful."
"The user interface and CRM need to be more user-friendly."
"I think that the pricing is high and it needs improvement."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"Very bad support, I would rate it two out of 10."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"Limitations in group by projections is where I would like to see an improvement."
"The integration of this solution with ODI could be improved."
"It would be great if this were a managed service in AWS."
"Suboptimal projection design causes queries to not scale linearly."
 

Pricing and Cost Advice

"I would rate the pricing of the solution a ten on ten. The pricing for on-prem SAP HANA is on a yearly basis and expensive. I am not aware of the actual pricing but it is based on 64 Gigabytes. For instance, if you consider $10,000 for 64 Gigabytes, then you can calculate the cost for Terabytes in case you have one. You will have to buy expensive hardware as well which is quite a lot."
"The price of the solution could be reduced, it is expensive."
"A monthly or yearly license must be purchased, although its utility will be based on the cost-benefit analysis that is reached by the individual customer."
"The tool’s subscription is yearly."
"There is an annual license to use SAP HANA."
"The price of SAP HANA is very expensive and it is paid annually."
"It is expensive."
"The pricing is relatively high for both customers and partners."
"The solution is free and we pay for the storage."
"The price could be cheaper and it is best to negotiate the price."
"I think it's starting to get a little expensive. Open source products are starting to get more robust, so I think that's something that they need to start looking at in terms of licensing."
"The pricing could improve, it is a little expensive."
"I am aware that we have licensed it, but I have no knowledge of its cost."
"The pricing for this solution is very reasonable compared to other vendors."
"It's free up to three nodes and 1TB, and then get in contact with their sales guys."
"It's an expensive product"
report
Use our free recommendation engine to learn which Embedded Database solutions are best for your needs.
845,040 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Manufacturing Company
15%
Computer Software Company
12%
Financial Services Firm
10%
Government
7%
Financial Services Firm
20%
Computer Software Company
18%
Manufacturing Company
8%
Real Estate/Law Firm
4%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What are the biggest benefits of using SAP HANA?
Based on my work with SAP HANA, the biggest benefit that it can bring to your business is total data management. This product is by SAP - a company that serves almost all needs a client may have co...
Is SAP HANA’s customer and technical support reliable?
We have been using SAP HANA for a fairly short period of time and have only taken advantage of their customer support. So far, we have not had issues that required specialized help from technical s...
Is SAP HANA difficult to set up and start using?
SAP HANA is fairly easy to set up, however, I do not think a complete beginner can do it. You certainly need some preparation - either you need to have experience with similar solutions, or with ot...
What do you like most about Vertica?
Vertica is easy to use and provides really high performance, stability, and scalability.
What is your experience regarding pricing and costs for Vertica?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
What needs improvement with Vertica?
The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases.
 

Comparisons

 

Also Known As

SAP High-Performance Analytic Appliance, HANA
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Overview

 

Sample Customers

Unilever, NHS 24, adidas Group, CHIO Aachen, Hamburg Port Authority (HPA), Bangkok Airways Public Company Limited
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about Firebird, SQLite, Oracle and others in Embedded Database. Updated: March 2025.
845,040 professionals have used our research since 2012.