Microsoft Parallel Data Warehouse 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 Parallel Data Warehouse 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 Parallel Data Warehouse vs. SAP Business Warehouse Report (Updated: March 2024).
768,246 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
"The most valuable feature is the business intelligence (BI) part of it.""The most valuable features are the performance and usability.""Data collection and reporting are valuable features of the solution.""​It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time.​""It performs very well overall.""The solution's integration is good.""It is a stable solution...It is a scalable solution.""It is a very stable database."

More Microsoft Parallel Data Warehouse Pros →

"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.""The most useful feature has been he ability to feed data into multiple systems in various formats.""The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice.""Now, because of the HANA integration, the hard disk and RAM are together, and because of that, the output is very quick and very fast actually.""The solution has functionality that makes it easy for end-users to readily extract data directly from Business Warehouse into Excel and carry on their analysis on their own.""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.""With the technical support, the response has been pretty good from the SAP side.""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."

More SAP Business Warehouse Pros →

Cons
"I would like the ability to do more real-time type updates instead of batch-oriented updates.""It could offer more development across the solution.""More tools to help designers should be included.""Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced.""I would like to see better visualization features.""I would like the tool to support different operating systems.""We'd like to see it be a bit more compatible with other solutions.""This solution would be improved with an option for in-memory data analysis."

More Microsoft Parallel Data Warehouse Cons →

"So far, the initial setup process in our company has not been easy enough for us to understand.""More integration with Microsoft Office products (not just Excel) would be helpful.""SAP Business Warehouse could improve by having more out-of-the-box use cases to cover more business types or operations.""The way the data is stored is kind of rigid in SAP BW as a product. It could be more flexible so that when we are designing a solution, we can design our own data structures and try to improve performance.""I get all the information quickly, but it is one day old.""The advanced structuring can be complicated and the interface is not very intuitive.""I'm not sure if our issue is related to BW or the Analysis Office. However, we're having performance issues in terms of time. It takes a long time to generate the report.""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."

More SAP Business Warehouse Cons →

Pricing and Cost Advice
  • "I think the program is well-priced compared to the other offerings that are out in the market."
  • "Microsoft has an agreement with the government in our country, so our customers get their licensing costs from the Ministry. Whenever we work with any government, company, or government institute, which is mainly what we are doing, that license comes directly from the Ministry of Technology and Information."
  • "All the features that we use do not require any additional subscription or yearly fees."
  • "Technical support is an additional fee and is expensive."
  • "The solution's pricing is fairly decent for organizations with huge data sizes."
  • "The tool could be expensive if we need to manage a lot of data."
  • "They offer an annual subscription. The pricing depends on the size of the environments."
  • More Microsoft Parallel Data Warehouse 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,246 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time.
    Top Answer:They offer an annual subscription. The pricing depends on the size of the environments.
    Top Answer:Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced.
    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
    8th
    out of 34 in Data Warehouse
    Views
    598
    Comparisons
    475
    Reviews
    12
    Average Words per Review
    379
    Rating
    8.0
    8th
    Views
    1,298
    Comparisons
    804
    Reviews
    13
    Average Words per Review
    626
    Rating
    7.8
    Comparisons
    Also Known As
    Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse
    Learn More
    Overview

    The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.

    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
    Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe
    Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone
    Top Industries
    REVIEWERS
    Computer Software Company18%
    Healthcare Company18%
    Hospitality Company12%
    Pharma/Biotech Company12%
    VISITORS READING REVIEWS
    Computer Software Company20%
    Financial Services Firm17%
    Insurance Company7%
    University6%
    REVIEWERS
    Insurance Company19%
    Manufacturing Company13%
    Energy/Utilities Company13%
    Non Tech Company13%
    VISITORS READING REVIEWS
    Computer Software Company13%
    Manufacturing Company10%
    Financial Services Firm9%
    Energy/Utilities Company8%
    Company Size
    REVIEWERS
    Small Business36%
    Midsize Enterprise14%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise18%
    Large Enterprise65%
    REVIEWERS
    Small Business24%
    Midsize Enterprise16%
    Large Enterprise60%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise14%
    Large Enterprise67%
    Buyer's Guide
    Microsoft Parallel Data Warehouse vs. SAP Business Warehouse
    March 2024
    Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. SAP Business Warehouse and other solutions. Updated: March 2024.
    768,246 professionals have used our research since 2012.

    Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 32 reviews while SAP Business Warehouse is ranked 8th in Cloud Data Warehouse with 25 reviews. Microsoft Parallel Data Warehouse is rated 7.6, while SAP Business Warehouse is rated 7.8. The top reviewer of Microsoft Parallel Data Warehouse writes "An easy to setup tool that allows its users to write stored procedure, making it a scalable product". On the other hand, the top reviewer of SAP Business Warehouse writes "Offers powerful analytics and integration capabilities but requires improved upgrade processes". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA, VMware Tanzu Greenplum and Snowflake, whereas SAP Business Warehouse is most compared with Microsoft Azure Synapse Analytics, Snowflake, BigQuery, SAP BW4HANA and Amazon Redshift. See our Microsoft Parallel Data Warehouse 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.