We performed a comparison between Microsoft Analytics Platform System and Microsoft Azure Synapse Analytics 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 like that it's integrated with other Azure products."
"It is closely integrated with other products in the MS portfolio."
"This is a well-integrated solution and that integration empowers results."
"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
"Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases."
"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."
"We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services."
"The initial setup was really easy and straightforward."
"Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task."
"The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range."
"The most important feature for me is the integration with PolyBase."
"Data can be stored any way you want in the data warehouse."
"The MPP (Massively Parallel Processing) architecture helps to make things a lot faster."
"It is a fantastic product; we are satisfied with its features and performance."
"The most valuable features are the flexibility and that it's easy to use as an end-user compared to AWS."
"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps."
"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."
"Functionality needs to be more up-to-date with competing products."
"Hybrid environments are complex to manage."
"Microsoft Analytics Platform System could have better support."
"Machine learning and artificial intelligence capabilities need to be more friendly for beginning users."
"Microsoft Azure Synapse Analytics can improve by adding more flexibility to the reports. Having more visible structures based on the area, region and country would be beneficial."
"More integration is needed to improve the product for the future."
"In the future, Microsoft Azure Synapse Analytics could improve the performance, there are other solutions that are better, such as Databricks."
"The security performance and cost are the two things that needs improvement."
"I am very sure that there are areas in need of improvement, but I can't recall what they are off the top of my head."
"Microsoft Azure Synapse Analytics could improve its compatibility with Visual Studio. One of the challenges for people moving from an on-premise to a cloud solution, such as Microsoft Azure Synapse Analytics, is that you're constantly working in a browser. There are people that have been working for decades on desktop applications. For them to start working in a browser, it's quite a change. Allowing people to work and do their work inside Visual Studio than in the browser, would be a large advantage."
"We encountered data processing and transformation issues while working with Apache Spark languages for the product."
"I'd like to see part of the service de-coupled."
More Microsoft Analytics Platform System Pricing and Cost Advice →
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Microsoft Analytics Platform System is ranked 17th in Data Warehouse with 9 reviews while Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 85 reviews. Microsoft Analytics Platform System is rated 6.6, while Microsoft Azure Synapse Analytics is rated 7.8. The top reviewer of Microsoft Analytics Platform System writes "Offers smooth data integration between systems, but requires better real-time analytics capabilities". On the other hand, the top reviewer of Microsoft Azure Synapse Analytics writes "No competitors provide the entire solution to one place ". Microsoft Analytics Platform System is most compared with Teradata, IBM Netezza Performance Server and Snowflake, whereas Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and Amazon EMR. See our Microsoft Analytics Platform System vs. Microsoft Azure Synapse Analytics 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.