AWS Lake Formation vs SAP IQ comparison

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

"AWS Lake Formation significantly improves the structure of the data mesh, making it superior to previous structures we used."

"A favorite feature of AWS Lake Formation is that it provides us with visibility into who has access to a particular table or database in Glue."

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

"The features and capabilities of AWS Lake Formation that I have found most valuable are that it is really convenient to see all the different data assets that were configured and understand who has and what type of service has or does not have access to those services."

"We have observed measurable benefits in terms of cost savings, time savings, resource savings, and efficiency improvements in our workflows."

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

"The most valuable features of AWS Lake Formation were the access model itself, as it allows implementation of filters, Blueprints, and row-level and column-level security to mask data that shouldn't be accessed by certain entities, enabling granular control without exposing PII data."

"IQ is a very high-performance and high-transaction database."

"Columnar storage allows high compression, high load rates and high query performance."

"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."

"All data is compressed and indexed, allowing for fast execution of transactions."

"The initial setup is easy."

"The primary benefit of SAP IQ is its ability to limit the expansion of the costly SAP HANA database, which has limited storage capacity. This necessitates a form of data management that involves moving data from SAP HANA to SAP NLS, which is essentially archiving. This allows us to retain access to the data via a link whenever it is required."

"The product is easy to learn."

"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."

"I think AWS Lake Formation could improve by enforcing the least privilege by design, moving from ad hoc grants to role-based access controls."

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

"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 current setup, everyone from my business unit uses the same consumer account. When access is requested for a table, everyone using that business unit account receives access. This could present a security concern, though it benefits new team members who automatically receive all necessary access permissions."

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

"In our current setup, everyone from my business unit uses the same consumer account. When access is requested for a table, everyone using that business unit account receives access. This could present a security concern, though it benefits new team members who automatically receive all necessary access permissions."

"I would appreciate online support, which I don't have access to in my corporation at the bank, so that is important."

"The tool gets stuck sometimes."

"The organization who owns the product does not support it well and appears not to be doing significant development for the future."

"In my interaction with SAP IQ's technical support, the people we are talking to don't know this application very thoroughly."

"I think the universe should be part of the Sybase IQ tool set."

"The primary negative aspect is the cost, which can be a challenge due to the economic conditions in Peru."

"The only negative aspect of IQ is the cost, which can be challenging for companies in Peru."

"There is very little documentation available."

"The downside I see is that it doesn't allow most integrated backups; many of the marketplace players such as NetBackup or Veritas, those software integrated backups are not available."

"AWS Lake Formation is a bit expensive."

"The cost of implementation is about $3,000."

"Negotiate based on the features required."

"Evaluate all options; check to see if you need expensive add-ons."

"The only costs after standard licensing fees are for add-ons and upgrades."

"Negotiation is very important."

"It's not that costly. So, the pricing is cheap."