Vertica Reviews

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

4.1 out of 5

86 reviews
91% willing to recommend

2,616 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, Snowflake, Teradata and more!

Vertica is the #5 ranked solution in top Data Warehouse solutions and #8 ranked solution in top Cloud Data Warehouse solutions. PeerSpot users give Vertica an average rating of 8.2 out of 10. Based on the analysis of the 86 most recent Vertica reviews, the overall sentiment is positive, with a sentiment score of 7.0. Vertica is most commonly compared to Snowflake: Vertica vs Snowflake. Vertica is popular among the large enterprise segment, accounting for 63% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a computer software company, accounting for 18% of all views.

Helped 824,067 peers since 2012

Featured 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

Marko Stajcer

Delivery director at Poslovna Inteligencija

Vertica's native cloud support could be improved, and its installation could be made easier. It's possible to deploy the solution on different hyperscalers, but it's not an easy process. Vertica is an MPP database, and sometimes, some nodes may fail. It could have a better warning system to let us know if we use all the storage space.

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 December 2024, the mindshare of Vertica in the Data Warehouse category stands at 9.2%, up from 8.9% compared to the previous year, according to calculations based on PeerSpot user engagement data.

Data Warehouse

PeerAnalyst reports

Type	Title	Date
Category	Data Warehouse	Dec 22, 2024	Download
Product	Reviews, tips, and advice from real users	Dec 22, 2024	Download
Comparison	Vertica vs Snowflake	Dec 22, 2024	Download
Comparison	Vertica vs Oracle Exadata	Dec 22, 2024	Download
Comparison	Vertica vs Teradata	Dec 22, 2024	Download

Title	Rating	Mindshare	Recommending
Snowflake	4.2	17.1%	97%	98 interviews Add to research
Teradata	4.1	17.1%	87%	76 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."

ROI

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

Popular Use Cases

Service and Support

Deployment

Scalability

Stability

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

18%

Computer Software Company

18%

Manufacturing Company

Energy/Utilities Company

Real Estate/Law Firm

University

Hospitality Company

Healthcare Company

Retailer

Government

Comms Service Provider

Insurance Company

Media Company

Construction Company

Educational Organization

Recreational Facilities/Services Company

Non Profit

Wholesaler/Distributor

Logistics Company

Pharma/Biotech Company

Outsourcing Company

Transportation Company

Performing Arts

Legal Firm

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