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."Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"The valuable features are performance, data compression, and scalability."
"In terms of valuable features, I like the columnar storage that Redshift provides. The storage is one of the key features that we're looking for. Also, the data updates and the latency between the data-refreshes."
"For the on-premises version of Amazon Redshift, we need to start from scratch. However, with the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features."
"It allows you write complex queries and perform row by row processes."
"The feature that we find most useful is the ability to do analytics on the fly."
"The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it."
"Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time."
"We have complete control over our data."
"It performs very well overall."
"The most valuable feature is the business intelligence (BI) part of it."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"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."
"The most valuable features are the performance and usability."
"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."
"Amazon should provide more cloud-native tools that can integrate with Redshift like Microsoft's development tools for Azure."
"In the next release, a pivot function would be a big help. It could save a lot of time creating a query or process to handle operations."
"Running parallel queries results in poor performance and this needs to be improved."
"The initial setup is a complex process, especially for someone who is not familiar with nodes and configuring terms like RPUs."
"The solution could improve in handling more data formats and more native support for RDF."
"What would make Amazon Redshift better is improvising on the pricing structure. For example, Acronis provides backups in cybersecurity, yet the pricing is a bit lesser than Amazon Redshift."
"Migrating data from other data sources can be challenging when you are working with multibyte character sets."
"Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced."
"The only issue with the product is that the process is very slow when we have a huge amount of data."
"The query is slow if we don't optimize it."
"If the database is large with a lot of columns then it is difficult to clean the data."
"Some compatibility issues occur during deployment, so we need to build the product from scratch for some features."
"The product must provide more frequent updates."
"It could offer more development across the solution."
"The solution is expensive and has room for improvement."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 59 reviews while Microsoft Parallel Data Warehouse is ranked 8th 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 Snowflake, Teradata, AWS Lake Formation, Vertica and Microsoft Azure Synapse Analytics, whereas Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA, Snowflake and VMware Tanzu Greenplum. 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.