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

OpenText Analytics Database (Vertica) vs SAP HANA 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:
 

ROI

Sentiment score
6.9
Users report significant ROI from OpenText Analytics Database due to enhanced analytics, performance, and data accessibility, despite its cost.
Sentiment score
6.1
SAP HANA users saw financial and speed benefits, but mid-sized businesses faced mixed feelings about integration costs and challenges.
We do not feel we're getting value for the investment due to the additional resources needed for integration and maintenance.
 

Customer Service

Sentiment score
7.0
OpenText Analytics Database customer service is praised for knowledgeable support, though some users report slow response and escalation needs.
Sentiment score
6.0
SAP HANA customer service is well-received but varies; improvements needed in response speed, solution accuracy, and expert access.
The community support is better than the official SAP support.
Time to respond to SAP support is an issue, and finding the right person and handling the whole process are problems too.
When we raise a ticket for AWS or Azure issues, we find their support is very proactive, while SAP's support is quite passive.
 

Scalability Issues

Sentiment score
7.1
OpenText Analytics Database (Vertica) excels at scaling large data volumes but faces challenges with schema modifications and node additions.
Sentiment score
7.8
SAP HANA efficiently scales for various user loads, supports growing data, and manages enterprise transactions across industries.
Our operations have grown from a hundred data operations a day to as many in a couple of seconds.
The scalability rating is based on the ability to expand.
There is enough scalability offered by SAP to meet our deployment needs.
 

Stability Issues

Sentiment score
7.1
OpenText Analytics Database (Vertica) is stable and robust, with minor query and network issues noted by users.
Sentiment score
7.8
SAP HANA is generally stable and reliable, but some users face occasional performance issues linked to external factors.
We recently faced customer data loss during the cluster handover or failover fallback.
We have not had any problems in the last seven to eight years.
Regarding stability, they are using legacy systems and have implemented SAP HANA.
 

Room For Improvement

OpenText Analytics Database needs better workload management, documentation, SQL optimization, cloud support, machine learning, and cost efficiency.
SAP HANA faces criticism for high cost, complex deployment, resource limitations, and a challenging interface, affecting adoption and usability.
The setup process and deployment process for SAP HANA is complex.
Licensing costs with SAP HANA are very high.
Many customers still prefer Oracle, possibly due to cost or familiarity, despite SAP mandating that they have to go to SAP HANA.
 

Setup Cost

OpenText Analytics Database offers flexible pricing based on storage, with competitive costs, community edition, and negotiable licensing options.
SAP HANA's high pricing favors larger enterprises, requiring careful budgeting, with some opting for alternatives due to costs.
It's a recurring subscription model, which is expensive compared to legacy systems with just a maintenance fee.
SAP is not a cheap company, and its licenses are expensive.
I would rate the price for SAP HANA as high.
 

Valuable Features

OpenText Analytics Database offers rapid data processing, scalability, ease of use, and cost efficiency with advanced analytics capabilities.
SAP HANA offers real-time analytics, integration, scalability, and a user-friendly interface, supporting large enterprises with efficient data handling.
It allows some tables to be stored in a column base, others in a row base, and the In-Memory functionalities are mostly the highlight of SAP HANA, especially compared to disk-based memory users.
One of our dashboards using Excelsius was previously developed on normal BW on Oracle data, which took 10 minutes to open. After developing the same calculation views using those tables and replacing them with calculation views in Excelsius, the dashboard opened in seconds.
This architecture allows for faster data processing and real-time analytics that were not possible with traditional databases.
 

Categories and Ranking

OpenText Analytics Database...
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Data Warehouse (6th), Cloud Data Warehouse (11th)
SAP HANA
Average Rating
8.2
Reviews Sentiment
6.4
Number of Reviews
89
Ranking in other categories
Data Virtualization (2nd), Embedded Database (4th), Relational Databases Tools (3rd)
 

Mindshare comparison

OpenText Analytics Database (Vertica) and SAP HANA aren’t in the same category and serve different purposes. OpenText Analytics Database (Vertica) is designed for Data Warehouse and holds a mindshare of 8.0%, down 9.1% compared to last year.
SAP HANA, on the other hand, focuses on Embedded Database, holds 9.2% mindshare, down 11.4% since last year.
Data Warehouse
Embedded Database
 

Featured Reviews

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…
Dhiraj Jankar - PeerSpot reviewer
Users appreciate the mix of in-memory architecture and ease of backend management
The most valuable SAP HANA features are that, compared to Oracle, there is less administrative work and less complex work to handle, making it very straightforward. The tool itself takes care of the backend work. The main benefits SAP HANA provides to users include its architecture, which combines both column store and row store capabilities. Some places find the row feature important, whereas others find column store important. It allows some tables to be stored in a column base, others in a row base, and the In-Memory functionalities are mostly the highlight of SAP HANA, especially compared to disk-based memory users. This was the main reason SAP HANA was introduced initially.
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
861,803 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Computer Software Company
17%
Manufacturing Company
8%
Comms Service Provider
4%
Manufacturing Company
15%
Computer Software Company
10%
Financial Services Firm
9%
Government
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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

Also Known As

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

Overview

 

Sample Customers

Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Unilever, NHS 24, adidas Group, CHIO Aachen, Hamburg Port Authority (HPA), Bangkok Airways Public Company Limited
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: June 2025.
861,803 professionals have used our research since 2012.