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."The solution helps us manage huge volumes of data."
"The solution is scalable."
"It has a variety of options and support systems."
"In Amazon EMR it is easy to rebuild anything, easy to upgrade and has good fault tolerance."
"The project management is very streamlined."
"The initial setup is straightforward."
"The initial setup is pretty straightforward."
"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 most valuable feature is performance gains."
"The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs."
"Azure elasticity allows us to scale as much as we want, and it is pay-as-you-go, so we can scale up as we need to."
"The solution offers strong scalability opportunities."
"What I found most valuable in Microsoft Azure Synapse Analytics is that it's native only for Azure, so you get better performance and there's no issue. To explain further, many different types of data come, in particular, structured and unstructured data. For audit purposes, there's also unstructured data, so the most important aspect is that with Microsoft Azure Synapse Analytics, you have the capability of using both technologies, meaning that you can use or mix structured and unstructured data which is important. This can also be done in Hadoop, and on other platforms, so you have everything in one place. You don't have to worry about how to manage both structured and unstructured data and where to store information. With Microsoft Azure Synapse Analytics, you can take care of everything, particularly in Azure. The solution also provides you with many features apart from analytics, for example, storage which makes it better."
"Its seamless integration with Azure services is most valuable. If somebody wants to use all Azure services, it is the best solution."
"Our primary use case is for gathering data and analytics. We provide insights into vehicle data. We gather millions of records per second and we have various millions of vehicles running across."
"The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range."
"Amazon EMR is continuously improving, but maybe something like CI/CD out-of-the-box or integration with Prometheus Grafana."
"There is room for improvement in pricing."
"The initial setup was time-consuming."
"The dashboard management could be better. Right now, it's lacking a bit."
"There were times where they would release new versions and it seemed to end up breaking old versions, which is very strange."
"There is no need to pay extra for third-party software."
"As people are shifting from legacy solutions to other technologies, Amazon EMR needs to add more features that give more flexibility in managing user data."
"The problem for us is it starts very slow."
"It would be beneficial to take the top vendors and identify some kind of straightforward action to work with them. Instead of having to employ a separate vendor tool to be able to move this, it would be nice to be able to go through Microsoft."
"More integration is needed to improve the product for the future."
"The linked services can be improved. We can create dynamic linked services to access a lot of databases but only those of the same type. For example, I can use the same linked services to access 11 SQL databases. However, if I have 11 SQL databases and five Oracle databases, I need two dynamic linked services. I cannot do it with only one linked service. The UI also needs to be improved. When I have used Azure Synapse for programming with PySpark, Scala, or .NET, for example, the UI has been unstable. If I open two notebooks for programming, one notebook will queue the session of the other."
"I would like to see version control implemented into the data warehouse."
"The configuration for things like high-availability could be more user-friendly for non-technical users."
"It would be of interest to improve things like the web service integration and availability in terms of being easy to create internal web services in the database."
"It would be ideal if the solution could be better used intuitively by the staff without having a great deal of training."
"While the solution is flexible, sometimes this works against the user."
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.
