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."-"
"The most valuable features of Microsoft Azure Synapse Analytics are the interface and the agility of the on-cloud platform."
"The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis."
"The pricing seems to be quite fair."
"The most valuable feature of the solution is the analytics and that it can connect with Power BI."
"The speed is great and the architecture is excellent."
"The product is very user friendly."
"Synapse Analytics gives you information and reports in real-time."
"It is a very stable database."
"The most valuable feature of this solution is performance."
"Data collection and reporting are valuable features of the solution."
"The most valuable feature for me is querying."
"We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."
"We can store the data in a data lake for a very low cost."
"It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time."
"We have complete control over our data."
"In the future, Microsoft Azure Synapse Analytics has the potential to enhance its capabilities by expanding its connectors, specifically with regard to Oracle solutions, such as operating systems. This would involve a comprehensive approach to adding more connectors for both data input and consumption purposes. By doing so, Microsoft Azure Synapse Analytics would be better equipped to meet the diverse needs of its users and achieve greater efficiency in its performance. The provision of more connectors is definitely a crucial area that needs improvement."
"There may be some challenges in terms of connecting with Virtual Networks (VNETs) to Microsoft Azure Synapse Analytics."
"I would like to see better integration with Active Directory, because we have had problems, and we still do."
"Integration with other products is an area that can be improved."
"The performance needs to improve in future releases."
"The support and price could improve."
"We encountered data processing and transformation issues while working with Apache Spark languages for the product."
"I would like to see them provide the ingestion of images."
"Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced."
"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."
"It needs more compatibility with common BI tools."
"It could offer more development across the solution."
"The only issue with the product is that the process is very slow when we have a huge amount of data."
"I would like the tool to support different operating systems."
"The solution is expensive and has room for improvement."
"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.