We performed a comparison between Microsoft Azure Synapse Analytics and Microsoft Parallel Data Warehouse based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."I like SQL post, which is for storage and distributed computing. Another good feature is the copy activity."
"We use Azure Synapse Analytics in many different areas and industries, so I like that you can administrate and create pipelines for difference sources of data and later integrate and deploy it to other internal areas, such as separate dashboards for financials, and so on."
"The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services."
"The most valuable feature of Microsoft Azure Synapse Analytics is the capabilities, and the integration with other Azure resources, such as Data Factory, Databricks, and Spark for data processing. The overall ability to compose the solution with other Azure resources is valuable."
"It's quite quick for querying, even with large datasets, and it's scalable. It's also flexible to use, so it's easy to update and get data quickly without wasting time."
"The most valuable feature of Microsoft Azure Synapse Analytics is the pipeline that is the ETL tool. It's very well designed and is overall very good. We usually don't use the ETL tool in Databricks, but we use the ETL tool in this solution."
"Technical support is okay in terms of the help they provide."
"I think the most valuable component is that pipelines are built into it and then the feature that you can mirror a cosmos BB for analytics."
"It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time."
"It is a very stable database."
"We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"We have complete control over our data."
"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 most valuable features are the performance and usability."
"We can store the data in a data lake for a very low cost."
"I would like to see more ready-to-use products from Synapse. Right now, everything seems a bit futuristic without much modern use."
"The platform is not flexible, and the graphical user interface needs to be improved because the interface makes it hard for the end user to use it."
"It could be beneficial to focus on integration with various data sources and similar enhancements."
"Microsoft should develop an interface to make it easier to shift from on-premise to the cloud."
"It could be more stable."
"The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them."
"The need to improve a little bit in terms of user-friendliness."
"There is a limit on the number of concurrent queries to around 125 for Azure Synapse."
"The only issue with the product is that the process is very slow when we have a huge amount of data."
"The product does not have all of the features that the native products have."
"SQL installation is pretty tricky. The scalability and customer support also should be improved."
"I would like to see better visualization features."
"The solution is expensive and has room for improvement."
"The product must provide more frequent updates."
"Some compatibility issues occur during deployment, so we need to build the product from scratch for some features."
"I would like the ability to do more real-time type updates instead of batch-oriented updates."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 85 reviews while Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 32 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while Microsoft Parallel Data Warehouse is rated 7.6. The top reviewer of Microsoft Azure Synapse Analytics writes "No competitors provide the entire solution to one place ". On the other hand, the top reviewer of Microsoft Parallel Data Warehouse writes "An easy to setup tool that allows its users to write stored procedure, making it a scalable product". Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and Vertica, whereas Microsoft Parallel Data Warehouse is most compared with Oracle Exadata, SAP BW4HANA, VMware Tanzu Greenplum and Snowflake. See our Microsoft Azure Synapse Analytics vs. Microsoft Parallel Data Warehouse report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all 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.