Microsoft Analytics Platform System vs SAP Business Warehouse comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Microsoft Analytics Platform System and SAP Business Warehouse 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.
To learn more, read our detailed Microsoft Analytics Platform System vs. SAP Business Warehouse Report (Updated: March 2024).
768,578 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"I like that it's integrated with other Azure products.""It is closely integrated with other products in the MS portfolio.""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.""This is a well-integrated solution and that integration empowers results."

More Microsoft Analytics Platform System Pros →

"The most valuable feature of SAP Business Warehouse is its hybrid functionality, allowing users to leverage both SQL-based data warehouse capabilities from HANA and feature-based data warehousing from BW.""What I like most about SAP Business Warehouse is that it's a seamless integration platform. A valuable feature in the tool is the monitoring alert that makes you aware of what process chain has failed. There's no manual monitoring required if you have configured an alert system, so the process chain can run in the background, and you can get alerts about it. The functionalities I find good in SAP Business Warehouse are alerting and monitoring. If you have configured the tool and have integrated it with SAP Solution Manager, then it's a good product to use.""We are currently in a basic stage of analytics and the first goal we have is to make sure the numbers are correct. BW has some features that help you to build factors and ETL in such a way that it's easy to get to correct responses. That's the number one condition that you have to have in an analytic solution.""The most useful feature is definitely the speed.""The most valuable feature of this solution is the advanced structuring of data capabilities. You can get different structures of data to suit your needs.""Predominantly, our company uses SAP Business Warehouse for reporting purposes across various departments, especially for managers to gain a quick understanding of their current standing and make informed decisions.""Having the integration with the reporting tool which is provided by SAP is great.""The key element in this solution is its rapid response. If you have a question about prices, buyers, customers, providers, or services, you need the answer in a minute or two. That's the key benefit for us that a solution like BW gives us."

More SAP Business Warehouse Pros →

Cons
"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.""Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release.""I think the biggest problem with the product is that it does a data ingest model, which is very expensive.""The pricing model needs to be improved.""​Hybrid environments are complex to manage.""Functionality needs to be more up-to-date with competing products.""We need better real-time analytics capabilities. It's a bit challenging for us."

More Microsoft Analytics Platform System Cons →

"We are very unhappy with technical support. First of all, they send their sales agents or pre-sales agents and most of them who don't know the solution as a properly trained tech would. We have an on-site SAP representative who is supposed to help us with our high priority and production issues, and they're not satisfactory to say the least.""What I'd like to improve in SAP Business Warehouse is its data structure, that's a little bit rigid. It could be a bit more flexible, so you can design your data structure and improve performance when creating a solution. Currently, the way data is stored in SAP Business Warehouse is rigid.""There is room for improvement from a technical perspective.""More integration with Microsoft Office products (not just Excel) would be helpful.""They should reduce the product’s installation package size for easier downloading.""What I'd like improved in SAP Business Warehouse is its setup. It could be more flexible, and it could be a configuration-based setup.""So far, the initial setup process in our company has not been easy enough for us to understand.""The advanced structuring can be complicated and the interface is not very intuitive."

More SAP Business Warehouse 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."
  • "I rate Microsoft Analytics Platform System a seven out of ten for pricing."
  • More Microsoft Analytics Platform System Pricing and Cost Advice →

  • "It's moderately expensive, but definitely has its branding and price value for it."
  • "It's quite pricey. SAP changed its pricing policy, so they give you one engine and then you have to buy everything next to it, like MSS, the BPC licenses, and everything else."
  • "The license for SAP Business Warehouse is paid yearly, and there's no extra cost in addition to the standard licensing fees."
  • "Overall, the pricing is not fixed and is expensive."
  • "The licensing cost for SAP Business Warehouse depends on your revenue. Its licensing structure is a little bit complicated. The more your revenue is, the higher the price, but SAP does have different pricing structures for various companies. For small businesses, licensing isn't based on revenue, but for big companies, it's revenue-based. There's some agreement regarding pricing for huge companies, so it's different, and SAP Business Warehouse pricing isn't fixed. On a scale of one to ten, I'm rating the licensing cost for SAP Business Warehouse as five because it's very high. As your revenue grows, your licensing cost also increases, so you have to factor that in when calculating your cost."
  • "SAP Business Warehouse licensing is a bit expensive compared to other products in the market."
  • "I would not recommend it to small-scale companies. The price is too much."
  • "The solution is quite expensive."
  • More SAP Business Warehouse Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    768,578 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services.
    Top Answer:It's not too confusing. It's based on features, and we don't have to buy additional licenses.
    Top Answer:We need better real-time analytics capabilities. It's a bit challenging for us. Moreover, there are some permission limitations.
    Top Answer:The solution is quite expensive. We paid a yearly subscription fee.
    Top Answer:Over a period, we realized that the license and maintenance costs were quite expensive. Every day, we had to run the background job ODS. Eventually, we moved away from SAP Business Warehouse and… more »
    Ranking
    17th
    out of 34 in Data Warehouse
    Views
    323
    Comparisons
    240
    Reviews
    2
    Average Words per Review
    439
    Rating
    7.5
    8th
    Views
    1,298
    Comparisons
    804
    Reviews
    13
    Average Words per Review
    626
    Rating
    7.8
    Comparisons
    Also Known As
    Microsoft APS, MS Analytics Platform System
    Learn More
    Overview
    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.

    Reporting, analysis and interpretation of business data are crucial to preserve and enhance the competitive edge of companies by optimizing processes and enabling them to react quickly and in line with market needs. SAP Business Warehouse (SAP BW) provides tools and functions that enable companies to attain these goals. In SAP BW, you can integrate, transform, and consolidate relevant business information from productive SAP applications and external data sources. SAP BW provides you with a high-performance infrastructure that helps you evaluate and interpret data. Decision makers can make well-founded decisions and identify target-orientated activities on the basis of the analyzed data.

    Sample Customers
    Transport for London, E-Plus Mobilfunk GmbH & Co. KG, Prometeia, Tangerine, SSM Health Care, Service Corporation International
    Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm12%
    Computer Software Company11%
    University11%
    Energy/Utilities Company9%
    REVIEWERS
    Insurance Company19%
    Non Tech Company13%
    Energy/Utilities Company13%
    Manufacturing Company13%
    VISITORS READING REVIEWS
    Computer Software Company13%
    Manufacturing Company10%
    Financial Services Firm9%
    Energy/Utilities Company8%
    Company Size
    REVIEWERS
    Small Business36%
    Large Enterprise64%
    VISITORS READING REVIEWS
    Small Business22%
    Midsize Enterprise5%
    Large Enterprise73%
    REVIEWERS
    Small Business24%
    Midsize Enterprise16%
    Large Enterprise60%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise14%
    Large Enterprise67%
    Buyer's Guide
    Microsoft Analytics Platform System vs. SAP Business Warehouse
    March 2024
    Find out what your peers are saying about Microsoft Analytics Platform System vs. SAP Business Warehouse and other solutions. Updated: March 2024.
    768,578 professionals have used our research since 2012.

    Microsoft Analytics Platform System is ranked 17th in Data Warehouse with 9 reviews while SAP Business Warehouse is ranked 8th in Cloud Data Warehouse with 25 reviews. Microsoft Analytics Platform System is rated 6.6, while SAP Business Warehouse 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 SAP Business Warehouse writes "Offers powerful analytics and integration capabilities but requires improved upgrade processes". Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics, Teradata, IBM Netezza Performance Server and Snowflake, whereas SAP Business Warehouse is most compared with Microsoft Azure Synapse Analytics, Snowflake, BigQuery, SAP BW4HANA and Amazon Redshift. See our Microsoft Analytics Platform System vs. SAP Business Warehouse 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.