AWS Lake Formation vs SAP IQ comparison

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

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

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

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

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

"AWS Lake Formation has several valuable features that enhance data management, and one particularly beneficial aspect is how it facilitates better collaboration within data teams."

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

"In the shortest form, what I appreciated about AWS Lake Formation was that the schema definition and data cataloging were quite good."

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

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

"Unbeatable speed and compression with a colummn-structured relational database."

"The product is easy to learn."

"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."

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

"SAP IQ is actually quite effective when it comes to scalability; we have a setup that's built with multiple servers involved and that seems to be working fairly efficiently, and if we wanted to add more servers into this entire setup, that would be fairly easy."

"The initial setup is easy."

"Athena can be a bit clunky when writing queries, indicating a potential enhancement point for easier user interaction with query tools such as DataGrip using provided driver JARs."

"Despite following official documentation, configuration problems persisted, requiring weeks of support from multiple AWS engineers to resolve."

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

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

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

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

"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 tool gets stuck sometimes."

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

"Multiplex is very problematic. There are consistency problems in the metadata, meaning it is possible to lose metadata consistency. You should make sure you have healthy backups."

"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 organization who owns the product does not support it well and appears not to be doing significant development for the future."

"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."

"AWS Lake Formation is a bit expensive."

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

"Negotiation is very important."

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

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

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

"Negotiate based on the features required."