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: March 2024).
765,234 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.""It will be MPP, so performance should improve.""The way that it scales will help a lot of customers that are stuck with Netezza boxes that can't grow any larger.​"

More IBM Db2 Warehouse on Cloud Pros →

"It is not a pricey product compared to other data warehouse solutions.""We have complete control over our data.""Data collection and reporting are valuable features of the solution.""Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products.""I am very satisfied with the customer service/technical support.""It handles high volumes of data very well.""Collecting the data through SSIS packages from different sources and putting them all in one data repository is the most powerful thing. While others have this feature, they don't have the simplicity or ease of use when getting a resource and knowing everything about it.""It is a very stable database."

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.""Tech support for dashDB is awful. We usually have tickets open for three to four weeks.""Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues.""Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."

More IBM Db2 Warehouse on Cloud Cons →

"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.""I think that the error messages need to be made more specific.""This solution would be improved with an option for in-memory data analysis.""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.""It could offer more development across the solution.""SQL installation is pretty tricky. The scalability and customer support also should be improved.""It could be made more user-friendly for business users which would increase the user base."

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.
    765,234 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
    360
    Comparisons
    328
    Reviews
    0
    Average Words per Review
    0
    Rating
    N/A
    8th
    out of 33 in Data Warehouse
    Views
    638
    Comparisons
    516
    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 Firm18%
    University9%
    Manufacturing Company9%
    Computer Software Company7%
    REVIEWERS
    Computer Software Company18%
    Healthcare Company18%
    Pharma/Biotech Company12%
    Hospitality Company12%
    VISITORS READING REVIEWS
    Computer Software Company21%
    Financial Services Firm18%
    Insurance Company7%
    University6%
    Company Size
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise8%
    Large Enterprise76%
    REVIEWERS
    Small Business34%
    Midsize Enterprise14%
    Large Enterprise51%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise18%
    Large Enterprise66%
    Buyer's Guide
    Data Warehouse
    March 2024
    Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: March 2024.
    765,234 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 Microsoft Azure Synapse Analytics, IBM Db2 Warehouse, Amazon Redshift, IBM Netezza Performance Server and Snowflake, whereas Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA, Snowflake and VMware Tanzu Greenplum.

    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.