We performed a comparison between Amazon Aurora and SAP IQ based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The provision of custom read and write endpoints eliminates the need for managing a separate proxy load balancer."
"We had better control over the parameters that we could tweak in terms of intermediate storage and better indexing capabilities."
"Aurora's compatibility with MySQL or PostgreSQL benefited our database management. The migration from on-premise MySQL to Aurora was similar, so we didn't need to change our source code."
"The most valuable feature is that the maintainability is offloaded to the service provider. I don't have to maintain a database or do any administrative tasks, which comes in handy."
"The solution’s scalability is good since we don’t need to take a maintenance window during unpredictable workloads. I like the solution’s behind-the-scenes happenings. It is a great feature."
"The most valuable feature is the ability to do multiple-read and single-write. These are the kinds of features that we were interested in, and Aurora takes care of that natively."
"The most valuable feature of Amazon Aurora is SQL standardization, it doesn't have its own syntax which is good. It has a lot of hands-off self-management type of activities, such as log rolling and auto-scaling."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"The initial setup is easy."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"The product is easy to learn."
"Columnar storage allows high compression, high load rates and high query performance."
"Unbeatable speed and compression with a colummn-structured relational database."
"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 column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"There is improvement needed to have more developer focus. Additionally, it would be helpful to have a stand-alone solution outside of Amazon. Amazon has a tendency to favor developing web-based clients, which may not always provide the fastest or most responsive solution as desired."
"The pricing could improve. It should be reduced."
"It is a bit costly. The features are quite good, and I wouldn't say it requires any technical improvements. But from a cost perspective, some clients wouldn't go for Aurora because of that."
"It would have been helpful if they had provided some benchmarking numbers."
"I would like to see more AI-related features in future releases."
"The product's distributed query process for MySQL needs improvement."
"I would like to see performance insights on the database based on the queries. Currently, we use SolarWinds as the monitoring tool. I would like to leverage SolarWinds’ performance insights in AWS services. SolarWinds gives larger insights when we run performance issues."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"There is very little documentation available."
"The tool gets stuck sometimes."
"I think the universe should be part of the Sybase IQ tool set."
"Concurrency and functional error messaging."
"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."
Amazon Aurora is ranked 11th in Relational Databases Tools with 7 reviews while SAP IQ is ranked 21st in Relational Databases Tools with 19 reviews. Amazon Aurora is rated 7.8, while SAP IQ is rated 7.8. The top reviewer of Amazon Aurora writes "Easy-to-manage platform with a valuable auto-scaling feature ". On the other hand, the top reviewer of SAP IQ writes "Easy to use, highly stable, but integration could improve". Amazon Aurora is most compared with SQL Server, Oracle Database, MariaDB, CockroachDB and MySQL, whereas SAP IQ is most compared with Snowflake, SAP HANA, SQL Server, SAP BW4HANA and Apache Hadoop. See our Amazon Aurora vs. SAP IQ report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools 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.