We performed a comparison between Oracle Autonomous Data Warehouse 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."One advantage is that if you already have an Oracle Database, it easily integrates with that."
"It is a very stable tool...It is an extremely scalable tool."
"The product is easy to use."
"The performance and scalability are awesome."
"With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main reason we use it."
"A very good integration feature that restricts access to unauthorized people."
"The analytics have been very good. We've found them to be quite useful."
"The solution integrates well with Power BI."
"Unbeatable speed and compression with a colummn-structured relational database."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"Columnar storage allows high compression, high load rates and high query performance."
"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 solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"Ease of connectivity could be improved."
"They should make the solution more user-friendly."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"It doesn't work well when you have unstructured data or you need online analytics. It is not as nice as Hadoop in these aspects."
"A lot of the tools that were previously there have now been taken away."
"An improvement for us would be the inclusion of support for an internal IP, so we could use it directly with the VCN in Oracle Cloud."
"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
"I think the universe should be part of the Sybase IQ tool set."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"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."
"Concurrency and functional error messaging."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
More Oracle Autonomous Data Warehouse Pricing and Cost Advice →
Oracle Autonomous Data Warehouse is ranked 10th in Cloud Data Warehouse with 16 reviews while SAP IQ is ranked 21st in Relational Databases Tools with 17 reviews. Oracle Autonomous Data Warehouse is rated 8.6, while SAP IQ is rated 8.0. The top reviewer of Oracle Autonomous Data Warehouse writes "A tool for data warehousing that offers scalability, stability, and ease of setup". On the other hand, the top reviewer of SAP IQ writes "Easy to use, highly stable, but integration could improve". Oracle Autonomous Data Warehouse is most compared with Oracle Exadata, Snowflake, Microsoft Azure Synapse Analytics, BigQuery and Amazon Redshift, whereas SAP IQ is most compared with Snowflake, SAP HANA, SAP BW4HANA, SQL Server and Apache Hadoop. See our Oracle Autonomous Data Warehouse 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.