We performed a comparison between Microsoft Parallel Data Warehouse and Vertica based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It performs very well overall."
"It is not a pricey product compared to other data warehouse solutions."
"The solution's integration is good."
"I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets."
"One of the most important features is the ease of using MS SQL."
"The most valuable feature for me is querying."
"The solution has been reliable."
"The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."
"I like the projection feature, which increases query performance."
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"I enjoy the cybersecurity and backup features."
"I have found the solution to be scalable."
"Speed and resiliency are probably the best parts of this product."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"I think that the error messages need to be made more specific."
"I would like to see better visualization features."
"The solution is expensive and has room for improvement."
"It needs more compatibility with common BI tools."
"The product must provide more frequent updates."
"I would like the ability to do more real-time type updates instead of batch-oriented updates."
"We'd like to see it be a bit more compatible with other solutions."
"The only issue with the product is that the process is very slow when we have a huge amount of data."
"The geospatial functionality could be designed better."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
"I believe the installation process could be streamlined."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
"Limitations in group by projections is where I would like to see an improvement."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"It would be great if this were a managed service in AWS."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →
Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 12 reviews while Vertica is ranked 4th in Data Warehouse with 10 reviews. Microsoft Parallel Data Warehouse is rated 7.6, while Vertica is rated 8.4. The top reviewer of Microsoft Parallel Data Warehouse writes "User-friendly UI and good support". On the other hand, the top reviewer of Vertica writes "Reliable and feature-rich, with optimization techniques to fine-tune queries for faster report generation". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA, Snowflake and VMware Tanzu Greenplum, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata. See our Microsoft Parallel Data Warehouse vs. 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.