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."The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"Self-patching and runs machine-learning across its logs all the time"
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"The product is easy to use."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"The analytics have been very good. We've found them to be quite useful."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"Unbeatable speed and compression with a colummn-structured relational database."
"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."
"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."
"Columnar storage allows high compression, high load rates and high query performance."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"They should make the solution more user-friendly."
"A lot of the tools that were previously there have now been taken away."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"I would like to see an on-premise solution in the future."
"The initial setup was pretty complex. It was not easy."
"My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on top of a JSON file with multiple array columns or superset columns, those column values create some difficulty in Oracle."
"One of the major problem is creating custom tablespace. The ADB serverless option doesn't support custom tablespace creation, which could cause issues during on-premise database migration that requires specifically named tablespace. There should be an option to create customized tablespace."
"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 organization who owns the product does not support it well and appears not to be doing significant development for the future."
"Concurrency and functional error messaging."
"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."
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, SQL Server, SAP BW4HANA 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.