We changed our name from IT Central Station: Here's why

Microsoft Analytics Platform System vs Microsoft Azure Synapse Analytics comparison

You must select at least 2 products to compare!
Featured Review
Find out what your peers are saying about Snowflake Computing, Oracle, Micro Focus and others in Data Warehouse. Updated: January 2022.
563,780 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
"I like that it's integrated with other Azure products.""The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics.""This is a well-integrated solution and that integration empowers results."

More Microsoft Analytics Platform System Pros →

"The solution's scalability is very, very good. It's one of the most important aspects for us.""The most valuable feature is that you can suspend the computer if it is not being used, which means that you don't incur costs.""Fills the gap between big data and classic data warehouses.""We also like governance. It looks at what the requirements are for the company to identify the best way to ensure compliance is met when you move to the cloud.""Its seamless integration with Azure services is most valuable. If somebody wants to use all Azure services, it is the best solution.""The architecture, including compute and storage, is good.""The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services.""The most important feature for me is the integration with PolyBase."

More Microsoft Azure Synapse Analytics Pros →

"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.""Machine learning and artificial intelligence capabilities need to be more friendly for beginning users.""Functionality needs to be more up-to-date with competing products.""The pricing model needs to be improved."

More Microsoft Analytics Platform System Cons →

"Its stability is an issue. They have been releasing a version every six months to one year, which means that there are many versions available, and clients are not up to speed on the latest one that they're offering. From a stability point of view, they could do better. They're still upgrading their Synapse Analytics workspace, and it is not that stable. Its scalability can also be better.""Microsoft should develop an interface to make it easier to shift from on-premise to the cloud.""Indicating what areas need improvement in this solution is a difficult question because the organizations that I am working for are really new in this area. However, an even better more simple interface, or perhaps an extension of a connector app store solution, would be helpful.""The product could be more feature-rich.""The need to improve a little bit in terms of user-friendliness.""Unfortunately, we have had some issues with the dashboard reporting. Sometimes, the data for specific periods would just appear blank on the dashboard. To investigate this, we worked with a Microsoft incident agent and it turned out to be a result of bugs in the platform when dealing with specific types of queries in Azure Data Factory.""The performance and data consistency need to be improved.""The initial setup has a bit of a learning curve."

More Microsoft Azure Synapse Analytics Cons →

Pricing and Cost Advice
  • "The initial price is lower than Oracle, but extensive use of SQL may lead to a higher total cost of ownership."
  • "Users have to pay extra for premium-level technical support."
  • "We are currently paying $200,000 a year for all the different parts of the suite during an ingest model Microsoft now charges us $700,000 a year."
  • More Microsoft Analytics Platform System Pricing and Cost Advice →

  • "All of the prices are available online."
  • "Our license is very expensive"
  • "They are cost aggressive, and it integrates well with other Microsoft tools."
  • "There is a cost calculator available online that allows you to input your entire scenario, and it will get back to you with information on what the costs are going to be."
  • "Its price could be better. It was a school project, and I got it for free. If I try to pay through my company, it is a little bit more expensive as compared to Oracle."
  • "The price of the package not expensive and depends on how much it is used."
  • "The cost of the licensing depends on the size of the warehouse, where the cost of storage is approximately $130 USD per terabyte."
  • "This is a cost-effective product."
  • More Microsoft Azure Synapse Analytics Pricing and Cost Advice →

    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    563,780 professionals have used our research since 2012.
    Questions from the Community
    Ask a question

    Earn 20 points

    Top Answer: 
    Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different… more »
    Top Answer: 
    Traditional ETL would usually use a dedicated database (or even database server) where you'll load & transform your raw data before ingesting it into the final destination. This would allow checking… more »
    Top Answer: 
    Fills the gap between big data and classic data warehouses.
    out of 30 in Data Warehouse
    Average Words per Review
    Average Words per Review
    Also Known As
    Microsoft APS, MS Analytics Platform System
    Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse, MS Azure Synapse Analytics
    Learn More
    The Microsoft Analytics Platform System can meet the demands of your evolving data warehouse environment with its scale-out, massively parallel processing integrated system supporting hybrid data warehouse scenarios. It provides the ability to query across relational and non-relational data by leveraging Microsoft PolyBase and industry-leading big data technologies. It offers the lowest price per terabyte for large data warehouse workloads.

    Azure SQL Data Warehouse is a Fast, flexible, and secure analytics platform for the enterprise. Azure SQL Data Warehouse lets you independently scale compute and storage, while pausing and resuming your data warehouse within minutes through a massively parallel processing architecture designed for the cloud. Seamlessly create your hub for analytics along with native connectivity with data integration and visualization services, all while using your existing SQL and BI skills.

    Learn more about Microsoft Analytics Platform System
    Learn more about Microsoft Azure Synapse Analytics
    Sample Customers
    Transport for London, E-Plus Mobilfunk GmbH & Co. KG, Prometeia, Tangerine, SSM Health Care, Service Corporation International
    Toshiba, Carnival, LG Electronics, Jet.com, Adobe, 
    Top Industries
    Comms Service Provider21%
    Computer Software Company21%
    Financial Services Firm6%
    Computer Software Company21%
    Comms Service Provider16%
    Manufacturing Company11%
    Insurance Company11%
    Computer Software Company27%
    Comms Service Provider18%
    Financial Services Firm6%
    Energy/Utilities Company6%
    Company Size
    Small Business38%
    Large Enterprise63%
    Small Business33%
    Midsize Enterprise21%
    Large Enterprise46%
    Small Business16%
    Midsize Enterprise13%
    Large Enterprise71%
    Find out what your peers are saying about Snowflake Computing, Oracle, Micro Focus and others in Data Warehouse. Updated: January 2022.
    563,780 professionals have used our research since 2012.

    Microsoft Analytics Platform System is ranked 16th in Data Warehouse with 3 reviews while Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 33 reviews. Microsoft Analytics Platform System is rated 5.6, while Microsoft Azure Synapse Analytics is rated 8.0. The top reviewer of Microsoft Analytics Platform System writes "Has unique functionality for advanced analytics but could use enhancement in machine learning and AI features". On the other hand, the top reviewer of Microsoft Azure Synapse Analytics writes "Scalable, intuitive, facilitates compliance and keeping your data secure". Microsoft Analytics Platform System is most compared with Amazon Redshift, Snowflake, Oracle Exadata, IBM Netezza Performance Server and Teradata, whereas Microsoft Azure Synapse Analytics is most compared with Snowflake, Amazon Redshift, SAP BW4HANA, Apache Hadoop and Teradata Cloud Data Warehouse.

    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.