AWS Lake Formation vs IBM Db2 Warehouse on Cloud comparison

Cancel
You must select at least 2 products to compare!
Amazon Web Services (AWS) Logo
5,155 views|4,294 comparisons
75% willing to recommend
IBM Logo
327 views|295 comparisons
83% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between AWS Lake Formation and IBM Db2 Warehouse on Cloud based on real PeerSpot user reviews.

Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon Web Services (AWS) and others in Cloud Data Warehouse.
To learn more, read our detailed Cloud Data Warehouse Report (Updated: March 2024).
767,847 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.""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 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 is quite good at handling analytics. It's done a good job at helping us centralize them."

More AWS Lake Formation Pros →

"It will be MPP, so performance should improve.""The performance is okay as long as the volume of queries is not too high.""The way that it scales will help a lot of customers that are stuck with Netezza boxes that can't grow any larger.​"

More IBM Db2 Warehouse on Cloud 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 →

"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either.""Tech support for dashDB is awful. We usually have tickets open for three to four weeks.""Right now, we are implementing on ESX VMware 6.0. Support for this platform is poor. Also, one of the backup/recovery options is broken and IBM is not addressing the issue.""Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues."

More IBM Db2 Warehouse on Cloud Cons →

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

  • "If your going to go with warehouse DB/dashDB, use the cloud or Sailfish version."
  • More IBM Db2 Warehouse on Cloud Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    767,847 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:Organizations of all sizes, especially those who are in need of powerful and elastic cloud data warehouse solutions that can help administrators maximize the efficiency of their data-based operations… more »
    Ranking
    12th
    Views
    5,155
    Comparisons
    4,294
    Reviews
    1
    Average Words per Review
    578
    Rating
    6.0
    15th
    Views
    327
    Comparisons
    295
    Reviews
    0
    Average Words per Review
    0
    Rating
    N/A
    Comparisons
    Also Known As
    IBM dashDB
    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.

    IBM dashDB family offers private and public cloud database solutions for transactional and analytic workloads, with IBM fully managed or client managed options with a Common SQL engine across all deployment options.

    Sample Customers
    bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday
    Copenhagen Business School, BPM Northwest, GameStop
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm21%
    Computer Software Company12%
    Manufacturing Company8%
    Healthcare Company5%
    VISITORS READING REVIEWS
    Financial Services Firm16%
    University9%
    Manufacturing Company9%
    Computer Software Company8%
    Company Size
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise10%
    Large Enterprise73%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise10%
    Large Enterprise75%
    Buyer's Guide
    Cloud Data Warehouse
    March 2024
    Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon Web Services (AWS) and others in Cloud Data Warehouse. Updated: March 2024.
    767,847 professionals have used our research since 2012.

    AWS Lake Formation is ranked 12th in Cloud Data Warehouse with 5 reviews while IBM Db2 Warehouse on Cloud is ranked 15th in Cloud Data Warehouse. AWS Lake Formation is rated 7.6, while IBM Db2 Warehouse on Cloud is rated 7.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 IBM Db2 Warehouse on Cloud writes "The "prefetch" feature anticipates needed data and keeps it available. BLU acceleration determines what data is unqualified for analysis and skips it". AWS Lake Formation is most compared with Snowflake, Azure Data Factory, Amazon Redshift, Microsoft Azure Synapse Analytics and BigQuery, whereas IBM Db2 Warehouse on Cloud is most compared with Amazon Redshift, IBM Db2 Warehouse, IBM Netezza Performance Server, Microsoft Azure Synapse Analytics and Snowflake.

    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.