Microsoft Parallel Data Warehouse Reviews

Filter by:Reset all filters
industry
Filter Unavailable
Company Size
Filter Unavailable
Job Level
Filter Unavailable
rating
Filter Unavailable
Real User
Business Intelligence evangelist at a hospitality company with 10,001+ employees
Jun 30 2017

What do you think of Microsoft Parallel Data Warehouse?

Valuable Features MPP processing gives us the ability to distribute large data sets across nodes. • Improvements to My Organization We delivered a data warehouse for Contactless and Oyster at TFL. • Room for Improvement Improve the speed of processing replicated tables. • Use of Solution We have been using this solution for years. • Stability Issues There were stability issues when the product was in beta. • Scalability Issues There were scalability issues in that there is a limit to 32 concurrent queries. • Customer Service and Technical Support Technical support is good. • Previous Solutions We switched from the standard SQL server 2014. We use PDW to improve overall ETL and report performance. • Initial Setup The initial setup was complex. It...
Consultant
Teradata DBA / Parallel datawarehouse DBA at a tech services company with 1,001-5,000 employees
Mar 07 2018

What do you think of Microsoft Parallel Data Warehouse?

Primary Use Case We are using PDW as an EDW solution. • Improvements to My Organization It helped, initially, as a replacement for our DW DB, but later on faced issues due to concurrency, which forced the customer to use the DB as a secondary solution. • Valuable Features Nothing specific, comparable to other solutions. • Room for Improvement Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution. They need to improve the metadata being captured to a greater duration. • Use of Solution One to three years.
Find out what your peers are saying about Microsoft, Oracle, Teradata and others in Data Warehouse.
279,610 professionals have used our research since 2012.
Real User
BI Business Analyst at a transportation company with 1,001-5,000 employees
Mar 12 2018

What do you think of Microsoft Parallel Data Warehouse?

Primary Use Case Analysing large volumes of data collected from auto ticket barriers at railway stations. • Improvements to My Organization It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time. • Valuable Features It handles high volumes of data very well. • Room for Improvement It needs more compatibility with common BI tools.  It does not work well with normal ETL tools. Some functions do not work. • Use of Solution One to three years.

Articles

User Assessments By Topic About Microsoft Parallel Data Warehouse

Find out what your peers are saying about Microsoft, Oracle, Teradata and others in Data Warehouse.
279,610 professionals have used our research since 2012.

Microsoft Parallel Data Warehouse Questions

Microsoft Parallel Data Warehouse Projects By Members

Microsoft Parallel Data Warehouse Consultants

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 as
Microsoft 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

BUYER'S GUIDE
Not sure which Data Warehouse solution is right for you?

Download our free Data Warehouse Report and find out what your peers are saying about Microsoft, Oracle, Teradata, and more!

Sign Up with Email