Try our new research platform with insights from 80,000+ expert users

Amazon Redshift vs SAP IQ comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
6.2
Amazon Redshift offers mixed returns; beneficial for high data volumes, but concerns arise over rising costs and limited data effectiveness.
Sentiment score
7.0
SAP IQ offers a high ROI with low implementation costs and significant hardware savings, despite some users not tracking exact returns.
 

Customer Service

Sentiment score
6.8
Amazon Redshift's support is responsive but costly, with quick responses for routine issues, though advanced support can be inconsistent.
Sentiment score
5.6
SAP IQ's service is mixed, with good global support but issues with expertise, staff shortages, and inefficient initial responses.
 

Scalability Issues

Sentiment score
7.3
Amazon Redshift is generally praised for scalability, though experience varies with larger clusters and specific configurations.
Sentiment score
7.4
SAP IQ excels in scalability, with easy expansion, though some multiplex architecture limitations are noted by users.
The scalability part needs improvement as the sizing requires trial and error.
 

Stability Issues

Sentiment score
7.4
Amazon Redshift is praised for stability, high availability, and performance, despite occasional challenges with complex queries and environment changes.
Sentiment score
6.1
SAP IQ's stability has improved, handling high data volumes well, despite occasional issues in earlier versions under high load.
Amazon Redshift is a stable product, and I would rate it nine or ten out of ten for stability.
 

Room For Improvement

Amazon Redshift faces challenges in performance, integration, cost, and compatibility, needing improvements in speed, security, and serverless options.
SAP IQ needs better integration, stability, training, and affordability to overcome awareness and concurrency issues, enhancing user appeal.
They should bring the entire ETL data management process into Amazon Redshift.
 

Setup Cost

Amazon Redshift offers competitive pricing for large enterprises, but smaller organizations might find it more costly than alternatives.
SAP IQ offers cost-effective licensing options and economical implementation, ideal for large databases needing partitioning and performance evaluation.
The cost of technical support is high.
It's a pretty good price and reasonable for the product quality.
The pricing of Amazon Redshift is expensive.
 

Valuable Features

Amazon Redshift provides scalable, efficient data processing with AWS integration, offering robust analytics, security, and user-friendly features.
SAP IQ provides fast query processing, data compression, and scalability, ideal for BI with high data demands and user concurrency.
Amazon Redshift's performance optimization and scalability are quite helpful, providing functionalities such as scaling up and down.
Scalability is also a strong point; I can scale it however I want without any limitations.
Security configurations are implemented across all processes, such as AWS Config and GuardDuty.
 

Categories and Ranking

Amazon Redshift
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
70
Ranking in other categories
Cloud Data Warehouse (5th)
SAP IQ
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
21
Ranking in other categories
Relational Databases Tools (26th), Data Warehouse (13th)
 

Featured Reviews

Ved Prakash Yadav - PeerSpot reviewer
Works as a data warehouse system and collects data from different sources
In terms of improvement, I believe Amazon Redshift could work on reducing its costs, as they tend to increase significantly. Additionally, there are occasional issues with nodes going down, which can be problematic. We often encounter issues like someone dropping a column or changing the order of columns, which can cause synchronization problems when pushing data through our pipeline. It's a minor issue, but it can be annoying.
Tejas Raj - PeerSpot reviewer
Columnar database, so pulling records is easy but there isn't enough documentation for installation
I've seen very few SAP IQ systems in recent years. So people are moving away from SAP IQ In the last three years, I've rarely encountered customers using it. Fewer systems with SAP IQ usage among our customers. Most of them have moved on to HANA. There are parallel products, and there are also viable alternatives from AWS, so many have migrated to those.
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
846,617 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
64%
Financial Services Firm
6%
Computer Software Company
5%
Manufacturing Company
3%
Financial Services Firm
45%
Computer Software Company
9%
Manufacturing Company
6%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different dat...
What do you like most about Amazon Redshift?
The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good.
What is your experience regarding pricing and costs for SAP IQ?
IQ implementation costs about three thousand dollars. It's less expensive compared to alternatives like Teradata Base in terms of transactional efficiency.
What needs improvement with SAP IQ?
The primary negative aspect is the cost, which can be a challenge due to the economic conditions in Peru.
What is your primary use case for SAP IQ?
I worked on implementing new databases, migration data in production, and developer environments with SAP IQ.
 

Comparisons

 

Also Known As

No data available
Sybase IQ
 

Overview

 

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
ASR Group, Citrix, State of Indiana, PocketCard Co. Ltd.
Find out what your peers are saying about Amazon Redshift vs. SAP IQ and other solutions. Updated: April 2025.
846,617 professionals have used our research since 2012.