IBM Db2 Warehouse vs Microsoft Parallel Data Warehouse comparison

IBM and Microsoft are both solutions in the Data Warehouse category. IBM is ranked #12 with an average rating of 8.0, while Microsoft is ranked #10 with an average rating of 8.4. IBM holds a 2.0% mindshare in Data Warehouse, compared to Microsoft’s 0.8% mindshare. Additionally, 80% of IBM users are willing to recommend the solution, compared to 86% of Microsoft users who would recommend it.

IBM Db2 Warehouse

Read 11 IBM Db2 Warehouse reviews

1,000 Views
368 Comparison Views

80% willing to recommend

Microsoft Parallel Data War...

Read 37 Microsoft Parallel Data Warehouse reviews

324 Views
208 Comparison Views

86% willing to recommend

IBM Db2 Warehouse

Microsoft Parallel Data War...

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 18, 2024

Microsoft Parallel Data Warehouse and IBM Db2 Warehouse compete in the data warehousing category. IBM Db2 Warehouse gains an upper hand due to its advanced features and cloud-based deployment flexibility.

Features: Microsoft Parallel Data Warehouse includes integration with Microsoft services, robust analytics, and MPP processing for large datasets. IBM Db2 Warehouse offers AI and machine learning integration, high-performance queries, and flexible deployment options.

Room for Improvement: Microsoft Parallel Data Warehouse can improve cloud transition, modernize user interface, and reduce manual setup time. IBM Db2 Warehouse could enhance cost efficiency, lower initial setup expenses, and streamline resource allocation.

Ease of Deployment and Customer Service: IBM Db2 Warehouse offers cloud-based scalable deployment and efficient customer service. Microsoft Parallel Data Warehouse provides a traditional on-premise model with enterprise-focused support.

Pricing and ROI: Microsoft Parallel Data Warehouse attracts with a lower initial cost and solid ROI due to data efficiency. IBM Db2 Warehouse, while costlier initially, offers substantial ROI through enhanced processing capabilities and long-term innovation.

To learn more, read our detailed IBM Db2 Warehouse vs. Microsoft Parallel Data Warehouse Report (Updated: February 2025).

Buyer's Guide

IBM Db2 Warehouse vs. Microsoft Parallel Data Warehouse

February 2025

Download the complete report

Helped 845,406 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

IBM Db2 Warehouse

Ranking in Data Warehouse

12th

Average Rating

7.8

Reviews Sentiment

6.6

Number of Reviews

Ranking in other categories

No ranking in other categories

Microsoft Parallel Data War...

Ranking in Data Warehouse

10th

Average Rating

7.8

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of April 2025, in the Data Warehouse category, the mindshare of IBM Db2 Warehouse is 2.0%, up from 1.8% compared to the previous year. The mindshare of Microsoft Parallel Data Warehouse is 0.8%, down from 1.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Warehouse

Featured Reviews

Josef Kraus

Owner at S.K. Consulting Services GmbH

Useful for ETL process and has good documentation

The tool's most beneficial feature for our data management tasks has been the ETL process. Additionally, we utilized Windows and Linux. IBM Db2 Warehouse's scalability has significantly impacted our data storage capabilities. We needed to order new disks for storage every week within this hosting environment. Additionally, we implemented protection measures for production use. The tools are readily available, and if you're willing to invest in them, you can access a good data warehouse without any issues.

Read full review

StevenLai

Sr. Data Engineer at Amrock

Strong scalable solution with streamlined metadata warehousing

We use it to build our data warehouse and databases, and everything in the back end It helps streamline our metadata warehousing process. As it is our only type of data warehouse and database, it serves as our source, destination, and staging area. This product has many features which are useful…

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"I think it scales really well and as long as you take enough time to learn a little bit about it, it works really well."

"The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data."

"Some of the best features are stored procedures, parallelism, and different indexing strategies."

"The most valuable features of IBM Db2 Warehouse include its availability, easy integration, ability to deal with a large size of data, excellent performance with no delays, powerful security mechanisms, and effective support."

"The solution is stable."

"The analytics engine is not bad at forecasting predictions."

"Provides good security and reliability."

"It can scale effectively as long as resources are available."

More IBM Db2 Warehouse pros

"Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products."

"The interface is very user-friendly."

"I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets."

"The solution's integration is good."

"The most valuable feature for me is querying."

"The most valuable features are the performance and usability."

"It is not a pricey product compared to other data warehouse solutions."

More Microsoft Parallel Data Warehouse pros

Cons

"The biggest problems we have is when the backup solution is failing or slow and we run out of log space, which has happened probably a couple of times in the last four years."

"The biggest challenge anyone could have with Db2 Warehouse is their references or online resources and documentation. They are very, very, very limited on the web."

"There should be more material available for training and training should be free."

"It takes a long time to have a new version or release, similar to Oracle."

"IBM Db2 Warehouse needs to improve its interface."

"Responding to support tickets takes a lot of time. It can range from two to four days, even for critical issues."

"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."

"There were some initial challenges with IBM Db2 Warehouse about eight months ago when I worked in this environment. When I coordinated with IBM support, they mentioned that the memory was insufficient for our needs. Our business environment required significantly more memory than the previous cluster could provide. Consequently, we have worked closely with on-site IBM technical personnel to address this issue."

More IBM Db2 Warehouse cons

"I would like the tool to support different operating systems."

"We'd like to see it be a bit more compatible with other solutions."

"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."

"If the database is large with a lot of columns then it is difficult to clean the data."

"I think that the error messages need to be made more specific."

"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 product does not have all of the features that the native products have."

More Microsoft Parallel Data Warehouse cons

Pricing and Cost Advice

"In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."

"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."

"They offer an annual subscription. The pricing depends on the size of the environments."

"The solution is cost-effective."

"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 tool could be expensive if we need to manage a lot of data."

"The solution's pricing is fairly decent for organizations with huge data sizes."

See which vendors are best for you

Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.

See recommendations

845,406 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Educational Organization

58%

Financial Services Firm

10%

Computer Software Company

Government

Computer Software Company

30%

Financial Services Firm

16%

Insurance Company

Retailer

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about IBM Db2 Warehouse?

The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data.

See all answers

What is your experience regarding pricing and costs for IBM Db2 Warehouse?

Db2 Warehouse or IBM products are pretty expensive. There are cheaper tools on the market. However, if the client is satisfied with paying for the Db2 Warehouse license, especially for cloud-based ...

See all answers

What needs improvement with IBM Db2 Warehouse?

Responding to support tickets takes a lot of time. It can range from two to four days, even for critical issues. The technical support quality is good, but the response time needs improvement.

See all answers

What do you like most about Microsoft Parallel Data Warehouse?

Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time.

See all answers

What is your experience regarding pricing and costs for Microsoft Parallel Data Warehouse?

Microsoft Parallel Data Warehouse is very expensive.

See all answers

What needs improvement with Microsoft Parallel Data Warehouse?

Microsoft Parallel Data Warehouse is excellent but very expensive. Working on the pricing could make it a better solution.

See all answers

Comparisons

Snowflake vs IBM Db2 Warehouse

Compared 38% of the time

Teradata vs IBM Db2 Warehouse

Compared 32% of the time

Oracle Exadata vs IBM Db2 Warehouse

Compared 29% of the time

More IBM Db2 Warehouse Competitors

Microsoft Azure Synapse Analytics vs Microsoft Parallel Data Warehouse

Compared 53% of the time

Teradata vs Microsoft Parallel Data Warehouse

Compared 48% of the time

More Microsoft Parallel Data Warehouse Competitors

Product Reports

Buyer's Guide

IBM Db2 Warehouse

March 2025

Download IBM Db2 Warehouse product report

Buyer's Guide

Microsoft Parallel Data Warehouse

March 2025

Microsoft Parallel Data Warehouse report

Download Microsoft Parallel Data Warehouse product report

Also Known As

InfoSphere Warehouse, IBM InfoSphere Warehouse

Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse

Overview

InfoSphere Warehouse is a suite of products that combines the strength of DB2 with a data warehousing infrastructure from IBM. You can use InfoSphere Warehouse to build a complete data warehousing solution that includes a highly scalable relational database, data access capabilities, and front-end analysis tools.

IBM

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.

Microsoft

Sample Customers

Alameda County Social Services Agency, Sui Southern Gas Company Limited

Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe

Buyer's Guide

IBM Db2 Warehouse vs. Microsoft Parallel Data Warehouse

February 2025

Free Report: IBM Db2 Warehouse vs. Microsoft Parallel Data Warehouse

Find out what your peers are saying about IBM Db2 Warehouse vs. Microsoft Parallel Data Warehouse and other solutions. Updated: February 2025.

DOWNLOAD NOW

845,406 professionals have used our research since 2012.

See our IBM Db2 Warehouse vs. Microsoft Parallel Data Warehouse report.

See our list of best 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.