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

OpenText Analytics Database (Vertica) vs Oracle Exadata vs SAP BW4HANA 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.3
Oracle Exadata offers early break-even, reduced costs, increased performance, and significant savings despite complex licensing challenges.
Sentiment score
7.7
SAP BW4HANA centralizes data, enhances productivity and insights, with ROI expected in three to five years.
The investment is good, which is why people choose this hardware.
 

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.5
Oracle Exadata support praised for expertise, but critiques focus on delays and process efficiency improvement needs.
Sentiment score
5.6
SAP BW4HANA support receives mixed reviews, praised for technical assistance but criticized for variable response times and delays.
This involved creating blueprints for integrating Oracle products into client systems, followed by technical presentations to Oracle teams and stakeholders.
Exadata comes with a platinum gateway and comprehensive support, which often gets immediate attention with severity one cases.
In the meantime, I found solutions independently and provided two solutions to my client.
 

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.5
Oracle Exadata offers efficient scalability with flexible configurations, easy expansion, and high costs; ensure compatible hardware generations.
Sentiment score
7.1
SAP BW4HANA provides strong scalability through horizontal and vertical scaling, with positive user feedback despite budgeting challenges.
Within a site, scalability is excellent.
 

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
Oracle Exadata is praised for reliability and stability, with improved models offering redundancy and high availability, minimizing downtime.
Sentiment score
7.6
SAP BW4HANA is stable and reliable but faces scalability challenges with large datasets and needs more cloud-orientation.
Once installed, Exadata is very stable.
 

Room For Improvement

OpenText Analytics Database needs better workload management, documentation, SQL optimization, cloud support, machine learning, and cost efficiency.
Oracle Exadata needs cost management, simplified patching, improved support, better customization, enhanced security, and third-party integration.
SAP BW4HANA struggles with complexity, integration issues, high costs, a steep learning curve, and limited customization and support.
I cannot create an extended rack cluster with one node on one site and another node on a different site.
There are minor areas where improvement is needed, such as making the user interface more user-friendly and enhancing configuration and customization options.
Integration needs improvement.
 

Setup Cost

OpenText Analytics Database offers flexible pricing based on storage, with competitive costs, community edition, and negotiable licensing options.
Oracle Exadata's high costs are justified by its performance and reliability, offering value through reduced operational expenses.
SAP BW4HANA is costly, with high migration and certification fees, affordable for large enterprises but expensive for smaller ones.
I would rate the price an eight on a scale from one to ten, indicating it is fairly expensive.
The certification cost for SAP BW4HANA in 2025 is expected to be one lakh forty thousand.
 

Valuable Features

OpenText Analytics Database offers rapid data processing, scalability, ease of use, and cost efficiency with advanced analytics capabilities.
Oracle Exadata enhances performance, handles large databases efficiently, and simplifies management with advanced features and intelligent storage capabilities.
SAP BW4HANA offers flexible, efficient data management and real-time analytics, featuring user-friendly interfaces and strong integration with SAP ERP.
The most valuable features of Oracle Exadata are its high availability and cluster environment.
It also offers high backend speed between self-storage units and servers, which is beneficial for processing.
The best features include the ability to create data sources directly on tables, and perform mapping without creating info objects.
 

Mindshare comparison

As of September 2025, in the Data Warehouse category, the mindshare of OpenText Analytics Database (Vertica) is 6.9%, down from 9.1% compared to the previous year. The mindshare of Oracle Exadata is 14.1%, down from 18.9% compared to the previous year. The mindshare of SAP BW4HANA is 3.9%, down from 4.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse Market Share Distribution
ProductMarket Share (%)
Oracle Exadata14.1%
OpenText Analytics Database (Vertica)6.9%
SAP BW4HANA3.9%
Other75.1%
Data Warehouse
 

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…
Ahmed-Yehia - PeerSpot reviewer
Exceptional database performance with high availability and good reliability
The major use of Exadata is for running databases, big databases, and also for backing them up. It provides high availability and high performance specifically for databases, and not for applications, just Oracle databases High availability and high performance are very valuable aspects of the…
Csaba Grünblatt - PeerSpot reviewer
Performs all necessary data warehouse tasks and offers additional functionalities
SAP BW4HANA improved data reporting processes significantly. Performance on HANA database is good. Well-built data models ensure consistent and fast reporting. Reusable models enhance efficiency, even for SaaS services. In-memory computing, especially since HANA, has greatly improved performance in data analysis tasks. It eliminates the need for complex optimizations like creating indexes or aggregates. Queries that once took minutes now run in seconds, enabling real-time reporting, especially for SAP ECC on HANA. SAP BW4HANA's integration capabilities are streamlined with a simplified architecture and more virtual layers. You can directly load data into optimized layers, reducing the need for extra storage. The introduction of Open ODS Views allows for additional logic and master data inclusion, making integration faster and simpler. The learning curve for SAP BW4HANA is much faster now compared to ten years ago, thanks to abundant free resources like documentation, videos, blogs, and learning journeys provided by SAP. It is simpler to learn with these resources available compared to the past when you had to attend courses and rely on books. I would recommend SAP BW4HANA to users looking to implement it, especially if they want to keep their systems on-premise and already have SAP systems. Those with BW on HANA have two choices: BW4HANA or DataSphere, depending on their cloud strategy. If they are advanced in their cloud strategy and want to migrate off-premise, DataSphere is a good choice. However, for a robust solution on-premise or in a private cloud, BW4HANA is an excellent option. Overall, I would rate BW4HANA as a nine out of ten. It performs all necessary data warehouse tasks and offers additional functionalities. We use it traditionally, with complex transformations and models but with less emphasis on real-time processing and third-party sources.
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
867,836 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Computer Software Company
16%
Manufacturing Company
8%
Comms Service Provider
5%
Financial Services Firm
32%
Computer Software Company
10%
Government
6%
Manufacturing Company
5%
Manufacturing Company
17%
Retailer
10%
Computer Software Company
9%
Financial Services Firm
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business29
Midsize Enterprise23
Large Enterprise38
By reviewers
Company SizeCount
Small Business47
Midsize Enterprise13
Large Enterprise86
By reviewers
Company SizeCount
Small Business16
Midsize Enterprise4
Large Enterprise27
 

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 compet...
What do you like most about Oracle Exadata?
It is the best solution for OLTP and data warehousing.
What is your experience regarding pricing and costs for Oracle Exadata?
The cost of Oracle Exadata is substantial, particularly in terms of maintenance costs and licensing. This pricing str...
What needs improvement with Oracle Exadata?
Patching Oracle Exadata can be challenging due to its numerous components including network, blade, CPU, storage, and...
What do you like most about SAP BW4HANA?
One significant advantage of SAP BW/4HANA is the direct integration with the SAP HANA database, providing seamless ac...
What is your experience regarding pricing and costs for SAP BW4HANA?
The certification cost is extremely high. I completed certification for $40,000. The certification cost for SAP BW4HA...
What needs improvement with SAP BW4HANA?
Integration needs improvement. In reporting, I am not comfortable with the creation of variables, and some calculatio...
 

Also Known As

Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
No data available
SAP BW/4HANA
 

Overview

 

Sample Customers

Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
PayPal, EBS, Organic Food Retailer, Garmin, University of Minnesota, Major Semiconductor Company, Deutsche Bank, Starwood, Ziraat Bank, SK Telecom, and P&G.
Information Not Available
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: August 2025.
867,836 professionals have used our research since 2012.