Try our new research platform with insights from 80,000+ expert users
OpenText Analytics Database (Vertica) Logo

OpenText Analytics Database (Vertica) pros and cons

Vendor: OpenText
4.1 out of 5
2,321 followers
Start review

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Vertica offers unparalleled speed and performance, functioning as a fast columnar database that provides quick data access and processing.
Users appreciate Vertica's ability to handle large data sets efficiently, enabling advanced analytics and near real-time ingestion.
The architecture of Vertica allows it to utilize commodity hardware, offering cost-effective infrastructure without compromising on performance.
Vertica's integration capabilities with tools like Tableau help streamline data visualization and reporting processes, opening new business opportunities.
Its flexibility in projections and encoding provides excellent tools for performance tuning, ensuring optimal use of resources for large-scale data processing.

CONS

OpenText Analytics Database (Vertica) faces limitations in group by projections and lacks support for Stored Procedure, packages, and triggers.
The installation process could be streamlined, and performance of the metadata layer management requires improvement.
There are challenges in scaling for multi-node clusters, especially when node failures occur, impacting system performance.
Documentation is an area with significant shortcomings and needs improvements for comprehensive understanding.
The cost of cloud deployment and native cloud support could be made more competitive and easier to manage.
 

OpenText Analytics Database (Vertica) Pros review quotes

SO
Sep 18, 2020
Speed and resiliency are probably the best parts of this product.
it_user453681 - PeerSpot reviewer
Jun 21, 2016
The fast columnar store database structure allows our query times to be at least 10x faster than on any other database.
reviewer2323428 - PeerSpot reviewer
Apr 11, 2024
The solution was executed quite quickly due to its columnar storage underground, which is the most valuable feature of our company
Learn what your peers think about OpenText Analytics Database (Vertica). Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
858,038 professionals have used our research since 2012.
reviewer2132406 - PeerSpot reviewer
Mar 20, 2023
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.
JG
Dec 18, 2020
The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful.
it_user428343 - PeerSpot reviewer
Jul 20, 2017
The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage.
it_user1355733 - PeerSpot reviewer
Sep 13, 2020
For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments.
it_user1355733 - PeerSpot reviewer
Oct 29, 2021
Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation.
it_user114084 - PeerSpot reviewer
Dec 26, 2017
The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors.
Sima Alexandru - PeerSpot reviewer
Nov 8, 2023
The product's initial setup phase is extremely simple.
 

OpenText Analytics Database (Vertica) Cons review quotes

SO
Sep 18, 2020
The geospatial functionality could be designed better.
it_user453681 - PeerSpot reviewer
Jun 21, 2016
Documentation has become much better, but can always use some improvement.
reviewer2323428 - PeerSpot reviewer
Apr 11, 2024
In our company, we have faced difficulties in scaling the solution for certain use cases.
Learn what your peers think about OpenText Analytics Database (Vertica). Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
858,038 professionals have used our research since 2012.
reviewer2132406 - PeerSpot reviewer
Mar 20, 2023
In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform.
JG
Dec 18, 2020
They could improve on customer service.
it_user428343 - PeerSpot reviewer
Jul 20, 2017
I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support.
it_user1355733 - PeerSpot reviewer
Sep 13, 2020
Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint.
it_user1355733 - PeerSpot reviewer
Oct 29, 2021
Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible.
Sima Alexandru - PeerSpot reviewer
Nov 8, 2023
The documentation of Vertica is an area with shortcomings where improvements are required.
ERICK RAMIREZ - PeerSpot reviewer
Jun 3, 2024
Pricing could be more competitive.