Microsoft Parallel Data Warehouse Reviews
Microsoft Parallel Data Warehouse is the #6 ranked solution of our top Data Warehouse tools. It's rated 3.8 out of 5 stars, and is most commonly compared to Microsoft Azure Synapse Analytics - Microsoft Parallel Data Warehouse vs Microsoft Azure Synapse Analytics
- Highest Rating
- Lowest Rating
- Review Length
Showingreviews based on the current filters.
May 07 2020
What is most valuable?* Availability of resources everywhere * The cost of resources * The information knowledge is there. * It is easy to use. You can do what you want with the tool. * It integrates well with SQL Server. Collecting the data through SSIS packages from different sources and putting them all in one data… more »
What needs improvement?The setup has room for improvement. Some customers want to go to non-Windows Servers. Have the entire SQL Server done there though is an obstacle for us, as the configuration of Microsoft BI with cubes is a bit complicated. I would like the integration to be offered in a simpler way. I would like… more »
What's my experience with pricing, setup cost, and licensing?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… more »
What other advice do I have?We have had a good experience working with this tool. If you don't have a problem with memory and have good processors, then you won't have an issue. However, depending on your needs, you may want to go check out other tools. I would rate the tool as an eight out of 10.
Aug 28 2020
Less expensive than other high-end solutions this can be a powerhouse for small low-budget companies
What is most valuable?In our economic situation, the price is really the most important consideration. It is not a pricey product compared to other data warehouse solutions like Oracle and similar products. It is less expensive, but it still achieves our goals and fulfills all our needs. So I think it is a comfortable… more »
What needs improvement?I think that building better data protection and a business intelligence layer over the SQL would be great and improve the product. If they could make it more like what Oracle in that way it would be good. We have to take the time and resources to build our own business intelligence when other… more »
What's my experience with pricing, setup cost, and licensing?We do not have any external support contracts. All the features that we use do not require any additional subscription or yearly fees. We just only use features that we pay for on a one-time basis.
What other advice do I have?For a small-sized company like ours, I really recommend this product. It can handle a big workload. I would say other products could not be better than Microsoft for small businesses with a lesser budget. On a scale from one to ten where one is the worst and ten is the best. I would rate Microsoft… more »
Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
442,986 professionals have used our research since 2012.
Nov 20 2019
What is most valuable?What I like the most about this solution is the fact that you can basically add capacity behind your data modeling, and you speed up the process before it goes into the Cube holding section. That's a great integration layer. You can basically collect all your data, and then that becomes a staging… more »
What needs improvement?Something that needs to improve, is the integration layer itself connecting to other non-Microsoft layers. But I don't know if that can be improved, due to the complexity of the data that they're connecting to. But I think they can maybe look at a way to do incremental updates, as it is slightly… more »
What's my experience with pricing, setup cost, and licensing?I think the program is well-priced compared to the other offerings that are out in the market.
What other advice do I have?On a scale from one to 10, I rate this solution a nine. 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 biggest part that we battle… more »
Dec 12 2019
What is most valuable?One of the most important features is the ease of using MS SQL. It has been easy to do exactly what I wanted. For example, it was very easy to pull the data from, and it is also very easy to import data from CSV or Excel. If I needed a specific set of data from the master then it was easy to get it.
What needs improvement?I think that the error messages need to be made more specific. Recently, I was working with a large amount of data, and I received a runtime error. I had to solve it by running the query several times, removing data each time. If the error messages were less ambiguous then it would have helped.
What other advice do I have?My advice for anybody who is implementing this solution is not to overload your server with all of the data that you don't use on a day-to-day basis. It is very easy to pull the data that you need whenever it is required. You will have to decide how to store the data and how easy it is for your client to send new data. Neither of these things should be difficult to do, even for newcomers to SQL… more »
Dec 17 2019
What is most valuable?The most valuable feature is the business intelligence (BI) part of it. BI includes decision trees and similar functionality. This happens post-building of the data warehouse when you start using the analysis features. The user interface is definitely good.
What needs improvement?This solution would be improved with an option for in-memory data analysis. Scalability can be improved because there are other tools that perform better with very large datasets.
Which solution did I use previously and why did I switch?We are using Pentaho Data Warehouse in addition to this solution. We select which one is implemented depending on the customer's request and what they want to do.
What other advice do I have?This is a solution that has good performance and I recommend it. The support from Microsoft is also another thing that makes the Parallel Data Warehouse a good option. The biggest lesson that we have learned from using this solution is that customers are most interested in a quick project turnaround… more »
Dec 14 2019
What is most valuable?The most valuable feature of this solution is performance. It reduces the time it takes to process data.
What needs improvement?The initial setup of this solution is complex and can be improved. Sometimes you need to re-run the reports because they don't work. The reporting for certain types of data needs to be improved.
What other advice do I have?My advice for anybody who is implementing Microsoft Parallel Data Warehouse is to be aware of how big the data is. You have to be sure of how to secure and take care of the data. You have to think about scalability. I would rate this solution a seven out of ten.
Dec 05 2019
What is most valuable?The most valuable features are the performance and usability. Microsoft Parallel Data Warehouse is simple to use, and the user interface is intuitive.
How has it helped my organization?This solution helps the higher levels of the organization because they have better visibility of the whole company. This helps with decision making in terms of what should be improved or implemented.
What needs improvement?More tools to help designers should be included.
Which solution did I use previously and why did I switch?Prior to Microsoft Parallel Data Warehouse, we used a standard relational SQL database. We switched because of the performance and because the data and KPI changed. It would be difficult to use a relational database. We switched to a data… more »
What other advice do I have?My advice to anybody who is implementing this solution is to design the databases as well as they can because it is difficult to make changes in the future. It is also important to have a time field in your data in case you want to use it… more »
Aug 30 2020
What is most valuable?Most features on the SQL Server are quite useful to us. Its temporary functionality and the partitioning, searching, etc., are great. Tools like the BI and SAS are excellent.
What needs improvement?I'd like to connect something like ES that I can use on objects on our SQL Server. We'd like to be able to understand how to export data to something like Semantic Technologies or like Graph DB. Some sort of easy export functionality would be a useful addition to the product. The solution should… more »
What's my experience with pricing, setup cost, and licensing?The pricing is a bit expensive.
What other advice do I have?We're just a customer. We don't have a business relationship with the product. I'd rate the solution eight out of ten overall. It's never given us issues in terms of scaling or stability. Technical support is quite good. It offers some great features.
See 3 More Microsoft Parallel Data Warehouse Reviews
Read Archived Reviews
What is Microsoft Parallel Data Warehouse?
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.
Also known asMicrosoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse
Microsoft Parallel Data Warehouse customers
Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe
Download our free Microsoft Parallel Data Warehouse Report and get advice and tips from experienced pros sharing their opinions.