IBM Db2 Warehouse on Cloud vs Microsoft Parallel Data Warehouse comparison

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

We performed a comparison between IBM Db2 Warehouse on Cloud and Microsoft Parallel Data Warehouse based on real PeerSpot user reviews.

Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse.
To learn more, read our detailed Data Warehouse Report (Updated: April 2024).
768,857 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 performance is okay as long as the volume of queries is not too high.""The way that it scales will help a lot of customers that are stuck with Netezza boxes that can't grow any larger.​""It will be MPP, so performance should improve."

More IBM Db2 Warehouse on Cloud Pros →

"I am very satisfied with the customer service/technical support.""The solution has been reliable.""The solution's integration is good.""We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it.""It is not a pricey product compared to other data warehouse solutions.""The data transmissions between the data models is the most valuable feature.""It is a very stable database.""The most valuable feature for me is querying."

More Microsoft Parallel Data Warehouse Pros →

Cons
"Right now, we are implementing on ESX VMware 6.0. Support for this platform is poor. Also, one of the backup/recovery options is broken and IBM is not addressing the issue.""Ultimately, the product itself has challenges and we are not currently satisfied with the support, either.""Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues.""Tech support for dashDB is awful. We usually have tickets open for three to four weeks."

More IBM Db2 Warehouse on Cloud Cons →

"It needs more compatibility with common BI tools.""This solution would be improved with an option for in-memory data analysis.""In the future I would love to see a slightly better automation engine, just for the data integration layer, to make it slightly easier for end-users or junior developers to get involved in incremental updating.""The solution is expensive and has room for improvement.""The reporting for certain types of data needs to be improved.""If the database is large with a lot of columns then it is difficult to clean the data.""I would like the ability to do more real-time type updates instead of batch-oriented updates.""I think that the error messages need to be made more specific."

More Microsoft Parallel Data Warehouse Cons →

Pricing and Cost Advice
  • "If your going to go with warehouse DB/dashDB, use the cloud or Sailfish version."
  • More IBM Db2 Warehouse on Cloud 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 →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    768,857 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Organizations of all sizes, especially those who are in need of powerful and elastic cloud data warehouse solutions that can help administrators maximize the efficiency of their data-based operations… more »
    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.
    Ranking
    15th
    Views
    327
    Comparisons
    295
    Reviews
    0
    Average Words per Review
    0
    Rating
    N/A
    8th
    out of 34 in Data Warehouse
    Views
    598
    Comparisons
    475
    Reviews
    12
    Average Words per Review
    379
    Rating
    8.0
    Comparisons
    Also Known As
    IBM dashDB
    Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse
    Learn More
    Overview

    IBM dashDB family offers private and public cloud database solutions for transactional and analytic workloads, with IBM fully managed or client managed options with a Common SQL engine across all deployment options.

    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.

    Sample Customers
    Copenhagen Business School, BPM Northwest, GameStop
    Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm16%
    Manufacturing Company10%
    University10%
    Computer Software Company9%
    REVIEWERS
    Computer Software Company18%
    Healthcare Company18%
    Pharma/Biotech Company12%
    Hospitality Company12%
    VISITORS READING REVIEWS
    Computer Software Company20%
    Financial Services Firm17%
    Insurance Company7%
    University6%
    Company Size
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise10%
    Large Enterprise76%
    REVIEWERS
    Small Business36%
    Midsize Enterprise14%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise18%
    Large Enterprise65%
    Buyer's Guide
    Data Warehouse
    April 2024
    Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: April 2024.
    768,857 professionals have used our research since 2012.

    IBM Db2 Warehouse on Cloud is ranked 15th in Cloud Data Warehouse while Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 32 reviews. IBM Db2 Warehouse on Cloud is rated 7.6, while Microsoft Parallel Data Warehouse is rated 7.6. The top reviewer of IBM Db2 Warehouse on Cloud writes "The "prefetch" feature anticipates needed data and keeps it available. BLU acceleration determines what data is unqualified for analysis and skips it". On the other hand, 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". IBM Db2 Warehouse on Cloud is most compared with Amazon Redshift, IBM Netezza Performance Server, IBM Db2 Warehouse, Microsoft Azure Synapse Analytics and Snowflake, whereas Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA, VMware Tanzu Greenplum and Snowflake.

    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.