Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
EDRMS Practice Lead at a tech services company with 51-200 employees
Real User
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.
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 Parallel Data Warehouse provides good firewall processing in terms of response time.
It is a very stable database.
Data collection and reporting are valuable features of the solution.
We can store the data in a data lake for a very low cost.
It is a stable solution...It is a scalable solution.
Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products.
The UI is very simple and functional for my clients, most of the clients that use the solution are not experts.
It performs very well overall.
I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets.
The solution has been reliable.
We have complete control over our data.
Tools like the BI and SAS are excellent.
It is not a pricey product compared to other data warehouse solutions.
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.
We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it.
The data transmissions between the data models is the most valuable feature.
The most valuable feature is the business intelligence (BI) part of it.
The most valuable feature of this solution is performance.
The most valuable feature for me is querying.
One of the most important features is the ease of using MS SQL.
The most valuable features are the performance and usability.
I am very satisfied with the customer service/technical support.