OpenText Analytics Database (Vertica) Reviews

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

4.1 out of 5

86 reviews
91% willing to recommend

2,299 followers

What is OpenText Analytics Database (Vertica)?

OpenText Analytics Database Vertica is known for its fast data loading and efficient query processing, providing scalability and user-friendliness with a low cost per TB. It supports large data volumes with OLAP, clustering, and parallel ingestion capabilities.

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

OpenText Analytics Database (Vertica) is the #6 ranked solution in top Data Warehouse solutions and #11 ranked solution in top Cloud Data Warehouse solutions. PeerSpot users give OpenText Analytics Database (Vertica) an average rating of 8.2 out of 10. OpenText Analytics Database (Vertica) is most commonly compared to Databricks: OpenText Analytics Database (Vertica) vs Databricks. OpenText Analytics Database (Vertica) is popular among the large enterprise segment, accounting for 59% 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.

Buyer's Guide

OpenText Analytics Database (Vertica)

June 2025

Get the report

Helped 859,579 peers since 2012

Featured OpenText Analytics Database (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

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

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

OpenText Analytics Database (Vertica) mindshare

Product category:

As of July 2025, the mindshare of OpenText Analytics Database (Vertica) in the Data Warehouse category stands at 8.0%, down from 9.1% compared to the previous year, according to calculations based on PeerSpot user engagement data.

Data Warehouse

PeerResearch reports based on OpenText Analytics Database (Vertica) reviews

Type	Title	Date
Category	Data Warehouse	Jul 1, 2025	Download
Product	Reviews, tips, and advice from real users	Jul 1, 2025	Download
Comparison	OpenText Analytics Database (Vertica) vs Snowflake	Jul 1, 2025	Download
Comparison	OpenText Analytics Database (Vertica) vs Oracle Exadata	Jul 1, 2025	Download
Comparison	OpenText Analytics Database (Vertica) vs Teradata	Jul 1, 2025	Download

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

Valuable Features

OpenText Analytics Database (Vertica) boasts fast query processing, scalability, and the ability to handle large data volumes efficiently. Users value its columnar architecture, workload analysis, high availability, and easy integration with various data sources. Its projections and hybrid storage model optimize performance, while its intuitive tools like the Management Console and Database Designer enhance user experience. Its competitive pricing and reliable performance make it appealing for big data initiatives.

"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

OpenText Analytics Database (Vertica) faces challenges with handling large transactions efficiently and lacks workload management tools for peak loads. Documentation and developer tools need enhancement. It fails in optimizing SQL operations compared to competitors and requires better machine learning support. Users report high resource demands and integration issues with other platforms. Improvements are needed in performance tuning, effective use of cloud services, error handling, and the management console. Costs and deployment complexity are concerns.

"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

ROI from OpenText Analytics Database (Vertica) varies across users. Some have not calculated an ROI yet due to limited time in production, others report it as great compared to SQL Server, and some find it essential for providing services to customers. Users note its performance is superior to traditional databases, enabling analytics previously impossible. Vertica's enablement of real-time reporting and data insights marks it as highly beneficial.

Pricing

Enterprise buyers evaluating OpenText Analytics Database (Vertica) should note that its pricing is generally considered reasonable but can be expensive, depending on data size and licensing model. Vertica primarily charges based on the amount of storage used rather than node count, offering flexibility and cost-efficiency. A community edition is available for free, allowing up to three nodes and one TB. Negotiating during fiscal year-end can yield discounts, and traditional licensing is being phased towards subscriptions.

"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

Organizations use OpenText Analytics Database (Vertica) as their centralized data warehouse, integrating data from multiple sources. It supports internal analysis, reporting, and advanced analytics, including geospatial and machine learning functions. With high-speed data processing, Vertica facilitates data storage, retrieval, and real-time analytics, serving diverse business analytics needs such as machine learning applications, dashboard creation, and big data ingestion. Deployed both on-premises and in cloud environments, it enables efficient ETL processes and high-volume reporting.

Service and Support

Customers find the customer service of OpenText Analytics Database (Vertica) responsive and knowledgeable. Technical support receives mixed feedback; some rate it highly for rapid responses and expertise, especially from engineers, while others report slow resolutions and reliance on community resources. Positive experiences include quick escalations and personalized support for complex issues, though some users encounter generic responses and suggest improvements in response times and skill-sets.

Deployment

Many describe OpenText Analytics Database (Vertica)'s initial setup as straightforward, especially when following documentation. Experienced users find it simple, though some suggest familiarity with Linux aids the process. Consultants can be helpful, particularly for those unfamiliar. Earlier versions posed more challenges, but recent iterations are easier. Some mention the value of external support. Setting up clusters is generally easy, with attention needed for data handling and query optimization.

Scalability

OpenText Analytics Database (Vertica) is praised for its scalability by users. They appreciate its capability to handle large data volumes and concurrent queries effectively. Challenges are noted in cloud hosting, schema adjustments, and node rebalancing. Some users mention the need for a strategic initial setup to avoid issues. Despite minor limitations, many find Vertica scalable, but costs escalate with increased usage. Users highlight the importance of optimizing query structures for improved performance.

Stability

OpenText Analytics Database (Vertica) is mostly stable with some instances of crashes due to large queries, network issues, or configuration problems. Stability is often dependent on hardware configuration and query optimization. Cluster issues and occasional node failures have been noted. Those encountering problems usually resolve them with updates or support. Many rate its stability highly, benefiting from high availability and data handling capabilities, while some updates have led to recent concerns. Stability varies by use case.

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

Download our OpenText Analytics Database (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

17%

Manufacturing Company

Comms Service Provider

University

Real Estate/Law Firm

Retailer

Insurance Company

Educational Organization

Hospitality Company

Media Company

Healthcare Company

Legal Firm

Energy/Utilities Company

Construction Company

Wholesaler/Distributor

Government

Outsourcing Company

Performing Arts

Recreational Facilities/Services Company

Pharma/Biotech Company

Non Profit

Renewables & Environment Company

Transportation Company

Logistics Company

Compare OpenText Analytics Database (Vertica) with alternative products

Learn more about OpenText Analytics Database (Vertica)

OpenText Analytics Database Vertica is designed to handle substantial data volumes with a focus on speed and efficient storage through its columnar architecture. It offers advanced performance features like workload isolation and compression, ensuring flexibility and high availability. The database is optimized for scalable data management, supporting data scientists and analysts with real-time reporting and analytics. Its architecture is built to facilitate hybrid deployments on-premises or within cloud environments, integrating seamlessly with business intelligence tools like Tableau. However, challenges such as improved transactional capabilities, optimized delete processes, and better real-time loading need addressing.

What features define OpenText Analytics Database Vertica?

Fast Data Loading: Quickly ingests large data volumes.
Columnar Storage: Optimizes storage efficiency and speed.
OLAP Support: Provides robust analytics capabilities.
Advanced Compression: Enhances storage efficiency and performance.
Parallel Data Ingestion: Enables faster data processing.
Fault Tolerance: Ensures high availability and reliability.

What benefits should users expect?

Cost Efficiency: Low cost per TB is advantageous.
Scalability: Accommodates growing data needs seamlessly.
Integration Flexibility: Works well with BI tools like Tableau.
Real-Time Reporting: Delivers immediate insights for decision-making.

OpenText Analytics Database Vertica's implementation spans industries such as finance, healthcare, and telecommunications. It serves as a central data warehouse offering scalable management, high-speed processing, and geospatial functions. Companies benefit from its capacity to integrate machine learning and operational reporting, enhancing analytical capabilities.

OpenText Analytics Database (Vertica) was previously known as Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand.