Vertica Reviews

Name: Vertica
Brand: OpenText
Rating: 4.1 (86 reviews)

4.1 out of 5

86 reviews
91% willing to recommend

2,470 followers

What is Vertica?

Vertica is a deploy-anywhere SQL database created for elasticity, speed, and advanced analytics. Vertica enables today’s busy teams to modernize their data warehouses, democratize data and analytics to enable increased access, and deploy analytics in a hybrid cloud environment. Additionally, Vertica merges how companies power their analytics by providing a scalable, open, and elastic database with numerous intuitive features.

Get the Vertica Buyer's Guide and find out what your peers are saying about Vertica, Databricks, Azure Data Factory and more!

Vertica is the #5 ranked solution in top Data Warehouse solutions and #11 ranked solution in top Cloud Data Warehouse solutions. PeerSpot users give Vertica an average rating of 8.2 out of 10. Vertica is most commonly compared to Databricks: Vertica vs Databricks. Vertica is popular among the large enterprise segment, accounting for 62% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a financial services firm, accounting for 19% of all views.

Helped 850,671 peers since 2012

Featured Vertica reviews

T Venkatesh

Deputy Manager at ICICIBANK Ltd

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

ERICK RAMIREZ

Team Lead Solutions Architect at IMEXPERTS DO BRASIL

You can implement a cluster of servers, and we should guarantee high availability in a disaster recovery scenario. You can use Vertica in a production environment with distributed workflows and workloads. Vertica is available and has parallel processing and other capabilities. You can implement a cluster of servers to guarantee high availability and massive parallel processing. It's a very sophisticated solution. Vertica can be used to implement machine learning models such as classification, clustering, and aggregation models to support various use cases depending on customer needs. We have already implemented some machine learning models to detect anomalies. Some employees have distinct patterns in their working behaviors. It is another feature-intelligent solution from OpenTex. It can implement or process structural data such as images, videos, text documents, and semi-structured data. I recommend using this kind of solution because you can index your data and use a balancing algorithm to manage and retrieve data efficiently. Customers don't need a very large infrastructure to implement this type of solution. You can use it to implement advanced machine learning models, classification, and clustering. It also supports advanced artificial intelligence solutions. Overall, I rate the solution a nine out of ten.

Read full review

Sima Alexandru

Support Specialis at Orion Innovation Romania

I would describe Vertica as a user-friendly product. The documentation part of Vertica is almost the same as the one for MySQL, which we have in our company. The documentation part of Vertica is very friendly enough to use, but I can never say that the documentation area is better. I don't use ChatGPT to help me with my queries since I try to deal with my issues and queries on my own. I don't want anything improved in the solution as it provides us with everything we require in our IT environment. If I know how to run a query, then the results generated by Vertica turn out to be okay. The stability offered by Vertica is something that depends on the application and the memory of the product. If you work with Vertica in any of your projects, you will see that it works better for you with much more resources than others. You won't encounter problems with Vertica, especially if your company's architects are better at managing and creating interfaces. I recommend Vertica to those who plan to use it since it is easy to configure and use. I don't think you would encounter any problems with Vertica. The syntax in Vertica is easy to use and user-friendly, which you can find on Google. I rate the overall tool a seven out of ten.

Read full review

Vertica mindshare

Product category:

As of May 2025, the mindshare of Vertica in the Data Warehouse category stands at 8.5%, down from 8.9% compared to the previous year, according to calculations based on PeerSpot user engagement data.

Data Warehouse

PeerResearch reports based on Vertica reviews

Type	Title	Date
Category	Data Warehouse	May 9, 2025	Download
Product	Reviews, tips, and advice from real users	May 9, 2025	Download
Comparison	Vertica vs Snowflake	May 9, 2025	Download
Comparison	Vertica vs Oracle Exadata	May 9, 2025	Download
Comparison	Vertica vs Teradata	May 9, 2025	Download

Title	Rating	Mindshare	Recommending
Databricks	4.1	N/A	96%	89 interviews Add to research
Azure Data Factory	4.0	N/A	92%	90 interviews Add to research

Valuable Features

"The initial setup was straightforward."
"Vertica uses advanced Azure technologies to compress raw data using indexing, allowing a large amount of data to be stored with minimal physical space. Advanced algorithms are employed in data compression."
"The solution was executed quite quickly due to its columnar storage underground, which is the most valuable feature of our company"

Room for Improvement

"The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases."
"Pricing could be more competitive."
"In our company, we have faced difficulties in scaling the solution for certain use cases."

Pricing

Vertica pricing and licensing is flexible, offering perpetual and subscription models based on data size rather than node count. While the cost can be high, it's often considered reasonable compared to competitors like Oracle or Teradata. Pricing is fair for the storage used, with discounts available when negotiating around fiscal year-end. The community edition provides a cost-free option for smaller deployments, allowing users to evaluate the platform's features before committing to commercial licenses.

"The solution is relatively cost-effective."
"It's an expensive product"
"Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."

These insights are based on the in-depth reviews provided by peers to help you make a better buying decision.

Download our Vertica Buyer's Guide for additional reliable information.

Review data by company size

By reviewers

By visitors reading reviews

Top industries

By visitors reading reviews

Financial Services Firm

19%

Computer Software Company

18%

Manufacturing Company

Real Estate/Law Firm

University

Healthcare Company

Insurance Company

Comms Service Provider

Retailer

Hospitality Company

Media Company

Educational Organization

Government

Energy/Utilities Company

Legal Firm

Wholesaler/Distributor

Outsourcing Company

Construction Company

Recreational Facilities/Services Company

Pharma/Biotech Company

Non Profit

Logistics Company

Performing Arts

Transportation Company

Renewables & Environment Company

Compare Vertica with alternative products

Learn more about Vertica

In today’s marketplace, organizations are experiencing continued robust growth of data volumes, and citizen data scientists’ broader use of analytics is causing many companies to re-visit and re-examine their systems in order to match the demands of an aggressive marketplace. Analytics are continually swiftly evolving. New data from social media, blogs, IoT sources, data streams, gas and electrical grids, and mobile networks is being constantly gathered in extensive data sets. This presents organizations with a new opportunity to become more data driven, and they must be able to manage the new data growth and identify the trends and sequences that can lead to both improved business opportunities and continued repeat business from their clients.

Vertica Benefits:

Vertica has many valuable key benefits. Some of its most useful benefits include:

Efficiency: Vertica provides robust compression and intuitive impressions. This results in users requiring significantly less storage and hardware than other comparable data analytics solutions. The progressive Vertica architecture results in queries that are 10-50 times faster than other platforms while providing more storage data per server.
Integration: Each new iteration of Vertica is tested and certified with the latest ETL and visualization tools. It actively supports Java Database Connectivity (JDBC), Open Database Connectivity (ODBC), and popular SQL providers. All these solutions and most leading BI and visualization tools interact seamlessly, making Vertica overall a very cost-effective solution and solid business investment.
Cloud flexibility: With Vertica, users do not have to get locked into a single cloud vendor. Users are able to take complete advantage of the current infrastructure that is already in place. Vertica seamlessly integrates with popular public clouds, including Google Cloud Platform (GCP), Azure, AWS, Alibaba, VMware clouds, and more. It also provides for easy portability across on-premise and multi-cloud environments and data lakes. Vertica designs a robust flexible platform for running a company’s analytical and computing workloads, which allows applications to run simultaneously on numerous environments in a hybrid cloud infrastructure. Vertica is able to seamlessly use public clouds and private data centers, and it grants the flexibility to switch in an instant.
Security: Vertica offers dynamic end-to-end security with support for partner solutions and industry-standard protocols such as Apache Sentry, AWS IAM, Kerberos, LDAP, and more. Vertica utilizes an intuitive layered security model that provides multiple security authentication authorization mechanisms. Vertica will also maintain an audit trail, natively exported to other security domains for analysis and persistence.

Reviews from Real Users

“I am using Vertica for aggregations and dashboards. 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.” - Bijal S., Group Chief Technology Officer at Netcore Solutions

“The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money.” - Munkhsaikhan B., Project Lead - Digital Transformation Unit at Bodi Electronics LLC

Vertica was previously known as Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand.