About Vertica

Vertica is a powerful big data analytics platform that enables organizations to analyze their data on-premises, in the cloud, or on Hadoop. The analytics capabilities are enhanced by machine learning and predictive analytics, which enable users to uncover insights and identify patterns in their data. The platform also offers advanced analytics features such as geospatial analytics, time-series analytics, and graph analytics.


Images

Vertica Software - Vertica query runner
View 2 more
Vertica video
Vertica Software - Vertica query runner

Not sure about Vertica? Compare with a popular alternative

Vertica

4,8 (5)
VS.
Highly reviewed

Starting Price

No pricing found
US$4 975,00
year

Pricing Options

Free version
Free trial
Free version
Free trial

Features

21
11

Integrations

1
No integrations found

Ease of Use

4,2 (5)
4,3 (119)

Value for Money

4,3 (5)
4,7 (119)

Customer Service

4,2 (5)
4,3 (119)
Green rating bars show the winning product based on the average rating and number of reviews.

Alternatives

RStudio Desktop

4,7
#1 Alternative to Vertica
RStudio is a data science program that enables users to develop, collaborate, manage, and share data in R and Python.

Google Cloud BigQuery

4,7
#2 Alternative to Vertica
BigQuery is a serverless and multi-cloud data warehouse designed to help users turn big data into valuable business...

MariaDB

4,7
#3 Alternative to Vertica
MariaDB is the database for all, supporting any workload, in any cloud, at any scale. Try MariaDB now.

Microsoft SQL Server

4,6
#4 Alternative to Vertica
SQL Server is a relational database management system (RDMS) designed to help businesses of all sizes analyze structured...

Reviews

Overall rating

4,8 /5
(5)
Value for Money
4,3/5
Features
4,4/5
Ease of Use
4,2/5
Customer Support
4,2/5

Already have Vertica?

Software buyers need your help! Product reviews help the rest of us make great decisions.

Showing 5 reviews of 5
Ruban
Ruban
Overall rating
  • Industry: Information Technology & Services
  • Company size: 10 000+ Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

Best Analytical Database I have ever used

Reviewed on 2022/06/20

I'm using vertical as a analytical dB for twitter sentiment analysis. I have used Flume to get...

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.

Alternatives Considered

RStudio Desktop, MariaDB and Google Cloud BigQuery
Verified Reviewer
Overall rating
  • Industry: Information Technology & Services
  • Company size: 10 000+ Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Smart database management tool

Reviewed on 2023/01/14

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.

Alternatives Considered

Microsoft SQL Server
Carine Sylvie
Carine Sylvie
Overall rating
  • Industry: Marketing & Advertising
  • Company size: 2–10 Employees
  • Used Weekly for 1-5 months
  • Review Source

Overall rating

  • Ease of Use
  • Customer Support
  • Likelihood to recommend 7.0 /10

Database Management tool

Reviewed on 2023/10/19

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
Overall rating
  • Industry: Biotechnology
  • Company size: 5 001–10 000 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

light weight platform that works very well

Reviewed on 2019/02/15

We were looking for an analytics platform that can work concurrently with hadoop clusters that was...

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
Overall rating
  • Industry: Telecommunications
  • Company size: 5 001–10 000 Employees
  • Used Daily for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 8.0 /10

Vertica - Fastest MPP database to build data warehouses !

Reviewed on 2023/03/16

MPP database to build good enterprise data warehouse.

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.

Vertica FAQs

Below are some frequently asked questions for Vertica.

Vertica offers the following pricing plans:

  • Pricing model: Free Version
  • Free Trial: Available

Straightforward per TB or per node pricing as well as by the hour on clouds

Vertica has the following typical customers:

51–200, 201–500, 501–1 000, 1 001–5 000

Vertica supports the following languages:

English

Vertica supports the following devices:

Vertica integrates with the following applications:

SAS Viya

Vertica offers the following support options:

Email/Help Desk, FAQs/Forum, Knowledge Base, 24/7 (Live rep), Chat

Related categories

See all software categories found for Vertica.