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."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."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"Redshift allows you to transform different data formats and consolidate them into one Redshift cluster. This means you can transform various siloed data sources like Excel files and CSV files into Redshift."
"The most valuable feature is that the solution is fully embedded in the AWS stack."
"The solution is scalable. It handles different loads very well."
"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."
"The solution has very competitive pricing."
"The most valuable feature of this solution is performance."
"The data transmissions between the data models is the most valuable feature."
"We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"The most valuable features are the performance and usability."
"The solution's integration is good."
"I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets."
"Data collection and reporting are valuable features of the solution."
"We are using third-party tools to integrate Amazon Redshift, they should create their own interface on their own for it to be easily connected on the AWS itself."
"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."
"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"There are too many limitations with respect to concurrency."
"In our experiments, the handling of unstructured data was not very smooth."
"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."
"The refreshment rate of data reaching Redshift from other sources should be faster."
"It could be made more user-friendly for business users which would increase the user base."
"The solution is expensive and has room for improvement."
"SQL installation is pretty tricky. The scalability and customer support also should be improved."
"I think that the error messages need to be made more specific."
"The query is slow if we don't optimize it."
"The only issue with the product is that the process is very slow when we have a huge amount of data."
"More tools to help designers should be included."
"The product must provide more frequent updates."
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.