Compare Microsoft Parallel Data Warehouse vs. Vertica

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Vertica and other solutions. Updated: May 2021.
511,307 professionals have used our research since 2012.
Quotes From Members

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

Pros
"I am very satisfied with the customer service/technical support.""The most valuable features are the performance and usability.""The most valuable feature for me is querying.""One of the most important features is the ease of using MS SQL.""The most valuable feature of this solution is performance.""The data transmissions between the data models is the most valuable feature.""The most valuable feature is the business intelligence (BI) part of it.""We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."

More Microsoft Parallel Data Warehouse Pros »

"Eighty percent of the ETL operations have improved since implementing this solution.""The performance is very good and the aggregate records are fast.""Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data.""Allows us to take volumes and process them at a very high speed.""For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments.""Speed and resiliency are probably the best parts of this product.""It has improved my organization's functionality and performance.""The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."

More Vertica Pros »

Cons
"In the future I would love to see a slightly better automation engine, just for the data integration layer, to make it slightly easier for end-users or junior developers to get involved in incremental updating.""More tools to help designers should be included.""I would like to see better visualization features.""I think that the error messages need to be made more specific.""The reporting for certain types of data needs to be improved.""This solution would be improved with an option for in-memory data analysis.""If the database is large with a lot of columns then it is difficult to clean the data.""I would like the tool to support different operating systems."

More Microsoft Parallel Data Warehouse Cons »

"Fact-to-fact joins on multi-billion record tables perform poorly.""When it is about to reach the maximum storage capacity, it becomes slow.""Support is an area where it could get better.""Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be.""Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint.""The geospatial functionality could be designed better.""We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well.""They could improve on customer service."

More Vertica Cons »

Pricing and Cost Advice
"I think the program is well-priced compared to the other offerings that are out in the market.""Microsoft has an agreement with the government in our country, so our customers get their licensing costs from the Ministry. Whenever we work with any government, company, or government institute, which is mainly what we are doing, that license comes directly from the Ministry of Technology and Information.""All the features that we use do not require any additional subscription or yearly fees."

More Microsoft Parallel Data Warehouse Pricing and Cost Advice »

"From a cost perspective, the software is less than most of its competitors.""It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy.""The price could be cheaper and it is best to negotiate the price."

More Vertica Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
511,307 professionals have used our research since 2012.
Questions from the Community
Top Answer: I'd like to connect something like ES that I can use on objects on our SQL Server. We'd like to be able to understand how to export data to something like Semantic Technologies or like Graph DB. Some… more »
Top Answer: The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful.
Top Answer: It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy.
Top Answer: The product could be less expensive and could benefit from a better marketing strategy. In a future release, I would like to have one application to help create intelligent models.
Ranking
6th
out of 30 in Data Warehouse
Views
2,570
Comparisons
1,902
Reviews
11
Average Words per Review
486
Rating
7.6
4th
out of 30 in Data Warehouse
Views
12,463
Comparisons
7,530
Reviews
6
Average Words per Review
513
Rating
9.0
Popular Comparisons
Also Known As
Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse, MS Parallel Data Warehouse, MS Parallel Data Warehouse
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
Learn More
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.

Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.

To learn more about Micro Focus Vertica Advanced Analytics, visit our website.

Offer
Learn more about Microsoft Parallel Data Warehouse
Learn more about Vertica
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.
Top Industries
REVIEWERS
Computer Software Company27%
Pharma/Biotech Company18%
Comms Service Provider9%
Hospitality Company9%
VISITORS READING REVIEWS
Computer Software Company25%
Comms Service Provider15%
Financial Services Firm10%
Insurance Company7%
REVIEWERS
Computer Software Company23%
Media Company19%
Marketing Services Firm16%
Comms Service Provider13%
VISITORS READING REVIEWS
Computer Software Company33%
Comms Service Provider17%
Financial Services Firm7%
Media Company6%
Company Size
REVIEWERS
Small Business32%
Midsize Enterprise18%
Large Enterprise50%
REVIEWERS
Small Business31%
Midsize Enterprise24%
Large Enterprise45%
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Vertica and other solutions. Updated: May 2021.
511,307 professionals have used our research since 2012.

Microsoft Parallel Data Warehouse is ranked 6th in Data Warehouse with 11 reviews while Vertica is ranked 4th in Data Warehouse with 8 reviews. Microsoft Parallel Data Warehouse is rated 7.6, while Vertica is rated 9.0. The top reviewer of Microsoft Parallel Data Warehouse writes "Collects data through SSIS packages from different sources and puts them all in one data repository". On the other hand, the top reviewer of Vertica writes "Superior performance in speed and resilience makes this a very good warehousing solution". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, Snowflake and SAP BW4HANA, whereas Vertica is most compared with Snowflake, Amazon Redshift, Teradata, SQL Server and Apache Hadoop. See our Microsoft Parallel Data Warehouse vs. Vertica report.

See our list of best 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.