Try our new research platform with insights from 80,000+ expert users

Microsoft Parallel Data Warehouse pros and cons

Vendor: Microsoft

3.9 out of 5

35 reviews
86% willing to recommend

1,470 followers

Pros & Cons summary

Microsoft Parallel Data Warehouse excels with high data volumes, fast loads, and near real-time analysis but limits concurrent queries to 32, impacting functionality. The solution is valued for MS SQL usability in querying and business intelligence, yet compatibility with BI tools needs improvement. The platform features reliable integration and straightforward setup but encounters slow processing with complex data and refresh issues with table statistics. Error messages require specificity for streamlined troubleshooting.

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.

Prominent pros & cons

PROS

Microsoft Parallel Data Warehouse handles high volumes of data effectively, enabling fast daily loads and near real-time analysis.

Customer service and technical support for Microsoft Parallel Data Warehouse are highly satisfactory.

The integration of Microsoft Parallel Data Warehouse with other Microsoft products is seamless.

Data integrity and reliable performance are key strengths of Microsoft Parallel Data Warehouse.

The scalability and wealth of features of Microsoft Parallel Data Warehouse make it a strong choice.

CONS

Concurrent queries are limited to 32, making Microsoft Parallel Data Warehouse more of a data storage mechanism instead of an active DWH.

Error messages need to be more specific.

Reporting for certain types of data needs improvement.

The cost of Microsoft Parallel Data Warehouse is considered high.

There are compatibility issues during deployment, sometimes requiring the product to be built from scratch for certain features.

Microsoft Parallel Data Warehouse Pros review quotes

MS

EDRMS Practice Lead at a tech services company with 51-200 employees

May 4, 2020

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.

Read full review

System Administrator at a university with 501-1,000 employees

Aug 27, 2020

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

Read full review

reviewer1212726

Microsoft Dynamics Specialist at a computer software company with 51-200 employees

Nov 20, 2019

I am very satisfied with the customer service/technical support.

Read full review

Microsoft Parallel Data Warehouse

Free Report: Microsoft Parallel Data Warehouse Reviews and More

Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.

824,067 professionals have used our research since 2012.

Managing Partner at Dynamis Informatica

Mar 9, 2023

The UI is very simple and functional for my clients, most of the clients that use the solution are not experts.

Read full review

MJ

BI Developer at a healthcare company with 51-200 employees

Dec 9, 2019

One of the most important features is the ease of using MS SQL.

Read full review

Senior Software Engineer at Eurofins

Aug 1, 2023

It is a stable solution...It is a scalable solution.

Read full review

reviewer2255670

Team Leader at a tech services company with 201-500 employees

Aug 11, 2023

We can store the data in a data lake for a very low cost.

Read full review

AN

Senior Principal Consultant at a tech services company with 1,001-5,000 employees

Dec 15, 2019

The most valuable feature is the business intelligence (BI) part of it.

Read full review

SG

Syed SaqibGhawas

Application Designer at LMKR

Aug 15, 2022

The solution has been reliable.

Read full review

reviewer1038354

Team Lead at a computer software company with 10,001+ employees

Dec 12, 2019

The most valuable feature of this solution is performance.

Read full review

Show 10 more reviews (out of 27)

Microsoft Parallel Data Warehouse Cons review quotes

MS

EDRMS Practice Lead at a tech services company with 51-200 employees

May 4, 2020

I would like the tool to support different operating systems.

Read full review

System Administrator at a university with 501-1,000 employees

Aug 27, 2020

It could be made more user-friendly for business users which would increase the user base.

Read full review

reviewer1212726

Microsoft Dynamics Specialist at a computer software company with 51-200 employees

Nov 20, 2019

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.

Read full review

Microsoft Parallel Data Warehouse

Free Report: Microsoft Parallel Data Warehouse Reviews and More

Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.

824,067 professionals have used our research since 2012.

Managing Partner at Dynamis Informatica

Mar 9, 2023

The solution is expensive and has room for improvement.

Read full review

MJ

BI Developer at a healthcare company with 51-200 employees

Dec 9, 2019

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

Read full review

Senior Software Engineer at Eurofins

Aug 1, 2023

The only issue with the product is that the process is very slow when we have a huge amount of data.

Read full review

reviewer2255670

Team Leader at a tech services company with 201-500 employees

Aug 11, 2023

The product does not have all of the features that the native products have.

Read full review

AN

Senior Principal Consultant at a tech services company with 1,001-5,000 employees

Dec 15, 2019

This solution would be improved with an option for in-memory data analysis.

Read full review

SG

Syed SaqibGhawas

Application Designer at LMKR

Aug 15, 2022

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

Read full review

reviewer1038354

Team Lead at a computer software company with 10,001+ employees

Dec 12, 2019

The reporting for certain types of data needs to be improved.

Read full review

Show 10 more reviews (out of 27)

Product Categories

Product Categories

Popular Comparisons

Popular Comparisons

Snowflake vs Microsoft Parallel Data Warehouse

Teradata vs Microsoft Parallel Data Warehouse

Oracle Exadata vs Microsoft Parallel Data Warehouse

VMware Tanzu Data Solutions vs Microsoft Parallel Data Warehouse

Apache Hadoop vs Microsoft Parallel Data Warehouse

SAP BW4HANA vs Microsoft Parallel Data Warehouse

Oracle Database Appliance vs Microsoft Parallel Data Warehouse

See all alternatives

Product Categories

Product Categories

Popular Comparisons

Popular Comparisons

Snowflake vs Microsoft Parallel Data Warehouse

Teradata vs Microsoft Parallel Data Warehouse

Oracle Exadata vs Microsoft Parallel Data Warehouse

VMware Tanzu Data Solutions vs Microsoft Parallel Data Warehouse

Apache Hadoop vs Microsoft Parallel Data Warehouse

SAP BW4HANA vs Microsoft Parallel Data Warehouse

Oracle Database Appliance vs Microsoft Parallel Data Warehouse

See all alternatives

Related questions

18

Infobright vs. Exadata vs. Teradata vs. SQL Server Data Warehouse- which is most compatible with front end tools?

227

Oracle Exadata vs. HPE Vertica vs. EMC GreenPlum vs. IBM Netezza

59

When evaluating Data Warehouse solutions, what aspect do you think is the most important to look for?

20

At what point does a business typically invest in building a data warehouse?

101

Is a data warehouse the best option to consolidate data into one location?

112

What are the main differences between Data Lake and Data Warehouse?

18

Infobright vs. Exadata vs. Teradata vs. SQL Server Data Warehouse- which is most compatible with front end tools?

38

What is the best data warehouse tool?

46

Which Data Strategy solution have you used?

2

Why is Data Warehouse important for companies?