We performed a comparison between Amazon EMR and Microsoft Azure Synapse Analytics based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Amazon EMR's most valuable features are processing speed and data storage capacity."
"Amazon EMR is a good solution that can be used to manage big data."
"When we grade big jobs from on-prem to the cloud, we do it in EMR with Spark."
"One of the valuable features about this solution is that it's managed services, so it's pretty stable, and scalable as much as you wish. It has all the necessary distributions. With some additional work, it's also possible to change to a Spark version with the latest version of EMR. It also has Hudi, so we are leveraging Apache Hudi on EMR for change data capture, so then it comes out-of-the-box in EMR."
"The solution is scalable."
"The solution helps us manage huge volumes of data."
"The project management is very streamlined."
"This is the best tool for hosts and it's really flexible and scalable."
"We've had a good experience with technical support in general."
"The product works well with other Azure products."
"Azure Synapse combines the strengths of SQL technologies for effective enterprise data management."
"I like how Microsoft Azure Synapse Analytics integrates with other Microsoft solutions."
"The initial setup is very simple."
"The solution operates like a typical SQL Server environment so there is no alienation in terms of technical knowledge."
"The most valuable feature is the level of processing power, and being able to complete tasks in parallel."
"The most valuable features of Microsoft Azure Synapse Analytics are the user experience because it is easy to make analyses, load different databases, and different resources. Our end users can do the analysis by themselves without IT supervising. This is a great aspect of the solution, it's better for our environment."
"The product must add some of the latest technologies to provide more flexibility to the users."
"We don't have much control. If we have multiple users, if they want to scale up, the cost will go and increase and we don't know how we can restrict that price part."
"Modules and strategies should be better handled and notified early in advance."
"The legacy versions of the solution are not supported in the new versions."
"Amazon EMR can improve by adding some features, such as megastore services and HiveServer2. Additionally, the user interface could be better, similar to what Apache service provides, cross-platform services."
"There is room for improvement in pricing."
"There is no need to pay extra for third-party software."
"Amazon EMR is continuously improving, but maybe something like CI/CD out-of-the-box or integration with Prometheus Grafana."
"Microsoft Azure Synapse Analytics's overall integration within the Azure ecosystem could improve. The native Microsoft solution versus another solution, such as Databricks, there are areas where there could be some improvements."
"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."
"Synapse makes it easy to integrate and onboard data from other Microsoft and Azure sources. The interface is familiar because we were using Azure Data Factory before Synapse. It made the transition even easier because the Synapse interface is exactly the same."
"I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head."
"It's a complicated product."
"We encountered data processing and transformation issues while working with Apache Spark languages for the product."
"I am a researcher. For people to be able to research a solution, there should be at least a free trial. Just advertising a product or saying that this product is better doesn't work. I would strongly recommend providing a lot of free trials and trainings. This will also help Microsoft in having more users or customers. Oracle provides some free trials. You can just go for a free trial and use your database online, which is very good."
"The support and price could improve."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Amazon EMR is ranked 8th in Cloud Data Warehouse with 20 reviews while Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 86 reviews. Amazon EMR is rated 7.8, while Microsoft Azure Synapse Analytics is rated 7.8. The top reviewer of Amazon EMR writes "Provides efficient data processing features and has good scalability ". On the other hand, the top reviewer of Microsoft Azure Synapse Analytics writes "No competitors provide the entire solution to one place ". Amazon EMR is most compared with Snowflake, Cloudera Distribution for Hadoop, Azure Data Factory, Amazon Redshift and HPE Ezmeral Data Fabric, whereas Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and Microsoft Analytics Platform System. See our Amazon EMR vs. Microsoft Azure Synapse Analytics report.
See our list of best Cloud Data Warehouse vendors.
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.