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."Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products."
"It performs very well overall."
"The most valuable feature of this solution is performance."
"It handles high volumes of data very well."
"I am very satisfied with the customer service/technical support."
"It is a very stable database."
"The solution has been reliable."
"Data collection and reporting are valuable features of the solution."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"The most valuable feature of Vertica is the unmatchable database performance."
"The extensibility and efficiency provided by their C++ SDK."
"Its projections and encoding are excellent tools for tuning large volumes."
"It has improved my organization's functionality and performance."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"The solution is quick, has good compression data, and is not expensive."
"It could be made more user-friendly for business users which would increase the user base."
"The only issue with the product is that the process is very slow when we have a huge amount of data."
"We find the cost of the solution to be a little high."
"I think that the error messages need to be made more specific."
"The feature updates on the on-premise solution come very slowly, and it would be great if they came faster."
"I would like to see better visualization features."
"The reporting for certain types of data needs to be improved."
"Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced."
"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."
"Documentation has become much better, but can always use some improvement."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility."
"It would be great if this were a managed service in AWS."
"We faced some challenges when trying to use the temporary tables feature."
"The integration with AI has room for improvement."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →
Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 32 reviews while Vertica is ranked 4th in Data Warehouse with 82 reviews. Microsoft Parallel Data Warehouse is rated 7.6, while Vertica is rated 8.4. The top reviewer of Microsoft Parallel Data Warehouse writes "An easy to setup tool that allows its users to write stored procedure, making it a scalable product". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". 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.