Try our new research platform with insights from 80,000+ expert users

Microsoft Parallel Data Warehouse vs OpenText Analytics Database (Vertica) comparison

Microsoft and OpenText are both solutions in the Data Warehouse category. Microsoft is ranked #10 with an average rating of 8.5, while OpenText is ranked #7 with an average rating of 7.6. Microsoft holds a 1.5% mindshare in Data Warehouse, compared to OpenText’s 6.9% mindshare. Additionally, 87% of Microsoft users are willing to recommend the solution, compared to 91% of OpenText users who would recommend it.
Microsoft Parallel Data War...
Read 39 Microsoft Parallel Data Warehouse reviews
  • 533 Views
  • 384 Comparison Views
87% willing to recommend
OpenText Analytics Database...
Read 86 OpenText Analytics Database (Vertica) reviews
  • 3,844 Views
  • 1,653 Comparison Views
91% willing to recommend
 

Comparison Buyer's Guide

Download the report
Executive SummaryUpdated on Sep 21, 2025

Microsoft Parallel Data Warehouse and OpenText Analytics Database (Vertica) are prominent contenders in the data warehousing sector. While both provide robust analytics, Vertica seems to have the upper hand due to its competitive pricing model and advanced analytics capabilities.

Features: Microsoft Parallel Data Warehouse stands out with its Power BI integration, user-friendly interface, and SQL Server command support. It offers extensive integration with SSIS packages and strong data management features such as data integrity. OpenText Analytics Database (Vertica) is known for its rapid query processing due to columnar storage, scalability, and efficient handling of large data sets with advanced analytics capabilities.

Room for Improvement: Microsoft Parallel Data Warehouse could benefit from easier setup and maintenance, better ETL tool compatibility, and enhanced connectivity with non-Microsoft products. Vertica faces challenges with its documentation and workload management. It could also improve integration with cloud environments and strengthen its machine learning capabilities.

Ease of Deployment and Customer Service: Both Microsoft Parallel Data Warehouse and OpenText Analytics Database (Vertica) provide flexible deployment options for public, private, and hybrid clouds. Both have good customer service, with Microsoft's broader support ecosystem highlighted as a strength. Vertica could improve its customer support documentation and update frequency.

Pricing and ROI: Microsoft Parallel Data Warehouse has a higher cost structure, suitable for large environments needing significant investment. Conversely, Vertica's pricing is flexible, focusing on data size rather than nodes, making it cost-effective for large-scale operations. Vertica often stands out for its competitive pricing and demonstrates strong ROI through efficient data management capabilities.

DOWNLOAD THE COMPLETE REPORT
To learn more, read our detailed Microsoft Parallel Data Warehouse vs. OpenText Analytics Database (Vertica) Report (Updated: September 2025).
Buyer's Guide
Microsoft Parallel Data Warehouse vs. OpenText Analytics Database (Vertica)
September 2025
Download the complete report
Helped 869,095 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
5.7
Most are satisfied with ROI, acknowledging its benefits, though improvements are possible, as it efficiently enhances backend operations.
Sentiment score
6.9
Users report significant ROI from OpenText Analytics Database due to enhanced analytics, performance, and data accessibility, despite its cost.
 

Customer Service

Sentiment score
6.7
Microsoft Parallel Data Warehouse support is responsive and expert, though users sometimes need online resources for faster solutions.
Sentiment score
7.0
OpenText Analytics Database customer service is praised for knowledgeable support, though some users report slow response and escalation needs.
I would rate my experience with technical support around six on a scale of 1 to 10 because I have not had a particular experience with technical support.
For more quotes and insights, download the Microsoft Parallel Data Warehouse report
No quotes available
For more quotes and insights, download the OpenText Analytics Database (Vertica) report
 

Scalability Issues

Sentiment score
7.2
Microsoft Parallel Data Warehouse excels in scalability, integration, and expandability, though improvements are needed for large data sets.
Sentiment score
7.1
OpenText Analytics Database (Vertica) excels at scaling large data volumes but faces challenges with schema modifications and node additions.
I give the scalability an eight out of ten, indicating it scales well for our needs.
As a consultant, we hire additional programmers when we need to scale up certain major projects.
For more quotes and insights, download the Microsoft Parallel Data Warehouse report
No quotes available
For more quotes and insights, download the OpenText Analytics Database (Vertica) report
 

Stability Issues

Sentiment score
8.0
Microsoft Parallel Data Warehouse is praised for its stability, reliability, and quick issue resolution, despite time-consuming extensive dataset processing.
Sentiment score
7.1
OpenText Analytics Database (Vertica) is stable and robust, with minor query and network issues noted by users.
Microsoft Parallel Data Warehouse is stable for us because it is built on SQL Server.
For more quotes and insights, download the Microsoft Parallel Data Warehouse report
No quotes available
For more quotes and insights, download the OpenText Analytics Database (Vertica) report
 

Room For Improvement

Microsoft Parallel Data Warehouse presents complexity, compatibility challenges, performance issues, high costs, and requires improved in-memory analysis and updates.
OpenText Analytics Database needs better workload management, documentation, SQL optimization, cloud support, machine learning, and cost efficiency.
Addressing the cost would be the number one area for improvement.
It would be better to release patches less frequently, maybe once a month or once every two months.
The ETL designing process could be optimized for better efficiency.
For more quotes and insights, download the Microsoft Parallel Data Warehouse report
No quotes available
For more quotes and insights, download the OpenText Analytics Database (Vertica) report
HassanFatemi - PeerSpot reviewerAshok Bhadra - PeerSpot reviewer
VJ
 

Setup Cost

Microsoft Parallel Data Warehouse's pricing varies by needs; Azure integration can be cost-effective, but technical support costs extra.
OpenText Analytics Database offers flexible pricing based on storage, with competitive costs, community edition, and negotiable licensing options.
Microsoft Parallel Data Warehouse is very expensive.
For more quotes and insights, download the Microsoft Parallel Data Warehouse report
No quotes available
For more quotes and insights, download the OpenText Analytics Database (Vertica) report
 

Valuable Features

Microsoft Parallel Data Warehouse offers performance, integration, flexibility, and cost-effectiveness for large data management and business intelligence.
OpenText Analytics Database offers rapid data processing, scalability, ease of use, and cost efficiency with advanced analytics capabilities.
The columnstore index enhances data query performance by using less space and achieving faster performance than general indexing.
The biggest advantage of Microsoft Parallel Data Warehouse is the possibility to stop or pause the service because it can be very expensive.
There's a feature that allows users to set alerts on triggers within reports, enabling timely actions on pending applications and effectively reducing waiting time.
For more quotes and insights, download the Microsoft Parallel Data Warehouse report
No quotes available
For more quotes and insights, download the OpenText Analytics Database (Vertica) report
VJ
HassanFatemi - PeerSpot reviewerAshok Bhadra - PeerSpot reviewer
 

Categories and Ranking

Microsoft Parallel Data War...
Ranking in Data Warehouse
10th
Average Rating
7.8
Reviews Sentiment
6.7
Number of Reviews
39
Ranking in other categories
No ranking in other categories
OpenText Analytics Database...
Ranking in Data Warehouse
7th
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Cloud Data Warehouse (11th)
 

Mindshare comparison

As of October 2025, in the Data Warehouse category, the mindshare of Microsoft Parallel Data Warehouse is 1.5%, up from 1.0% compared to the previous year. The mindshare of OpenText Analytics Database (Vertica) is 6.9%, down from 9.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse Market Share Distribution
ProductMarket Share (%)
OpenText Analytics Database (Vertica)6.9%
Microsoft Parallel Data Warehouse1.5%
Other91.6%
Data Warehouse
 

Featured Reviews

HassanFatemi - PeerSpot reviewer
Has handled large volumes of data effectively but still needs cost flexibility
There could be improvements on the cost side of Microsoft Parallel Data Warehouse because it is still considered to be quite expensive by a lot of users, and many companies are not interested in solutions with parallel data warehousing due to this expense. Addressing the cost would be the number one area for improvement. Additionally, I have not worked recently with it, so I don't know if this feature already exists, but if it doesn't, having an elastic feature that adjusts the service's power dynamically based on the workload would be beneficial instead of fixing the power at a specific level.
Read full review
T Venkatesh - PeerSpot reviewer
Processes query faster through multiple systems simultaneously, but it could support different data types
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
report
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
869,095 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
22%
Insurance Company
13%
Financial Services Firm
8%
Manufacturing Company
6%
Financial Services Firm
18%
Computer Software Company
16%
Manufacturing Company
8%
Comms Service Provider
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business16
Midsize Enterprise6
Large Enterprise21
By reviewers
Company SizeCount
Small Business29
Midsize Enterprise23
Large Enterprise38
 

Questions from the Community

What do you like most about Microsoft Parallel Data Warehouse?
Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time.
See all answers
What is your experience regarding pricing and costs for Microsoft Parallel Data Warehouse?
Microsoft Parallel Data Warehouse is very expensive.
See all answers
What needs improvement with Microsoft Parallel Data Warehouse?
There could be improvements on the cost side of Microsoft Parallel Data Warehouse because it is still considered to be quite expensive by a lot of users, and many companies are not interested in so...
See all answers
What do you like most about Vertica?
Vertica is easy to use and provides really high performance, stability, and scalability.
See all answers
What is your experience regarding pricing and costs for Vertica?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
See all answers
What needs improvement with Vertica?
The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases.
See all answers
 

Comparisons

Teradata vs Microsoft Parallel Data Warehouse Logo
Teradata vs Microsoft Parallel Data Warehouse
Compared 36% of the time
Microsoft Azure Synapse Analytics vs Microsoft Parallel Data Warehouse Logo
Microsoft Azure Synapse Analytics vs Microsoft Parallel Data Warehouse
Compared 34% of the time
Oracle Exadata vs Microsoft Parallel Data Warehouse Logo
Oracle Exadata vs Microsoft Parallel Data Warehouse
Compared 30% of the time
More Microsoft Parallel Data Warehouse Competitors
SQL Server vs OpenText Analytics Database (Vertica) Logo
SQL Server vs OpenText Analytics Database (Vertica)
Compared 13% of the time
Teradata vs OpenText Analytics Database (Vertica) Logo
Teradata vs OpenText Analytics Database (Vertica)
Compared 12% of the time
Snowflake vs OpenText Analytics Database (Vertica) Logo
Snowflake vs OpenText Analytics Database (Vertica)
Compared 8% of the time
BigQuery vs OpenText Analytics Database (Vertica) Logo
BigQuery vs OpenText Analytics Database (Vertica)
Compared 8% of the time
Oracle Exadata vs OpenText Analytics Database (Vertica) Logo
Oracle Exadata vs OpenText Analytics Database (Vertica)
Compared 7% of the time
More OpenText Analytics Database (Vertica) Competitors
 

Product Reports

Buyer's Guide
Microsoft Parallel Data Warehouse
September 2025
Microsoft Parallel Data Warehouse reportDownload Microsoft Parallel Data Warehouse product report
Buyer's Guide
OpenText Analytics Database (Vertica)
September 2025
OpenText Analytics Database (Vertica) reportDownload OpenText Analytics Database (Vertica) product report
 

Also Known As

Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Overview

The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.

Microsoft

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

Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Buyer's Guide
Microsoft Parallel Data Warehouse vs. OpenText Analytics Database (Vertica)
September 2025
Free Report: Microsoft Parallel Data Warehouse vs. OpenText Analytics Database (Vertica)
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. OpenText Analytics Database (Vertica) and other solutions. Updated: September 2025.
DOWNLOAD NOW
869,095 professionals have used our research since 2012.
See our Microsoft Parallel Data Warehouse vs. OpenText Analytics Database (Vertica) report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.

We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.