We performed a comparison between AWS Lake Formation 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 is quite good at handling analytics. It's done a good job at helping us centralize them."
"The most important advantage in using AWS Lake Formation is its ability to connect the data lake to the other technologies in AWS. This is what I advise my clients."
"The useability, the user interface, is very user-friendly."
"The features most valuable are the simplicity, how easy it is to create a dashboard from different information systems."
"The solution has been working well overall."
"One central workspace to manage everything for your data warehouse including visualization."
"The stability is pretty good."
"One of the most valuable features of this solution is its ability to integrate well with other services offered by Azure."
"Technical support is okay in terms of the help they provide."
"Synapse Analytics' best feature is its ability to process large files."
"In our experience what could be improved are not the support, performance or monitoring, but at a managerial level, the very expensive professional services of AWS. This could be an area of improvement for them. It's too expensive to acquire their support."
"For the end-users, it's not as user-friendly as it could be."
"Integration with other products is an area that can be improved."
"The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them."
"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."
"I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head."
"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."
"An area for improvement in Microsoft Azure Synapse Analytics is its user interface. You can use it for analytical purposes, but its platform should be a little bit more user-friendly. Another small point for improvement in Microsoft Azure Synapse Analytics is its stability. It's good currently, but it could still be improved. Microsoft is combining different tools and technologies into one solution, so in the future, I'm expecting to see even more improvement in Microsoft Azure Synapse Analytics. An additional feature I'd like to see in the next version of Microsoft Azure Synapse Analytics is the drag-and-drop feature. If you're doing some integrations where you can write Scala or you have SPARK programming or SQL, or you're combining different programming, the process should be seamless, and you should be able to drag and drop in Microsoft Azure Synapse Analytics. When doing reporting in the solution, you should also be able to drag and drop. There should be connectors available and a drag-and-drop feature available in the user interface of Microsoft Azure Synapse Analytics, so you won't have to worry about how all processes would work together. You need to be able to drag and drop even from the backend, and having this feature will make the solution more user-friendly."
"Scaling this solution up and down is not quick and easy. This could be improved. The pricing of this solution could also be improved."
"Synapse Analytics needs to develop an automation framework because now you have to build a cache yourself. You have to build a pipeline in WhereScape, which does end-to-end pipeline automation well. Microsoft should come up with a framework to save people time. If they developed a tool like WhereScape, it would dramatically reduce development time."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
AWS Lake Formation is ranked 11th in Cloud Data Warehouse with 2 reviews while Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 48 reviews. AWS Lake Formation is rated 8.0, while Microsoft Azure Synapse Analytics is rated 7.8. The top reviewer of AWS Lake Formation writes "Stable and good at handling analytics but needs to better accept integrations". On the other hand, the top reviewer of Microsoft Azure Synapse Analytics writes "Multifeatured, has better performance over other solutions, and lets users manage structured and unstructured information, but the platform needs to be more user-friendly". AWS Lake Formation is most compared with Snowflake, Amazon Redshift, Azure Data Factory, Amazon EMR and Apache Hadoop, whereas Microsoft Azure Synapse Analytics is most compared with Snowflake, Amazon Redshift, Azure Data Factory, SAP BW4HANA and Teradata. See our AWS Lake Formation 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.
