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 product is very user friendly."
"The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range."
"We have found that it is easy to develop and to do the analytics in the modules of data."
"The initial setup is very simple."
"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 features of Microsoft Azure Synapse Analytics are its serverless flexibility and complete power have allowed me to explore various different use cases. While I am not an expert in the product, my experience in programming in Databricks has shown me that Microsoft's investments in Synapse could potentially lead to it becoming a complete replacement for Databricks in the future."
"The most valuable feature is the level of processing power, and being able to complete tasks in parallel."
"The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis."
"The most valuable features are the performance and usability."
"We can store the data in a data lake for a very low cost."
"The most valuable feature is the business intelligence (BI) part of it."
"The data transmissions between the data models is the most valuable feature."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."
"We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."
"I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets."
"Microsoft Azure Synapse Analytics can improve by adding more flexibility to the reports. Having more visible structures based on the area, region and country would be beneficial."
"The cost of the solution has room for improvement."
"They should provide a less expensive version with a smaller setup for small businesses. Currently, its price is quite high for entry-level or small businesses. In terms of integration, new connectors are always welcomed."
"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."
"Its stability is an issue. They have been releasing a version every six months to one year, which means that there are many versions available, and clients are not up to speed on the latest one that they're offering. From a stability point of view, they could do better. They're still upgrading their Synapse Analytics workspace, and it is not that stable. Its scalability can also be better."
"Microsoft Azure Synapse Analytics can improve by increasing the size of the files that we can load on the platform. We have some files that are too large to be loaded and it would be a benefit to us if the limit was increased. Additionally, the way we use the tool for generating reports can be made better. They should add some drag-and-drop rules without the need of programming these rules using some programming language. It would be helpful if we did not need someone that was technically advanced to be able to do it with, such as someone with no IT background. Having a reporting tool without code would be great."
"I would like to see better integration with Active Directory, because we have had problems, and we still do."
"The only concern for us is the cost part. When it comes to the implementation and the support and maintenance, we see high-cost implications."
"SQL installation is pretty tricky. The scalability and customer support also should be improved."
"The reporting for certain types of data needs to be improved."
"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 only issue with the product is that the process is very slow when we have a huge amount of data."
"It could offer more development across the solution."
"The query is slow if we don't optimize it."
"The solution is expensive and has room for improvement."
"This solution would be improved with an option for in-memory data analysis."
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.