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."This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
"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."
"We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services."
"Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases."
"This is a well-integrated solution and that integration empowers results."
"Helps our customers to discover trends, which provides useful information based on their business."
"I like that it's integrated with other Azure products."
"Fills the gap between big data and classic data warehouses."
"I like the keynotes and their simplicity. Like other Microsoft products, Microsoft Azure Synapse Analytics is simple to understand and use."
"I like how Microsoft Azure Synapse Analytics integrates with other Microsoft solutions."
"The solution can scale."
"Synapse Analytics' best features are notebooks, pipelines, and monitoring."
"It is a fantastic product; we are satisfied with its features and performance."
"Data can be stored any way you want in the data warehouse."
"The product works well with other Azure products."
"Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release."
"Machine learning and artificial intelligence capabilities need to be more friendly for beginning users."
"We need better real-time analytics capabilities. It's a bit challenging for us."
"Hybrid environments are complex to manage."
"I think the biggest problem with the product is that it does a data ingest model, which is very expensive."
"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps."
"Functionality needs to be more up-to-date with competing products."
"The pricing model needs to be improved."
"Microsoft Azure Synapse Analytics can improve by increasing the size of the files that we can load on the platform. We have some files that are too large to be loaded and it would be a benefit to us if the limit was increased. Additionally, the way we use the tool for generating reports can be made better. They should add some drag-and-drop rules without the need of programming these rules using some programming language. It would be helpful if we did not need someone that was technically advanced to be able to do it with, such as someone with no IT background. Having a reporting tool without code would be great."
"The major challenge that we're seeing with Azure Synapse is around security concerns. The way it is working right now, it has Managed VNet by Microsoft option, similar to the implementation of Azure Databricks, which may pose a concern for financial institutions. For managed environments, the banks have very strict policies around data being onboarded to those environments. For some confidential applications, the banks have the policy to encrypt it with their own key, so it is sort of like Bring Your Own Key, but it is not possible to manage the resources with Microsoft or Databricks, which is probably the major challenge with Azure Synapse. There should be more compatibility with SQL Server. It should be easier to migrate solutions between different environments because right now, it is not really competitive. It is not like you can go and install SQL Database in some other environment. You will have to go through some migration projects, which probably is one of the major showstoppers for any bank. When they consider Synapse, they not only consider the investment in the actual service; they also consider the cost of the migration process. When you scale out or scale down your system, it becomes unavailable for a few minutes. Because it is a data warehouse environment, it is not such a huge deal, but it would be great if they can improve it so that the platform is available during the change of configuration."
"It needs strong support for social media, internet data, and native support for NoSQL."
"The performance needs to improve in future releases."
"If I'm looking for something good in the cloud, I would want it to have better standard connectors."
"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."
"We encountered data processing and transformation issues while working with Apache Spark languages for the product."
"This solution needs to have query caching so that if the same query is run and the results are available, it will return the data from the cache without having to re-run the query."
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.