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."The most valuable feature is that the solution is fully embedded in the AWS stack."
"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."
"The most valuable feature is the scalability, as it grows according to our needs."
"The stability of Amazon Redshift is good."
"The main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services."
"I like it because the usage is very similar to Microsoft SQL server. The structure of the query and the temporary tables are very similar."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"Redshift has an advantage when it comes to administration, making it easier to manage and collaborate."
"The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."
"The solution's integration is good."
"It is a very stable database."
"It handles high volumes of data very well."
"One of the most important features is the ease of using MS SQL."
"It is not a pricey product compared to other data warehouse solutions."
"The most valuable feature of this solution is performance."
"Collecting the data through SSIS packages from different sources and putting them all in one data repository is the most powerful thing. While others have this feature, they don't have the simplicity or ease of use when getting a resource and knowing everything about it."
"It lacks a few features which can be very useful, such as stored procedures"
"One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum."
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"I would like to improve the pricing and the simplicity of using this solution."
"Planting is the primary key enforcement that should be improved."
"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."
"AWS Snowflake has a very good feature for cloning databases. It makes it easy to clone a data warehouse, which is useful. I would like to see this feature in Redshift."
"Migrating data from other data sources can be challenging when you are working with multibyte character sets."
"The feature updates on the on-premise solution come very slowly, and it would be great if they came faster."
"The reporting for certain types of data needs to be improved."
"The product must provide more frequent 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."
"It could offer more development across the solution."
"Some compatibility issues occur during deployment, so we need to build the product from scratch for some features."
"The query is slow if we don't optimize it."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 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 AWS Lake Formation, Snowflake, Teradata, Vertica and Microsoft Azure Synapse Analytics, whereas Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA, VMware Tanzu Greenplum 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.