AWS Lake Formation vs IBM Db2 Warehouse comparison

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

"I can easily move data from cold storage to regular storage."

"It is seamlessly integrated within the AWS ecosystem, making it straightforward to manage access patterns for AWS-native services."

"AWS Lake Formation lets you see all your data and tables on one screen."

"We use AWS Lake Formation typically for the data warehouse."

"AWS Lake Formation works hand in hand with other products."

"The solution has many features that are applicable to events such as audits."

"The solution is quite good at handling analytics. It's done a good job at helping us centralize them."

"I think it scales really well and as long as you take enough time to learn a little bit about it, it works really well."

"The solution is stable."

"It can scale effectively as long as resources are available."

"Some of the best features are stored procedures, parallelism, and different indexing strategies."

"The most valuable features of IBM Db2 Warehouse include its availability, easy integration, ability to deal with a large size of data, excellent performance with no delays, powerful security mechanisms, and effective support."

"It can be mounted on the cloud, which is a huge plus. If the client, for example, starts small with on-premise deployment and then it rapidly needs to grow, we can transfer this to the cloud easily."

"Provides good security and reliability."

"The analytics engine is not bad at forecasting predictions."

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

"Lake Formation could enhance its capabilities in audit logs, real-time monitoring, and advanced data governance."

"If I could improve AWS Lake Formation, I would add more integrations with SageMaker."

"For the end-users, it's not as user-friendly as it could be."

"AWS Lake Formation's pricing could be cheaper."

"You need to have data experience to use the product."

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

"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 terms of improvement, IBM Db2 Warehouse should be more scalable."

"There were some initial challenges with IBM Db2 Warehouse about eight months ago when I worked in this environment. When I coordinated with IBM support, they mentioned that the memory was insufficient for our needs. Our business environment required significantly more memory than the previous cluster could provide. Consequently, we have worked closely with on-site IBM technical personnel to address this issue."

"The primary challenges customers face with IBM Db2 Warehouse are related to its complexity in usage. It requires highly skilled professionals who understand Db2, and both training and support are challenging to obtain."

"There should be more material available for training and training should be free."

"The biggest challenge anyone could have with Db2 Warehouse is their references or online resources and documentation. They are very, very, very limited on the web."

"The biggest problems we have is when the backup solution is failing or slow and we run out of log space, which has happened probably a couple of times in the last four years."

"It takes a long time to have a new version or release, similar to Oracle."

"IBM Db2 Warehouse needs to improve its interface."

"AWS Lake Formation is a bit expensive."

"In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."