We performed a comparison between Amazon Redshift and Microsoft Parallel Data Warehouse 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."Redshift is a major service of Amazon and is very scalable. It enables faster recalculations and data management, helping to retrieve data quickly."
"It's scalable because it's on the cloud."
"It's very easy to migrate from other databases to Redshift. There are migration tools dedicated for this purpose, enabling migration from other databases like MS SQL directly to Redshift. The majority of the scripts will be automatically transposed."
"Easy to build out our snowflake design and load data."
"The stability of Amazon Redshift is good."
"The product offers good support for the data lake."
"The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good."
"The most valuable feature is the scalability, as it grows according to our needs."
"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 for me is querying."
"Data collection and reporting are valuable features of the solution."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"The solution has been reliable."
"It is not a pricey product compared to other data warehouse solutions."
"The solution's integration is good."
"The most valuable features are the performance and usability."
"I would like to improve the pricing and the simplicity of using this solution."
"There is some missing functionality and sometimes it's so difficult to work in. We need to convert these functionalities using VACUUM inside Amazon Redshift and then it causes some complexity."
"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"We recently moved from the DC2 cluster to the RA3 cluster, which is a different node type and we are finding some issues with the RA3 cluster regarding connection and processing. There is room for improvement in this area. We are in talks with AWS regarding the connection issues."
"It would be good to see Redshift as a serverless offering."
"The customer support could be more responsive."
"The refreshment rate of data reaching Redshift from other sources should be faster."
"When working with third-party services requires additional integrations and configurations, which can sometimes add more cost."
"The product does not have all of the features that the native products have."
"We'd like to see it be a bit more compatible with other solutions."
"I would like to see better visualization features."
"It needs more compatibility with common BI tools."
"Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution."
"This solution would be improved with an option for in-memory data analysis."
"I would like the ability to do more real-time type updates instead of batch-oriented updates."
"They need to incorporate a machine learning engine."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 reviews while Microsoft Parallel Data Warehouse is ranked 9th in Data Warehouse with 32 reviews. Amazon Redshift is rated 7.8, while Microsoft Parallel Data Warehouse is rated 7.6. The top reviewer of Amazon Redshift writes "Provides one place where we can store data, and allows us to easily connect to other services with AWS". On the other hand, 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". Amazon Redshift is most compared with Teradata, Vertica, Snowflake, Microsoft Azure Synapse Analytics and AWS Lake Formation, whereas Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA and Snowflake. See our Amazon Redshift vs. Microsoft Parallel Data Warehouse 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.