We just raised a $30M Series A: Read our story

Compare Microsoft Azure Synapse Analytics vs. Microsoft Parallel Data Warehouse

Cancel
You must select at least 2 products to compare!
Featured Review
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon and others in Cloud Data Warehouse. Updated: November 2021.
553,954 professionals have used our research since 2012.
Quotes From Members

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

Pros
"The solution's scalability is very, very good. It's one of the most important aspects for us.""The whole solution is interesting for us.""The speed is great and the architecture is excellent.""They are available on the Cloud, and the platform is very intuitive.""Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task.""The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs.""The pricing seems to be quite fair.""Very interactive and provides flexibility."

More Microsoft Azure Synapse Analytics Pros »

"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.""One of the most important features is the ease of using MS SQL.""Tools like the BI and SAS are excellent.""The most valuable feature for me is querying.""The most valuable feature of this solution is performance.""The most valuable features are the performance and usability.""The most valuable feature is the business intelligence (BI) part of it."

More Microsoft Parallel Data Warehouse Pros »

Cons
"With respect to what needs to be improved, concurrent connectivity has some limitations.""The initial setup is complex.""Microsoft should develop an interface to make it easier to shift from on-premise to the cloud.""The major challenge that we're seeing with Azure Synapse is around security concerns. The way it is working right now, it has Managed VNet by Microsoft option, similar to the implementation of Azure Databricks, which may pose a concern for financial institutions. For managed environments, the banks have very strict policies around data being onboarded to those environments. For some confidential applications, the banks have the policy to encrypt it with their own key, so it is sort of like Bring Your Own Key, but it is not possible to manage the resources with Microsoft or Databricks, which is probably the major challenge with Azure Synapse. There should be more compatibility with SQL Server. It should be easier to migrate solutions between different environments because right now, it is not really competitive. It is not like you can go and install SQL Database in some other environment. You will have to go through some migration projects, which probably is one of the major showstoppers for any bank. When they consider Synapse, they not only consider the investment in the actual service; they also consider the cost of the migration process. When you scale out or scale down your system, it becomes unavailable for a few minutes. Because it is a data warehouse environment, it is not such a huge deal, but it would be great if they can improve it so that the platform is available during the change of configuration.""I would like to see them provide the ingestion of images.""The performance and data consistency need to be improved.""The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them.""Right now, we are really struggling with the performance. it's not as good as we had hoped."

More Microsoft Azure Synapse Analytics Cons »

"They need to incorporate a machine learning engine.""The reporting for certain types of data needs to be improved.""I would like the tool to support different operating systems.""I would like to see better visualization features.""We find the cost of the solution to be a little high.""This solution would be improved with an option for in-memory data analysis.""More tools to help designers should be included.""If the database is large with a lot of columns then it is difficult to clean the data."

More Microsoft Parallel Data Warehouse Cons »

Pricing and Cost Advice
"The price of the package not expensive and depends on how much it is used.""We normally pay between $300 and $500 per month, which is quite expensive for how much we actually use it, performance- and usage-wise. They have a cheap version and an expensive version, and our usage usually falls in the middle ground, which makes it not as cost-effective as it could be.""The cost of the licensing depends on the size of the warehouse, where the cost of storage is approximately $130 USD per terabyte.""There is a cost calculator available online that allows you to input your entire scenario, and it will get back to you with information on what the costs are going to be.""It's very difficult to price unless you know exactly how the customer is using it.""My company pays for the license and I am not sure about the price.""We are on a monthly payment plan for the use of Microsoft Azure Synapse Analytics.""This is a cost-effective product."

More Microsoft Azure Synapse Analytics Pricing and Cost Advice »

"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.""All the features that we use do not require any additional subscription or yearly fees."

More Microsoft Parallel Data Warehouse Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
553,954 professionals have used our research since 2012.
Questions from the Community
Top Answer: Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different… more »
Top Answer: Traditional ETL would usually use a dedicated database (or even database server) where you'll load & transform your raw data before ingesting it into the final destination. This would allow checking… more »
Top Answer: The integrated workspace in Microsoft Azure Synapse Analytics where everything comes together, such as Power BI and Data Factory, is very good. Additionally, the ability to do dedicated SQL pooling is… more »
Ask a question

Earn 20 points

Ranking
2nd
Views
26,469
Comparisons
19,512
Reviews
34
Average Words per Review
537
Rating
7.9
5th
out of 30 in Data Warehouse
Views
2,467
Comparisons
1,878
Reviews
10
Average Words per Review
465
Rating
7.5
Comparisons
Also Known As
Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse, MS Azure Synapse Analytics
Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse
Learn More
Overview

Azure SQL Data Warehouse is a Fast, flexible, and secure analytics platform for the enterprise. Azure SQL Data Warehouse lets you independently scale compute and storage, while pausing and resuming your data warehouse within minutes through a massively parallel processing architecture designed for the cloud. Seamlessly create your hub for analytics along with native connectivity with data integration and visualization services, all while using your existing SQL and BI skills.

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.

Offer
Learn more about Microsoft Azure Synapse Analytics
Learn more about Microsoft Parallel Data Warehouse
Sample Customers
Toshiba, Carnival, LG Electronics, Jet.com, Adobe, 
Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe
Top Industries
REVIEWERS
Comms Service Provider18%
Computer Software Company18%
Manufacturing Company12%
Financial Services Firm12%
VISITORS READING REVIEWS
Computer Software Company28%
Comms Service Provider18%
Financial Services Firm6%
Energy/Utilities Company6%
REVIEWERS
Computer Software Company27%
Pharma/Biotech Company18%
Comms Service Provider9%
Hospitality Company9%
VISITORS READING REVIEWS
Computer Software Company27%
Comms Service Provider16%
Financial Services Firm9%
Insurance Company9%
Company Size
REVIEWERS
Small Business32%
Midsize Enterprise23%
Large Enterprise45%
VISITORS READING REVIEWS
Small Business15%
Midsize Enterprise13%
Large Enterprise72%
REVIEWERS
Small Business32%
Midsize Enterprise14%
Large Enterprise55%
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon and others in Cloud Data Warehouse. Updated: November 2021.
553,954 professionals have used our research since 2012.

Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 34 reviews while Microsoft Parallel Data Warehouse is ranked 5th in Data Warehouse with 10 reviews. Microsoft Azure Synapse Analytics is rated 8.0, while Microsoft Parallel Data Warehouse is rated 7.6. The top reviewer of Microsoft Azure Synapse Analytics writes "Scalable, intuitive, facilitates compliance and keeping your data secure". On the other hand, the top reviewer of Microsoft Parallel Data Warehouse writes "Collects data through SSIS packages from different sources and puts them all in one data repository". Microsoft Azure Synapse Analytics is most compared with Snowflake, Amazon Redshift, SAP BW4HANA, Apache Hadoop and Teradata, whereas Microsoft Parallel Data Warehouse is most compared with Oracle Exadata, Snowflake, SAP BW4HANA, Teradata and Amazon Redshift.

We monitor all Cloud 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.