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."Tools like the BI and SAS are excellent."
"Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products."
"It is a very stable database."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"It is not a pricey product compared to other data warehouse solutions."
"I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets."
"The most valuable features are the performance and usability."
"The data transmissions between the data models is the most valuable feature."
"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"The performance is very good and the aggregate records are fast."
"Its projections and encoding are excellent tools for tuning large volumes."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"Partition and join back to node are easy and simple for DBAs."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage."
"I think that the error messages need to be made more specific."
"I would like the tool to support different operating systems."
"The query is slow if we don't optimize it."
"SQL installation is pretty tricky. The scalability and customer support also should be improved."
"They need to incorporate a machine learning engine."
"We'd like to see it be a bit more compatible with other solutions."
"Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution."
"I would like the ability to do more real-time type updates instead of batch-oriented updates."
"Documentation has become much better, but can always use some improvement."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"When it is about to reach the maximum storage capacity, it becomes slow."
"The geospatial functionality could be designed better."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"The integration of this solution with ODI could be improved."
"It would be great if this were a managed service in AWS."
"It needs integration with multiple clouds."
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, VMware Tanzu Greenplum and Snowflake, 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.