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

Exasol Data Warehouse vs OpenText Analytics Database (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

Exasol Data Warehouse
Average Rating
8.0
Reviews Sentiment
7.1
Number of Reviews
8
Ranking in other categories
Relational Databases Tools (23rd)
OpenText Analytics Database...
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Data Warehouse (7th), Cloud Data Warehouse (11th)
 

Mindshare comparison

Exasol Data Warehouse and OpenText Analytics Database (Vertica) aren’t in the same category and serve different purposes. Exasol Data Warehouse is designed for Relational Databases Tools and holds a mindshare of 1.1%, up 0.4% compared to last year.
OpenText Analytics Database (Vertica), on the other hand, focuses on Data Warehouse, holds 6.9% mindshare, down 9.2% since last year.
Relational Databases Tools Market Share Distribution
ProductMarket Share (%)
Exasol Data Warehouse1.1%
SQL Server15.5%
Oracle Database12.6%
Other70.8%
Relational Databases Tools
Data Warehouse Market Share Distribution
ProductMarket Share (%)
OpenText Analytics Database (Vertica)6.9%
Oracle Exadata14.2%
Snowflake12.5%
Other66.4%
Data Warehouse
 

Featured Reviews

Shubham-Agarwal - PeerSpot reviewer
Fast query processing and easy-to-store all the data
There are very few companies that are using Exasol, but the majority of companies are using SQL Server, Cloud or IBM Db2 Database, or any other databases. Therefore, the resources are limited, which is my only concern. So if I face any issues, limited resources are available to help me resolve the issue with Exasol. From that perspective, it can be a bit of a struggle for me to find a solution. In the next release, I would like to see better compatibility issues. Currently, Exasol has limited compatibility with other software like Python and R. For example, If I talk about SQL Server, we can connect it to big data or Python, which is also compatible with different servers.
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 solution is hands-off; you set it up insert your data and it self tunes queries."
"The speed is very good compared to other databases, like SQL Server or Oracle."
"We mainly chose Exasol for its performance reasons."
"Its speed is great."
"The most valuable feature of Exasol is its speed."
"It is easy to scale."
"Performance is a top priority, and it excels in this aspect."
"We can quickly scale the solution as it works on an MPP system."
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"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 most valuable feature is Vertica's performance and the ease of using the database."
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. ​"
"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."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"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."
 

Cons

"They don't talk very well to with other products when it comes to connectivity. Integration is lacking."
"The only area where we found it could improve was in custom role creation and security, and it was difficult to work with."
"It's not cloud-native so many maintenance operations require downtime."
"There are limited resources available to help me resolve the issue with Exasol."
"You have to install Exasol drivers, and it's not easy to find or implement a driver into different systems."
"They should improve the security features for MPP processing."
"Lacks a cloud-based platform."
"It would be beneficial if the updates would occur more often."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"Very bad support, I would rate it two out of 10."
"Suboptimal projection design causes queries to not scale linearly."
"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"I have found that coding support could be simplified."
"In our company, we have faced difficulties in scaling the solution for certain use cases."
 

Pricing and Cost Advice

"The solution's cost is mid-ranged."
"It's free up to three nodes and 1TB, and then get in contact with their sales guys."
"It is fast to purchase through the AWS Marketplace."
"It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy."
"The pricing and licensing depend on the size of your environment and the zone where you want to implement."
"Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."
"Work with a vendor, if possible, and take advantage of more aggressive discounts at mid-fiscal year (April) and fiscal year-end (October).​"
"The first TB is free and you can use all the Vertica features. After 1TB you have to pay for licensing. The product is worth it, but be aware of this condition, and plan. The compression ratio is explained in the documentation."
"The price of Vertica is less expensive than some competitors, such as Teradata."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
868,787 professionals have used our research since 2012.
 

Top Industries

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

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business1
Midsize Enterprise1
Large Enterprise6
By reviewers
Company SizeCount
Small Business29
Midsize Enterprise23
Large Enterprise38
 

Questions from the Community

What do you like most about Exasol?
The most valuable feature of Exasol is its speed.
What needs improvement with Exasol?
You have to use upper-column names in Exasol, which is strange. You have to install Exasol drivers, and it's not easy to find or implement a driver into different systems.
What is your primary use case for Exasol?
We implemented our data problem issues from Tableau. We inserted the data into the Exasol database in order to run 10 to 20 reports from Tableau. This was just a small but problematic report for us.
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.
 

Also Known As

No data available
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Overview

 

Sample Customers

1&1 Internet SE 11880 Internet Services AG AB Svenska Spel Accarda AG Aera Technology Inc. AGRAVIS Raiffeisen AG Apotheken-Rechen-Zentrum GmbH AQR Capital Management, LLC arvato distribution GmbH ARZ Allgemeines Rechenzentrum GmbH Badoo Limited Baur Versand (GmbH & Co. KG) BIScience Ltd Blocket Blue Yonder GmbH Codilink UK Ltd T/A Coniq crealytics GmbH dailyme TV GmbH Dailymotion S.A. Dataforce Verlagsgesellschaft für Business Information mbH Deutsche Postbank AG Digitales Rezept Zentrum GmbH DIKW Groep direct services Gütersloh GmbH DR Technologies Ltd. dress-for-less GmbH econda GmbH emetriq GmbH empiriecom GmbH & Co. KG Flaconi GmbH Fresenius Netcare GmbH Fyber GmbH GfK SE Grant Street Group, Inc. Gruner + Jahr GmbH Gymshark UK Hahn Air Lines GmbH Hermes Einrichtungs Service GmbH & Co. KG INNOVATIVE SCHEDULING, LLC internetstores GmbH INTERSPORT Deutschland eG IQVIA Commercial GmbH & Co. OHG IQVIA Commercial Sp. z o.o. IQVIA Incorporated iVantage Health Analytics K - Mail Order GmbH & Co. KG LIQ CORP SA Manor AG Basel Match2Lists Limited MEDION AG Midasplayer AB Monsoon Accessorize Limited m-pathy GmbH msales Ltd. MTG Modern Services AB MW Aviation GmbH & Co. KG Myntra Designs Pvt Ltd Netzeffekt GmbH New Company Services Ltd. NOVENTI HealthCare GmbH Olympus Europa SE & Co. KG Operation Fistula OpsDataStore OTTO (GmbH & Co KG) Panda Retail Co. PAPSTAR GmbH Piedmont Healthcare, Inc. Questback GmbH RatePAY GmbH Revolut Ltd. Saarland-Sporttoto GmbH Sagarmatha Ltd. SIA Damara Technologies Supermärkte Nord Vertriebs GmbH & Co. KG The National Research Center for College & University Admissions, Inc. United Utilities Water Ltd. Verlag C.H. Beck oHG Vocal Planet Ltd. Vodafone Group Services GmbH Webtrekk GmbH wer liefert was? GmbH Windeln.de SE Wooga GmbH XING SE Zalando SE
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools. Updated: September 2025.
868,787 professionals have used our research since 2012.