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."The product is relatively easy to use because there is no indexing and no partitions."
"It allows for the storage of huge amounts of data."
"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 is a really powerful database system for reporting and data warehousing."
"The most valuable feature is that the solution is fully embedded in the AWS stack."
"The product offers good support for the data lake."
"Has a very user-friendly SQL editor and it's very easy to use the connectors."
"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."
"Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases."
"It is closely integrated with other products in the MS portfolio."
"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."
"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
"I like that it's integrated with other Azure products."
"This is a well-integrated solution and that integration empowers results."
"We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services."
"For people who struggle with IAM or role-based management, the setup isn't easy."
"Migrating data from other data sources can be challenging when you are working with multibyte character sets."
"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 Redshift is a little more expensive than other products."
"If you require a highly scalable solution, I would not recommend Amazon Redshift."
"Sometimes, it's difficult to get the metadata from Redshift."
"It lacks a few features which can be very useful, such as stored procedures"
"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"I think the biggest problem with the product is that it does a data ingest model, which is very expensive."
"Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release."
"The pricing model needs to be improved."
"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps."
"We need better real-time analytics capabilities. It's a bit challenging for us."
"Microsoft Analytics Platform System could have better support."
"Functionality needs to be more up-to-date with competing products."
"Hybrid environments are complex to manage."
More Microsoft Analytics Platform System Pricing and Cost Advice →
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 reviews while Microsoft Analytics Platform System is ranked 16th 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 Teradata, Snowflake, AWS Lake Formation, 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.