We performed a comparison between Amazon Redshift and Microsoft Analytics Platform System 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."I find the most valuable features to be the MPP style of processing, which mostly all of the data warehouses provide. The ability to integrate all other AWS services, such as NSS and S3, with little effort is very helpful. The service is well maintained, there are update patches frequently."
"Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there."
"Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten."
"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"The solution is scalable. It handles different loads very well."
"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 of Amazon Redshift is its ability to handle really large sets of data."
"The most valuable features of Amazon Redshift are that its fast and efficient. We have lots of TBs of data and it's very fast."
"Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases."
"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
"We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services."
"This is a well-integrated solution and that integration empowers results."
"The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics."
"Helps our customers to discover trends, which provides useful information based on their business."
"I like that it's integrated with other Azure products."
"It is closely integrated with other products in the MS portfolio."
"For people who struggle with IAM or role-based management, the setup isn't easy."
"Planting is the primary key enforcement that should be improved."
"It would be good to see Redshift as a serverless offering."
"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."
"The solution is unable to work fast."
"In terms of improvement, I believe Amazon Redshift could work on reducing its costs, as they tend to increase significantly. Additionally, there are occasional issues with nodes going down, which can be problematic."
"The initial deployment was complex."
"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."
"Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release."
"Functionality needs to be more up-to-date with competing products."
"Hybrid environments are complex to manage."
"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps."
"Microsoft Analytics Platform System could have better support."
"The pricing model needs to be improved."
"We need better real-time analytics capabilities. It's a bit challenging for us."
"Machine learning and artificial intelligence capabilities need to be more friendly for beginning users."
More Microsoft Analytics Platform System Pricing and Cost Advice →
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 reviews while Microsoft Analytics Platform System is ranked 17th in Data Warehouse with 9 reviews. Amazon Redshift is rated 7.8, while Microsoft Analytics Platform System is rated 6.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 Analytics Platform System writes "Offers smooth data integration between systems, but requires better real-time analytics capabilities". Amazon Redshift is most compared with AWS Lake Formation, Snowflake, Teradata, Vertica and Microsoft Azure Synapse Analytics, whereas Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics, Teradata, IBM Netezza Performance Server and Snowflake. See our Amazon Redshift vs. Microsoft Analytics Platform System 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.