We performed a comparison between Amazon EMR and SAP IQ based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."We are using applications, such as Splunk, Livy, Hadoop, and Spark. We are using all of these applications in Amazon EMR and they're helping us a lot."
"The project management is very streamlined."
"It has a variety of options and support systems."
"When we grade big jobs from on-prem to the cloud, we do it in EMR with Spark."
"Amazon EMR's most valuable features are processing speed and data storage capacity."
"The solution helps us manage huge volumes of data."
"The solution is pretty simple to set up."
"The initial setup is straightforward."
"Columnar storage allows high compression, high load rates and high query performance."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"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."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"The legacy versions of the solution are not supported in the new versions."
"Amazon EMR is continuously improving, but maybe something like CI/CD out-of-the-box or integration with Prometheus Grafana."
"As people are shifting from legacy solutions to other technologies, Amazon EMR needs to add more features that give more flexibility in managing user data."
"The product's features for storing data in static clusters could be better."
"We don't have much control. If we have multiple users, if they want to scale up, the cost will go and increase and we don't know how we can restrict that price part."
"There were times where they would release new versions and it seemed to end up breaking old versions, which is very strange."
"The most complicated thing is configuring to the cluster and ensure it's running correctly."
"The problem for us is it starts very slow."
"Concurrency and functional error messaging."
"I think the universe should be part of the Sybase IQ tool set."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"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."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
Amazon EMR is ranked 8th in Cloud Data Warehouse with 20 reviews while SAP IQ is ranked 21st in Relational Databases Tools with 17 reviews. Amazon EMR is rated 7.8, while SAP IQ is rated 8.0. The top reviewer of Amazon EMR writes "Provides efficient data processing features and has good scalability ". On the other hand, the top reviewer of SAP IQ writes "Easy to use, highly stable, but integration could improve". Amazon EMR is most compared with Snowflake, Cloudera Distribution for Hadoop, Azure Data Factory, Amazon Redshift and Apache Spark, whereas SAP IQ is most compared with Snowflake, SAP HANA, SAP BW4HANA, SQL Server and Apache Hadoop. See our Amazon EMR vs. SAP IQ report.
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.