AWS Lake Formation vs Microsoft Analytics Platform System comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between AWS Lake Formation and Microsoft Analytics Platform System 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.
To learn more, read our detailed AWS Lake Formation vs. Microsoft Analytics Platform System Report (Updated: March 2024).
768,246 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The solution has many features that are applicable to events such as audits.""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.""It is seamlessly integrated within the AWS ecosystem, making it straightforward to manage access patterns for AWS-native services.""We use AWS Lake Formation typically for the data warehouse.""The solution is quite good at handling analytics. It's done a good job at helping us centralize them."

More AWS Lake Formation Pros →

"I like that it's integrated with other Azure products.""It is closely integrated with other products in the MS portfolio.""We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services.""Helps our customers to discover trends, which provides useful information based on their business.""This is a well-integrated solution and that integration empowers results.""The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics.""Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases.""This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."

More Microsoft Analytics Platform System Pros →

Cons
"AWS Lake Formation's pricing could be cheaper.""It falls short when it comes to more granular access control, such as cell-level or row-level entitlements which is a significant drawback for organizations that require precise control over who can access specific rows of data.""For the end-users, it's not as user-friendly as it could be.""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.""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."

More AWS Lake Formation Cons →

"​Hybrid environments are complex to manage.""Functionality needs to be more up-to-date with competing products.""We need better real-time analytics capabilities. It's a bit challenging for us.""Machine learning and artificial intelligence capabilities need to be more friendly for beginning users.""The pricing model needs to be improved.""Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release.""I think the biggest problem with the product is that it does a data ingest model, which is very expensive.""Microsoft Analytics Platform System could have better support."

More Microsoft Analytics Platform System Cons →

Pricing and Cost Advice
  • "AWS Lake Formation is a bit expensive."
  • More AWS Lake Formation Pricing and Cost Advice →

  • "The initial price is lower than Oracle, but extensive use of SQL may lead to a higher total cost of ownership."
  • "Users have to pay extra for premium-level technical support."
  • "We are currently paying $200,000 a year for all the different parts of the suite during an ingest model Microsoft now charges us $700,000 a year."
  • "I rate Microsoft Analytics Platform System a seven out of ten for pricing."
  • More Microsoft Analytics Platform System Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    768,246 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:It is seamlessly integrated within the AWS ecosystem, making it straightforward to manage access patterns for AWS-native services.
    Top Answer:There are significant challenges when dealing with external applications, and vendors, or pursuing a hybrid cloud strategy because AWS Lake Formation is specific to AWS and does not integrate… more »
    Top Answer:We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services.
    Top Answer:It's not too confusing. It's based on features, and we don't have to buy additional licenses.
    Top Answer:We need better real-time analytics capabilities. It's a bit challenging for us. Moreover, there are some permission limitations.
    Ranking
    12th
    Views
    5,155
    Comparisons
    4,294
    Reviews
    1
    Average Words per Review
    578
    Rating
    6.0
    17th
    out of 34 in Data Warehouse
    Views
    323
    Comparisons
    240
    Reviews
    2
    Average Words per Review
    439
    Rating
    7.5
    Comparisons
    Also Known As
    Microsoft APS, MS Analytics Platform System
    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.

    The Microsoft Analytics Platform System can meet the demands of your evolving data warehouse environment with its scale-out, massively parallel processing integrated system supporting hybrid data warehouse scenarios. It provides the ability to query across relational and non-relational data by leveraging Microsoft PolyBase and industry-leading big data technologies. It offers the lowest price per terabyte for large data warehouse workloads.
    Sample Customers
    bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday
    Transport for London, E-Plus Mobilfunk GmbH & Co. KG, Prometeia, Tangerine, SSM Health Care, Service Corporation International
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm21%
    Computer Software Company13%
    Manufacturing Company8%
    Healthcare Company5%
    VISITORS READING REVIEWS
    Financial Services Firm12%
    Computer Software Company11%
    University11%
    Energy/Utilities Company9%
    Company Size
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise10%
    Large Enterprise73%
    REVIEWERS
    Small Business36%
    Large Enterprise64%
    VISITORS READING REVIEWS
    Small Business22%
    Midsize Enterprise5%
    Large Enterprise73%
    Buyer's Guide
    AWS Lake Formation vs. Microsoft Analytics Platform System
    March 2024
    Find out what your peers are saying about AWS Lake Formation vs. Microsoft Analytics Platform System and other solutions. Updated: March 2024.
    768,246 professionals have used our research since 2012.

    AWS Lake Formation is ranked 12th in Cloud Data Warehouse with 5 reviews while Microsoft Analytics Platform System is ranked 17th in Data Warehouse with 9 reviews. AWS Lake Formation is rated 7.6, while Microsoft Analytics Platform System is rated 6.6. The top reviewer of AWS Lake Formation writes "Strategically aligning data management in a multi-cloud environment with significant reporting challenges". On the other hand, the top reviewer of Microsoft Analytics Platform System writes "Offers smooth data integration between systems, but requires better real-time analytics capabilities". AWS Lake Formation is most compared with Snowflake, Azure Data Factory, Amazon Redshift, Microsoft Azure Synapse Analytics and BigQuery, whereas Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics, Teradata, IBM Netezza Performance Server and Snowflake. See our AWS Lake Formation vs. Microsoft Analytics Platform System 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.