Exasol Data Warehouse vs OpenText Analytics Database (Vertica) comparison

The compared Exasol and OpenText solutions aren't in the same category. Exasol is ranked #24 in SQL , with an average rating of 8.5, and holds a 0.7% mindshare in the category. OpenText is ranked #8 in Data Warehouse , with an average rating of 8.0, and holds a 7.9% mindshare. Additionally, 100% of Exasol users are willing to recommend the solution, compared to 91% of OpenText users who would recommend it.

Exasol Data Warehouse

Read 8 Exasol Data Warehouse reviews

444 Views
117 Comparison Views

100% willing to recommend

OpenText Analytics Database...

Read 86 OpenText Analytics Database (Vertica) reviews

1,974 Views
955 Comparison Views

91% willing to recommend

Exasol Data Warehouse

OpenText Analytics Database...

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Exasol Data Warehouse and OpenText Analytics Database (Vertica) based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools.

To learn more, read our detailed Relational Databases Tools Report (Updated: June 2025).

Buyer's Guide

Relational Databases Tools

June 2025

Download the complete report

Helped 859,579 peers since 2012

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

Ranking in other categories

Relational Databases Tools (24th)

OpenText Analytics Database...

Average Rating

8.2

Reviews Sentiment

7.0

Number of Reviews

Ranking in other categories

Data Warehouse (8th), 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 0.7%, up 0.3% compared to last year.
OpenText Analytics Database (Vertica), on the other hand, focuses on Data Warehouse, holds 7.9% mindshare, down 9.2% since last year.

Relational Databases Tools

Data Warehouse

Featured Reviews

Shubham-Agarwal

Manager - Projects at Cognizant

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.

Read full review

T Venkatesh

Deputy Manager at ICICIBANK Ltd

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…

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"We can quickly scale the solution as it works on an MPP system."

"The most valuable feature of Exasol is its speed."

"The speed is very good compared to other databases, like SQL Server or Oracle."

"It is easy to scale."

"The solution is hands-off; you set it up insert your data and it self tunes queries."

"Its speed is great."

"We mainly chose Exasol for its performance reasons."

"Performance is a top priority, and it excels in this aspect."

"The most valuable feature of Vertica is the unmatchable database performance."

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

"The solution was executed quite quickly due to its columnar storage underground, which is the most valuable feature of our company"

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

"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."

"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."

"It maximize cloud economics for mission-critical big data analytical initiatives."

"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."

More OpenText Analytics Database (Vertica) pros

Cons

"You have to install Exasol drivers, and it's not easy to find or implement a driver into different systems."

"They don't talk very well to with other products when it comes to connectivity. Integration is lacking."

"It's not cloud-native so many maintenance operations require downtime."

"Lacks a cloud-based platform."

"It would be beneficial if the updates would occur more often."

"There are limited resources available to help me resolve the issue with Exasol."

"The only area where we found it could improve was in custom role creation and security, and it was difficult to work with."

"They should improve the security features for MPP processing."

"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."

"The geospatial functionality could be designed better."

"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."

"Documentation has become much better, but can always use some improvement."

"The documentation of Vertica is an area with shortcomings where improvements are required."

"The integration of this solution with ODI could be improved."

"It needs integration with multiple clouds."

"Limitations in group by projections is where I would like to see an improvement."

More OpenText Analytics Database (Vertica) cons

Pricing and Cost Advice

"The solution's cost is mid-ranged."

"The solution is free and we pay for the storage."

"The pricing and licensing depend on the size of your environment and the zone where you want to implement."

"Vertica is an expensive tool."

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

"Start with license per 1TB. Starting from hundreds of TB there is unlimited licensing to be considered. Move historical data to HDFS/S3 which are significantly cheaper or even free."

"The price of Vertica is less expensive than some competitors, such as Teradata."

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

More OpenText Analytics Database (Vertica) pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.

See recommendations

859,579 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Retailer

19%

Computer Software Company

10%

Logistics Company

Financial Services Firm

19%

Computer Software Company

17%

Manufacturing Company

Comms Service Provider

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about Exasol?

The most valuable feature of Exasol is its speed.

See all answers

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.

See all answers

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.

See all answers

What do you like most about Vertica?

Vertica is easy to use and provides really high performance, stability, and scalability.

See all answers

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.

See all answers

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.

See all answers

Comparisons

SQL Server vs Exasol Data Warehouse

Compared 20% of the time

SAP HANA vs Exasol Data Warehouse

Compared 18% of the time

Oracle Database vs Exasol Data Warehouse

Compared 14% of the time

MySQL vs Exasol Data Warehouse

Compared 13% of the time

Oracle Database In-Memory vs Exasol Data Warehouse

Compared 11% of the time

More Exasol Data Warehouse Competitors

SQL Server vs OpenText Analytics Database (Vertica)

Compared 14% of the time

Teradata vs OpenText Analytics Database (Vertica)

Compared 12% of the time

Snowflake vs OpenText Analytics Database (Vertica)

Compared 9% of the time

BigQuery vs OpenText Analytics Database (Vertica)

Compared 9% of the time

Oracle Exadata vs OpenText Analytics Database (Vertica)

Compared 8% of the time

More OpenText Analytics Database (Vertica) Competitors

Product Reports

Buyer's Guide

Exasol Data Warehouse

June 2025

Download Exasol Data Warehouse product report

Buyer's Guide

OpenText Analytics Database (Vertica)

June 2025

OpenText Analytics Database (Vertica) report

Download OpenText Analytics Database (Vertica) product report

Also Known As

No data available

Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand

Overview

Exasol is a high-performance data warehouse solution that accelerates BI and reporting features. Its speed, stability, and self-tuning queries make it valuable, and it doesn't require a database administrator. It's a backend database for Tableau dashboards, resulting in faster report loading times and increased efficiency in querying data.

Exasol's high performance allows users to connect insights and fire queries instead of looking at cached dashboards. It has impressive aggregation capabilities that help calculate metrics on the fly based on user-selected filters.

Exasol

OpenText Analytics Database Vertica is known for its fast data loading and efficient query processing, providing scalability and user-friendliness with a low cost per TB. It supports large data volumes with OLAP, clustering, and parallel ingestion capabilities.

OpenText Analytics Database Vertica is designed to handle substantial data volumes with a focus on speed and efficient storage through its columnar architecture. It offers advanced performance features like workload isolation and compression, ensuring flexibility and high availability. The database is optimized for scalable data management, supporting data scientists and analysts with real-time reporting and analytics. Its architecture is built to facilitate hybrid deployments on-premises or within cloud environments, integrating seamlessly with business intelligence tools like Tableau. However, challenges such as improved transactional capabilities, optimized delete processes, and better real-time loading need addressing.

What features define OpenText Analytics Database Vertica?

Fast Data Loading: Quickly ingests large data volumes.
Columnar Storage: Optimizes storage efficiency and speed.
OLAP Support: Provides robust analytics capabilities.
Advanced Compression: Enhances storage efficiency and performance.
Parallel Data Ingestion: Enables faster data processing.
Fault Tolerance: Ensures high availability and reliability.

What benefits should users expect?

Cost Efficiency: Low cost per TB is advantageous.
Scalability: Accommodates growing data needs seamlessly.
Integration Flexibility: Works well with BI tools like Tableau.
Real-Time Reporting: Delivers immediate insights for decision-making.

OpenText Analytics Database Vertica's implementation spans industries such as finance, healthcare, and telecommunications. It serves as a central data warehouse offering scalable management, high-speed processing, and geospatial functions. Companies benefit from its capacity to integrate machine learning and operational reporting, enhancing analytical capabilities.

OpenText

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.

Buyer's Guide

Relational Databases Tools

June 2025

Download Free Report

Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools. Updated: June 2025.

DOWNLOAD NOW

859,579 professionals have used our research since 2012.

We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.