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 data in HANA is stored in columns rather than rows, which speeds up searches and aggregations."
"SAP HANA is vertically and horizontally scalable."
"It's user-friendly so long as you use it frequently."
"This solution is very fast."
"It is a stable solution...It is a scalable solution."
"SAP HANA's most valuable features are monitoring, reporting, and price and stock control."
"The solution is marvelous because it controls everything including workflow and that makes our company more productive."
"It is very stable and very innovative. You can integrate many applications with it."
"Allows us to take volumes and process them at a very high speed."
"The solution was executed quite quickly due to its columnar storage underground, which is the most valuable feature of our company"
"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"The extensibility and efficiency provided by their C++ SDK."
"It has improved my organization's functionality and performance."
"Initiate on one node, and the RPM propagates automatically to all other nodes. ​"
 

Cons

"One notable issue is the difficulty in finding consultants with experience in the SuccessFactors product, a human resource management tool part of SAP's cloud-based solutions. For example, learning the Oracle database is straightforward. You can easily go to the Oracle website, download the database, install it on your laptop, and access technical resources and books."
"The bid process needs to be improved."
"Technical support could be better."
"It is challenging to integrate it with third-party tools."
"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."
"The interface is a little bit hard to customize. You almost have to consult the SAP original developer to change it."
"There's an issue in the partition. When you record more than two million records, partitioning does not work well. In Oracle it's easy. SAP must resolve this issue in order to be more competitive with Oracle."
"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)."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility."
"It would be great if this were a managed service in AWS."
"I have found that coding support could be simplified."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"It needs integration with multiple clouds."
"Fact-to-fact joins on multi-billion record tables perform poorly."
 

Pricing and Cost Advice

"SAP HANA is an expensive product."
"The price of this product is good."
"We pay annually for the license of the solution."
"SAP HANA is affordable. I rate it a seven out of ten."
"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 has a high price. I rate the solution’s pricing, one on a scale of ten, where one is expensive and ten is cheap."
"People who are technical will accept the cost, but financially they will assess whether this solution will bring them revenue or not. People often ask, how will I profit when the cost is so high?"
"The price is on the expensive side, at eight out of ten, with ten being expensive."
"The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."
"Work with a vendor, if possible, and take advantage of more aggressive discounts at mid-fiscal year (April) and fiscal year-end (October).​"
"From a cost perspective, the software is less than most of its competitors."
"The price could be cheaper and it is best to negotiate the price."
"I am aware that we have licensed it, but I have no knowledge of its cost."
"Vertica is an expensive tool."
"The price of Vertica is less expensive than some competitors, such as Teradata."
"The pricing for this solution is very reasonable compared to other vendors."
report
Use our free recommendation engine to learn which Embedded Database solutions are best for your needs.
842,767 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.
842,767 professionals have used our research since 2012.