15 years helping British businesses
choose better software

What is Vertica?

Trusted by AT&T, Cerner, Uber, The Trade Desk, and many others, Vertica is the unified analytics warehouse that helps you to capitalize on three major opportunities by unifying HDFS data and object storage data lakes to capitalize on investments and maximize business value; all deployment options to prevent vendor lock-in; and data scientists and business analysts so that they can use their preferred tools while operationalizing Machine Learning at scale for real-time predictive analytics.

Who Uses Vertica?

Any data-driven organization requiring higher performance at scale to address their emerging analytical use cases - from fraud detection to predictive maintenance to customer behavior analytics, more

Not sure about Vertica? Compare with a popular alternative

Vertica

Vertica

4.8 (5)
No pricing found
Free version
Free trial
21
1
4.2 (5)
4.3 (5)
4.2 (5)
VS.
Starting Price
Pricing Options
Features
Integrations
Ease of Use
Value for Money
Customer Service
US$0.01
one-time
Free version
Free trial
22
No integrations found
4.3 (410)
4.6 (410)
4.1 (410)
Green rating bars show the winning product based on the average rating and number of reviews.

Other great alternatives to Vertica

PostgreSQL
Top rated features
Access Controls/Permissions
Backup and Recovery
Data Storage Management
Microsoft SQL Server
Top rated features
Backup and Recovery
Data Storage Management
Performance Analysis
MySQL
Top rated features
Backup and Recovery
Database Support
Secure Data Storage
Oracle Database
Top rated features
Access Controls/Permissions
Backup and Recovery
Data Storage Management
MariaDB
Top rated features
Backup and Recovery
Data Storage Management
Multiple Programming Languages Supported
Google Cloud BigQuery
Top rated features
Data Connectors
Data Import/Export
Multiple Data Sources
RStudio Desktop
Top rated features
Code Development
Code Editing
Graphical User Interface
Databricks
Top rated features
Collaboration Tools
Data Visualisation
Google Cloud
Top rated features
Backup and Recovery
Data Storage Management
Secure Data Storage

Reviews of Vertica

Average score

Overall
4.8
Ease of Use
4.2
Customer Service
4.2
Features
4.4
Value for Money
4.3

Reviews by company size (employees)

  • <50
  • 51-200
  • 201-1,000
  • >1,001

Find reviews by score

5
80%
4
20%
Ruban
Ruban
Member of Technical Staff in India
Verified LinkedIn User
Information Technology & Services, 10,000+ Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

Best Analytical Database I have ever used

5.0 2 years ago

Comments: I'm using vertical as a analytical dB for twitter sentiment analysis. I have used Flume to get twitter data and use R to move the data from Hadoop to vertica DB and do analytical function and project the data in tableau.

Pros:

Analytical features that is available with this DB. Ease of use with Text User Interface and UI. Deployment is very fast and easy to do. Integration support with almost all top ingress and egress platform like. Apache Kafka, Flume, Hadoop etc. Very efficient and easy to deploy multinode cluster.

Cons:

Nothing I can think of, I was having node health issue alert even when the node was online. I need to upgrade to latest version and hope that issue has been addressed.

Verified Reviewer
Verified LinkedIn User
Information Technology & Services, 10,000+ Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

Smart database management tool

5.0 last year

Pros:

The robustness we get by using Vertica over other database management tools is a real game changer. We get stream of high volume data and the data needs to be processed at a rapid rate to keep up with the processes in the pipeline. Here, Vertica delivers on the expectations.

Cons:

While Vertica is robust, there are data size limitations. After a certain threshold, the software breaks! Although we are able to work around and make the floorplans such that this doesn't hamper live processes, but the data size limitations can kick-in.

Carine Sylvie
Carine Sylvie
Remote administrative assistant in Benin
Verified LinkedIn User
Marketing & Advertising, 2–10 Employees
Used the Software for: 1-5 months
Reviewer Source

Database Management tool

4.0 7 months ago

Pros:

One of the best SQL database management tool. A good solution to store and manage data.

Cons:

I have nothing particular to say against this tool.

Verified Reviewer
Verified LinkedIn User
Biotechnology, 5,001–10,000 Employees
Used the Software for: 2+ years
Reviewer Source

light weight platform that works very well

5.0 5 years ago

Comments: We were looking for an analytics platform that can work concurrently with hadoop clusters that was focused on performance and could also be inter-changeably used as a data processing engine.

Pros:

It is light weight and nimble but at the same time is good on performance - the fact that it is column store without the real need for indexing makes it easier to get started and then the storage requirement is also much smaller thanks to coding schemas and algorithms.

Cons:

for me, the biggest issue was the fact that it really affects performance when we try to run many large concurrent queries - I wish there was a solution to this. In addition, initial cost of investment to get started on Vertica may discourage SMB's.

Verified Reviewer
Verified LinkedIn User
Telecommunications, 5,001–10,000 Employees
Used the Software for: 1+ year
Reviewer Source

Vertica - Fastest MPP database to build data warehouses !

5.0 last year

Comments: MPP database to build good enterprise data warehouse.

Pros:

The best MPP database one can get to build analytical data warehouses . The columnar database architecture helps to query the data from the databases very quickly and efficiently . The dimension modeling made easy with Vertica.

Cons:

The GUI of the Vertica interface definitely needs improvement. The node manage can also be done better to perform snowflake architecture querying.