"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 solution has many features that are applicable to events such as audits."
"The features most valuable are the simplicity, how easy it is to create a dashboard from different information systems."
"Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task."
"Technical support is okay in terms of the help they provide."
"It's user-friendly and has a good dashboard."
"Fills the gap between big data and classic data warehouses."
"The most valuable feature is that you can suspend the computer if it is not being used, which means that you don't incur costs."
"Overall deployment and integration is pretty fast."
"Very interactive and provides flexibility."
"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."
"The solution could make improvements around orchestration and doing some automation stuff on AWS front automation. It would be useful if we could use automation to build images and use hardened images which are CIS compliant."
"For the end-users, it's not as user-friendly as it could be."
"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."
"It needs strong support for social media, internet data, and native support for NoSQL."
"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."
"Comes with a pretty steep learning curve."
"I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head."
"I would like to see them provide the ingestion of images."
"Right now, we are really struggling with the performance. it's not as good as we had hoped."
"It would be ideal if the solution could be better used intuitively by the staff without having a great deal of training."
Earn 20 points
AWS Lake Formation is a service that makes it easy to set up a secure data lake in days. A data lake is a centralized, curated, and secured repository that stores all your data, both in its original form and prepared for analysis.
Azure SQL Data Warehouse is a Fast, flexible, and secure analytics platform for the enterprise. Azure SQL Data Warehouse lets you independently scale compute and storage, while pausing and resuming your data warehouse within minutes through a massively parallel processing architecture designed for the cloud. Seamlessly create your hub for analytics along with native connectivity with data integration and visualization services, all while using your existing SQL and BI skills.
AWS Lake Formation is ranked 9th in Cloud Data Warehouse with 3 reviews while Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 33 reviews. AWS Lake Formation is rated 8.0, while Microsoft Azure Synapse Analytics is rated 8.0. The top reviewer of AWS Lake Formation writes "Good security, excellent online resources and easy to set up". On the other hand, the top reviewer of Microsoft Azure Synapse Analytics writes "Scalable, intuitive, facilitates compliance and keeping your data secure". AWS Lake Formation is most compared with Snowflake, Azure Data Factory, Amazon EMR and Firebolt, whereas Microsoft Azure Synapse Analytics is most compared with Snowflake, Amazon Redshift, SAP BW4HANA, Apache Hadoop 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.