Amazon Redshift vs OpenText Analytics Database (Vertica) comparison

Amazon Redshift vs. OpenText Analytics Database (Vertica)

May 2026

Download the complete report

Helped 893,244 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

ROI

Sentiment score

6.0

Some entities quickly achieved cost savings and ROI, while others face challenges with optimization and evaluating benefits.

Sentiment score

6.2

Organizations achieved financial and operational gains with Vertica, reducing costs and processing time while enhancing analytics and performance.

We earned back our investment in Amazon Redshift within the first year.

For more quotes and insights, download the Amazon Redshift report

Data engineer at a tech vendor with 10,001+ employees

I saved a lot of money because the storage was on a cheaper alternative and was not directly on OpenText Analytics Database (Vertica), but on S3.

Senior Software Engineer at a tech vendor with 5,001-10,000 employees

The time we used to take with our earlier databases has reduced to one-tenth of what was there earlier, which is a positive outcome that can be converted to financial metrics in terms of return on investment.

For more quotes and insights, download the OpenText Analytics Database (Vertica) report

Data Engineering Associate Manager at a tech vendor with 10,001+ employees

Customer Service

Sentiment score

6.8

Amazon Redshift support is efficient yet costly, praised for documentation, but phone contact and complex issue resolution face delays.

Sentiment score

7.1

OpenText Analytics Database's customer service is generally valued for expertise but has occasional response time and escalation issues.

Whenever we need support, if there is an issue accessing stored data due to regional data center problems, the Amazon team is very helpful and provides optimal solutions quickly.

Pavan Kum

Analyst at Cepstrum(EEE Students Society), IIT Guwahati

Documentation that allows anyone with prior knowledge of Redshift or SQL to resolve technical issues.

For more quotes and insights, download the Amazon Redshift report

Data engineer at a tech vendor with 10,001+ employees

It's costly when you enable support.

RiteshPurbey

Senior Analyst at ESRI INDIA

Throughout this process, customer support was outstanding, and we had a person actively supporting us from the OpenText Analytics Database (Vertica) team for our use case.

Senior Software Engineer at a tech vendor with 5,001-10,000 employees

Overall, our experience with OpenText Analytics Database (Vertica) customer support has been good and reliable.

For more quotes and insights, download the OpenText Analytics Database (Vertica) report

consultant at tcs

Scalability Issues

Sentiment score

7.3

Amazon Redshift is highly scalable with flexible cluster adjustments, despite some challenges at larger scales and heavy loads.

Sentiment score

7.2

OpenText Vertica offers scalable, efficient data handling with robust performance, though pricing and node addition may challenge some users.

The scalability part needs improvement as the sizing requires trial and error.

Data Analytics, Ai & Automation Lead at a venture capital & private equity firm with 10,001+ employees

We have successfully increased our storage space, which was a smooth process without server crashes before or after scaling.

For more quotes and insights, download the Amazon Redshift report

Data engineer at a tech vendor with 10,001+ employees

We have experienced easy horizontal scaling, consistent query performance as data grew, and the ability to handle large analytic workloads.

consultant at tcs

OpenText Analytics Database (Vertica) has very good scalability.

For more quotes and insights, download the OpenText Analytics Database (Vertica) report

Data Engineering Associate Manager at a tech vendor with 10,001+ employees

OpenText Analytics Database (Vertica) can scale to a great extent.

Anuj Chourasia

Analytics Manager at a wholesaler/distributor with 10,001+ employees

Stability Issues

Sentiment score

7.3

Opinions on Amazon Redshift's stability vary, with some praising reliability and others noting issues in large clusters or maintenance.

Sentiment score

7.2

OpenText Analytics Database offers high stability and performance, with successful migrations and minimal clustering issues ensuring user satisfaction.

Amazon Redshift is a stable product, and I would rate it nine or ten out of ten for stability.

For more quotes and insights, download the Amazon Redshift report

Data Analytics, Ai & Automation Lead at a venture capital & private equity firm with 10,001+ employees

OpenText Analytics Database (Vertica) is very stable.

For more quotes and insights, download the OpenText Analytics Database (Vertica) report

Senior Software Engineer at a tech vendor with 5,001-10,000 employees

Room For Improvement

Amazon Redshift users face challenges with performance, integration, cost, and features, preferring improved solutions like Snowflake's offerings.

OpenText Analytics Database needs improvements in community, cloud features, SQL, integration, cost efficiency, machine learning, and developer tools.

They should bring the entire ETL data management process into Amazon Redshift.

Data Analytics, Ai & Automation Lead at a venture capital & private equity firm with 10,001+ employees

Integration with AI could be a good improvement.

Pavan Kum

Analyst at Cepstrum(EEE Students Society), IIT Guwahati

Integration with AI features could elevate its capabilities and popularity.

For more quotes and insights, download the Amazon Redshift report

Data engineer at a tech vendor with 10,001+ employees

Smarter automatic projection management is needed with more intelligence, auto projection creation, automatic optimization, and reduced manual testing with better workload management.

consultant at tcs

Projections could be made more dynamic, and if they could find a faster way to update, insert, and delete data, that would also be helpful.

Senior Software Engineer at a tech vendor with 5,001-10,000 employees

OpenText Analytics Database (Vertica) does not have a cloud-based UI that Snowflake has, which features a very good comprehensive GUI for querying and analyzing data.

For more quotes and insights, download the OpenText Analytics Database (Vertica) report

Data Engineering Associate Manager at a tech vendor with 10,001+ employees

Setup Cost

Amazon Redshift offers mid-to-high pricing, seen as reasonable due to its scalability and potential cost-effectiveness compared to competitors.

OpenText Analytics Database offers flexible pricing, often cost-effective for its advanced features, despite being pricey vs. open-source solutions.

The cost of technical support is high.

RiteshPurbey

Senior Analyst at ESRI INDIA

It's a pretty good price and reasonable for the product quality.

For more quotes and insights, download the Amazon Redshift report

Data Analytics, Ai & Automation Lead at a venture capital & private equity firm with 10,001+ employees

The pricing of Amazon Redshift is expensive.

reviewer1099677

Co-Founder, Director at a tech consulting company with 51-200 employees

The pricing for OpenText Analytics Database (Vertica) is somewhat on the higher side for the license.

For more quotes and insights, download the OpenText Analytics Database (Vertica) report

Senior Software Engineer at a tech vendor with 5,001-10,000 employees

Valuable Features

Amazon Redshift offers scalability, fast queries, AWS integration, flexibility, security, cost-effectiveness, easy setup, and compatibility for complex data management.

OpenText Analytics Database excels in fast query responses, scalability, and real-time insights, enhancing decision-making and operational efficiency.

Amazon Redshift's performance optimization and scalability are quite helpful, providing functionalities such as scaling up and down.

For more quotes and insights, download the Amazon Redshift report

Data Analytics, Ai & Automation Lead at a venture capital & private equity firm with 10,001+ employees

Scalability is also a strong point; I can scale it however I want without any limitations.

reviewer1099677

Co-Founder, Director at a tech consulting company with 51-200 employees

The specific features of Amazon Redshift that are beneficial for handling large data sets include fast retrieval due to cloud services and scalability, which allows us to retrieve data quickly.

Pavan Kum

Analyst at Cepstrum(EEE Students Society), IIT Guwahati

I can use it in Eon Mode in which I can store the data in cheaper storage such as Amazon S3 and have different compute nodes.

Senior Software Engineer at a tech vendor with 5,001-10,000 employees

Projection and columnar storage are the most valuable features because they dramatically improve query performance and reduce the need for index management.

consultant at tcs

The best features that OpenText Analytics Database (Vertica) offers are mainly the parallel processing, ETL capabilities, and the multi-cloud features which are very handy to use.

For more quotes and insights, download the OpenText Analytics Database (Vertica) report

Data Engineering Associate Manager at a tech vendor with 10,001+ employees

Categories and Ranking

Amazon Redshift

Ranking in Data Warehouse

6th

Ranking in Cloud Data Warehouse

6th

Average Rating

7.8

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Database Management Systems (DBMS) (8th)

OpenText Analytics Database...

Ranking in Data Warehouse

5th

Ranking in Cloud Data Warehouse

11th

Average Rating

8.2

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of May 2026, in the Data Warehouse category, the mindshare of Amazon Redshift is 4.6%, down from 7.9% compared to the previous year. The mindshare of OpenText Analytics Database (Vertica) is 5.7%, down from 8.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Warehouse Mindshare Distribution
Product	Mindshare (%)
OpenText Analytics Database (Vertica)	5.7%
Amazon Redshift	4.6%
Other	89.7%

Data Warehouse

Featured Reviews

Optimized restaurant analytics has driven faster insights and streamlined daily reporting

Data engineer at a tech vendor with 10,001+ employees

Amazon Redshift offers massive parallel processing capability, allowing it to handle millions of records, along with integration with other AWS features such as S3 and QuickSight. The column-level storage supports high performance and easy data retrieval compared to other tools. The integration with S3 has helped my team immensely since S3 is our starting source, and the direct integration with Amazon Redshift simplifies the transformation and loading process. Columnar storage has benefited our performance significantly, allowing us to extract specific rows from tables with years of data much faster than other tools with row-level storage. Amazon Redshift has positively impacted our organization by significantly improving query performance and speed. Features such as easy integration with S3 allow us to process millions of records efficiently, ultimately saving us nearly one hour per day for our project.

Read full review

Data warehousing has transformed reporting performance and now delivers near real-time insights

consultant at tcs

OpenText Analytics Database (Vertica) is a very powerful analytic database, but like any platform, there are areas where it can improve to make daily work even smoother. Better cloud-native experience is one area for improvement. OpenText Analytics Database (Vertica) was originally designed as an on-premises analytic database and later moved to cloud. Improvement opportunities include more seamless cloud-native features such as auto-scaling, serverless options, and easier cluster management. Competitors such as Snowflake and BigQuery provide more fully managed experiences. Easier UI is another area for improvement. Most administration is currently done by SQL and command line tools. An improvement opportunity would be a more modern web UI for monitoring, workload management, and troubleshooting. Faster ecosystem and community growth is needed. In short, OpenText Analytics Database (Vertica) could improve in areas such as cloud-native capability, modern UI for administration, stronger real-time streaming integration, and growing its ecosystem and community. These enhancements would make it easier to manage and adopt compared to newer cloud-first analytic platforms. From a day-to-day operational perspective, there are a few areas where OpenText Analytics Database (Vertica) could improve to make our work smoother. Smarter automatic projection management is needed with more intelligence, auto projection creation, automatic optimization, and reduced manual testing with better workload management. Right now, monitoring queries often requires system tables and manual analysis. Troubleshooting slow queries takes time. A modern real-time dashboard showing query bottlenecks and resource users would enable quick detection. The impact could be faster issue resolution and less time spent debugging performance. Storage native interaction with modern data tools is also important. In short, from a day-to-day perspective, improvements in automatic projection optimization, better workload monitoring dashboard, easier schema evolution, and stronger modern tool integration would significantly reduce manual tuning effort and improve developer productivity. While OpenText Analytics Database (Vertica) is very powerful, these enhancements would make it more efficient for the analytics team.

Read full review

See which vendors are best for you

Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.

See recommendations

893,244 professionals have used our research since 2012.

Answers from the Community

Miriam Tover

Service Delivery Manager at PeerSpot

Jul 16, 2019

What is the biggest difference between Amazon Redshift and Vertica

See 2 answers

Karl Fonseca

Channel Development Executive, Enterprise Computing Solutions (ECS) at a tech services company with 10,001+ employees

Jul 15, 2019

* Flexibility of deployment: Amazon Redshift can only be deployed on the AWS. Redshift lacks support for the hybrid cloud-and-on premises data warehousing combinations. Vertica’s industry-leading deployment options allow customers to run Vertica on AWS, Azure, Google Cloud Platform, on-premise, and on Hadoop. * Speed: The query execution performance of Vertica and Redshift and some of the differentiators in the two products with Vertica query response times on the 5 TB dataset, 20 concurrent user test, for example, were 3.4 times faster. Also, when over 100 users are simultaneously running queries on the same data, Amazon Redshift’s performance degrades considerably, leading to hours or even days of query response times. Which of these two solutions would you recommend to a colleague evaluating cloud data warehouses and why? Vertica. As Vertica has flexibility as your data warehouse evolves long term with best in class speed.

Read full answer

Rama Subrahmanyam Vedula

Sr.Manager - DevOps/Cloud/AI Projects at a tech services company with 201-500 employees

Jul 16, 2019

I am assuming you are asking me a question. I have similar points like the one you sent in the link. However, I will narrow it down further with highlighted ones that matter. Redshift is cloud-native so not a good idea if you also need a data center. It does not support document store, so that's another limitation. Vertica works for the hybrid environment and also supports more APIs and supports all familiar languages. Look at more features as given in the below table and decide. I would go with Vertica if there is a hybrid cloud, needs document store, secondary indexes are a critical need and need support for more APIs (as given in the table). For AWS native environment, go with RedShift. Amazon Redshift X: Description: Large scale data warehouse service for use with business intelligence tools. Primary database model: Relational DBMS Secondary database models: Key-value store Website: aws.amazon.com/redshift Technical documentation: docs.aws.amazon.com/redshift Developer: Amazon (based on PostgreSQL) License: commercial Cloud-based only: Yes XML Support: No Secondary indexes: Restricted SQL: Yes APIs and other access methods: JDBC, ODBC Supported programming languages: All languages supporting JDBC/ODBC Server-side scripts: User-defined functions Triggers: No Vertica X: Description: Columnar relational DBMS designed to handle modern analytic workloads, enabling fast query performance. Primary database model: Relational DBMS Secondary database models: Key-value store, Document store Website: www.vertica.com Technical documentation: www.vertica.com/documentation/vertica Developer: Vertica / Micro Focus License: Commercial Cloud-based only: No XML Support: Yes Secondary indexes: No SQL: Yes APIs and other access methods: Kafka, Proprietary protocol, RESTful HTTP API, ADO.NET, JDBC, ODBC Supported programming languages: C++, Java, Perl, Python, R Server-side scripts: Yes Triggers: No

Read full answer

Top Industries

By visitors reading reviews

Financial Services Firm

20%

Manufacturing Company

Computer Software Company

Construction Company

Financial Services Firm

18%

Computer Software Company

12%

Manufacturing Company

Comms Service Provider

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	27
Midsize Enterprise	21
Large Enterprise	29

By reviewers
Company Size	Count
Small Business	29
Midsize Enterprise	23
Large Enterprise	43

Questions from the Community

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?

Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different dat...

What is your experience regarding pricing and costs for Amazon Redshift?

My experience with pricing and setup cost is satisfactory, as we have been loyal clients of Amazon since the beginning of our organization. However, I am not aware of the exact costs associated wit...

What needs improvement with Amazon Redshift?

Amazon Redshift could improve by enhancing its UI to be more user-friendly for non-technical users and by offering better cost management, as similar tools tend to be less expensive. Additionally, ...

What do you like most about Vertica?

Vertica is easy to use and provides really high performance, stability, and scalability.

What is your experience regarding pricing and costs for Vertica?

My experience with pricing, setup cost, and licensing is limited because the organization handled the licensing and pricing as well as the cost setup.

What needs improvement with Vertica?

OpenText Analytics Database (Vertica) is already doing great. There could be a community which could have been much more advanced and more people can be engaged so that any kind of questions, queri...

Snowflake vs Amazon Redshift

Comparisons

Compared 14% of the time

Teradata vs Amazon Redshift

Compared 8% of the time

Microsoft Azure Synapse Analytics vs Amazon Redshift

Compared 6% of the time

AWS Lake Formation vs Amazon Redshift

Compared 5% of the time

SAP BW4HANA vs Amazon Redshift

Compared 4% of the time

More Amazon Redshift Competitors

Teradata vs OpenText Analytics Database (Vertica)

Compared 7% of the time

Snowflake vs OpenText Analytics Database (Vertica)

Compared 7% of the time

Oracle Exadata vs OpenText Analytics Database (Vertica)

Compared 5% of the time

SAP IQ vs OpenText Analytics Database (Vertica)

Compared 4% of the time

VMware Tanzu Data Solutions vs OpenText Analytics Database (Vertica)

Compared 3% of the time

More OpenText Analytics Database (Vertica) Competitors

Product Reports

Download Amazon Redshift product report

Amazon Redshift

May 2026

OpenText Analytics Database (Vertica)

April 2026

OpenText Analytics Database (Vertica) report

Download OpenText Analytics Database (Vertica) product report

Also Known As

No data available

Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand

Overview

Amazon Redshift is a dynamic data warehousing and analytics platform offering scalability and seamless AWS integration for high-performance query processing and diverse data management.

Amazon Redshift provides robust data integration capabilities with AWS services like S3 and QuickSight, enabling efficient data warehousing and analytics. It is known for fast query performance due to its columnar storage and can handle diverse file formats. With a user-friendly SQL interface, Redshift supports data compression and offers a strong cost-performance ratio. Its secure VPC configurations and compatibility with data science tools enhance its functionality, although there is room for improving snapshot restoration, dynamic scaling, and processing large datasets.

What are the key features of Amazon Redshift?

Scalability: Allows growth with business needs, accommodating increasing data volumes.
Massive Parallel Processing: Speeds up query performance through parallel data processing.
Seamless AWS Integration: Connects smoothly with services like S3 and QuickSight for enhanced functionality.
Columnar Storage: Enhances query performance by storing data in columns.
User-friendly SQL Interface: Simplifies data query and manipulation.
Data Compression: Efficiently compresses data to reduce storage costs.

What benefits should users look for in reviews?

Cost-Performance Ratio: Offers competitive pricing with high processing efficiency.
Fast Query Performance: Delivers quick data retrieval and processing speeds.
Security Features: Ensures data security through VPC configurations.
Integration Flexibility: Easily integrates with data science tools and BI platforms.

In industries, Amazon Redshift is essential for managing extensive datasets for business intelligence, operational insights, and reporting. It supports data integration from ERPs and S3, handles SQL queries for comprehensive analysis, and facilitates data storage and transformation. Companies use it for predictive modeling and connect with BI tools like Tableau and Power BI to derive actionable insights.

Amazon Web Services (AWS)

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.

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

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449

Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.