Compare Microsoft Parallel Data Warehouse vs. Vertica
Microsoft Parallel Data Warehouse is ranked 7th in Data Warehouse with 9 reviews while Vertica is ranked 6th in Data Warehouse with 4 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 "Allows us to take volumes and process them at a very high speed". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure SQL Data Warehouse, Oracle Exadata, Snowflake, VMware Tanzu Greenplum and SAP BW4HANA, whereas Vertica is most compared with Snowflake, Apache Hadoop, Teradata, Amazon Redshift and SQL Server. See our Microsoft Parallel Data Warehouse vs. Vertica report.
 |
Most Helpful Review | |
 Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Vertica and other solutions. Updated: July 2020. 430,223 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 | |
Collecting the data through SSIS packages from different sources and putting them all in one data repository is the most powerful thing. While others have this feature, they don't have the simplicity or ease of use when getting a resource and knowing everything about it. We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it. The most valuable feature is the business intelligence (BI) part of it. The data transmissions between the data models is the most valuable feature. The most valuable feature of this solution is performance. One of the most important features is the ease of using MS SQL. The most valuable feature for me is querying. The most valuable features are the performance and usability. | 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. The performance is very good and the aggregate records are fast. Eighty percent of the ETL operations have improved since implementing this solution. It maximize cloud economics for mission-critical big data analytical initiatives. It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands. |
Cons | |
I would like the tool to support different operating systems. If the database is large with a lot of columns then it is difficult to clean the data. This solution would be improved with an option for in-memory data analysis. The reporting for certain types of data needs to be improved. I think that the error messages need to be made more specific. I would like to see better visualization features. More tools to help designers should be included. 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. | 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. When it is about to reach the maximum storage capacity, it becomes slow. Fact-to-fact joins on multi-billion record tables perform poorly. It needs integration with multiple clouds. |
Pricing and Cost Advice | |
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. I think the program is well-priced compared to the other offerings that are out in the market. More Microsoft Parallel Data Warehouse Pricing and Cost Advice » | It is fast to purchase through the AWS Marketplace. The pricing and licensing depend on the size of your environment and the zone where you want to implement. |
 Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs. 430,223 professionals have used our research since 2012. | |
Ranking  | |
Views 2,634 Comparisons 1,930 Reviews 9 Average Words per Review 463 Avg. Rating 7.7 | Views 15,293 Comparisons 8,760 Reviews 4 Average Words per Review 199 Avg. Rating 9.0 |
Popular Comparisons | |
 Compared 22% of the time.  Compared 19% of the time.  Compared 18% of the time.  Compared 9% of the time.  Compared 2% of the time. | Compared 22% of the time.  Compared 12% of the time.  Compared 10% of the time.  Compared 9% of the time. Compared 8% of the time. |
Also Known As | |
| Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse | Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand |
Learn | |
| Microsoft | Micro Focus |
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 | |
Computer Software Company30% Comms Service Provider10% Healthcare Company10% Hospitality Company10% Computer Software Company35% Financial Services Firm8% Comms Service Provider7% Media Company7% | Media Company21% Computer Software Company21% Marketing Services Firm17% Comms Service Provider14% Computer Software Company43% Comms Service Provider11% Media Company9% K 12 Educational Company Or School5% |
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Vertica and other solutions. Updated: July 2020.
430,223 professionals have used our research since 2012.
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.