We changed our name from IT Central Station: Here's why

AWS Lake Formation vs Microsoft Azure Synapse Analytics comparison

Cancel
You must select at least 2 products to compare!
Featured Review
Find out what your peers are saying about AWS Lake Formation vs. Microsoft Azure Synapse Analytics and other solutions. Updated: January 2022.
563,148 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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."

More AWS Lake Formation Pros →

"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."

More Microsoft Azure Synapse Analytics Pros →

Cons
"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."

More AWS Lake Formation Cons →

"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."

More Microsoft Azure Synapse Analytics Cons →

Pricing and Cost Advice
Information Not Available
  • "All of the prices are available online."
  • "Our license is very expensive"
  • "They are cost aggressive, and it integrates well with other Microsoft tools."
  • "There is a cost calculator available online that allows you to input your entire scenario, and it will get back to you with information on what the costs are going to be."
  • "Its price could be better. It was a school project, and I got it for free. If I try to pay through my company, it is a little bit more expensive as compared to Oracle."
  • "The price of the package not expensive and depends on how much it is used."
  • "The cost of the licensing depends on the size of the warehouse, where the cost of storage is approximately $130 USD per terabyte."
  • "This is a cost-effective product."
  • More Microsoft Azure Synapse Analytics Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    563,148 professionals have used our research since 2012.
    Questions from the Community
    Ask a question

    Earn 20 points

    Top Answer: 
    Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different… more »
    Top Answer: 
    Traditional ETL would usually use a dedicated database (or even database server) where you'll load & transform your raw data before ingesting it into the final destination. This would allow checking… more »
    Top Answer: 
    Fills the gap between big data and classic data warehouses.
    Ranking
    9th
    Views
    1,809
    Comparisons
    1,315
    Reviews
    3
    Average Words per Review
    712
    Rating
    8.0
    2nd
    Views
    26,962
    Comparisons
    19,760
    Reviews
    31
    Average Words per Review
    530
    Rating
    8.0
    Comparisons
    Also Known As
    Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse, MS Azure Synapse Analytics
    Learn More
    Overview

    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.

    Offer
    Learn more about AWS Lake Formation
    Learn more about Microsoft Azure Synapse Analytics
    Sample Customers
    bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday
    Toshiba, Carnival, LG Electronics, Jet.com, Adobe, 
    Top Industries
    VISITORS READING REVIEWS
    Computer Software Company23%
    Media Company15%
    Comms Service Provider14%
    Financial Services Firm9%
    REVIEWERS
    Computer Software Company21%
    Comms Service Provider16%
    Manufacturing Company11%
    Insurance Company11%
    VISITORS READING REVIEWS
    Computer Software Company27%
    Comms Service Provider18%
    Financial Services Firm6%
    Energy/Utilities Company6%
    Company Size
    No Data Available
    REVIEWERS
    Small Business33%
    Midsize Enterprise21%
    Large Enterprise46%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise13%
    Large Enterprise71%
    Find out what your peers are saying about AWS Lake Formation vs. Microsoft Azure Synapse Analytics and other solutions. Updated: January 2022.
    563,148 professionals have used our research since 2012.

    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.