We performed a comparison between BigQuery 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 initial setup process is easy."
"It stands out in efficiently handling internal actions without the need for manual intervention in tasks like building cubes and defining final dimensions."
"The product is serverless. We only need to write SQL queries to analyze the data. We need to pay based on the number of queries. The retrieval time is very less. Even if you write large queries, the tool is able to bring back data in a few seconds."
"When integrating their system into the cloud-based solutions, we were able to increase their efficiency and overall productivity twice compared with their on-premises option."
"It has a proprietary way of storing and accessing data in its own data store and is 100% managed without you needing to install anything. There is no need to arrange for any infrastructure to be able to use this solution."
"The query tool is scalable and allows for petabytes of data."
"The setup is simple."
"The most valuable features of this solution, in my opinion, are speed and performance, as well as cost-effectiveness."
"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."
"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."
"Columnar storage allows high compression, high load rates and high query performance."
"I would like to see version-based implementation and a fallback arrangement for data stored in BigQuery storage. These are some features I'm interested in."
"They could enhance the platform's user accessibility."
"It would be beneficial to integrate additional tools, particularly from a business intelligence perspective."
"I understand that Snowflake has made some improvements on its end to further reduce costs, so I believe BigQuery can catch up."
"I noticed recently it's more expensive now."
"There are some limitations in the query latency compared to what it was three years ago."
"The product’s performance could be much faster."
"We'd like to have more integrations with other technologies."
"I think the universe should be part of the Sybase IQ tool set."
"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 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."
"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."
BigQuery is ranked 5th in Cloud Data Warehouse with 31 reviews while SAP IQ is ranked 21st in Relational Databases Tools with 17 reviews. BigQuery is rated 8.2, while SAP IQ is rated 8.0. The top reviewer of BigQuery writes "Expandable and easy to set up but needs more local data residency". On the other hand, the top reviewer of SAP IQ writes "Easy to use, highly stable, but integration could improve". BigQuery is most compared with Snowflake, Teradata, Oracle Autonomous Data Warehouse, Vertica and Apache Hadoop, whereas SAP IQ is most compared with Snowflake, SAP HANA, SAP BW4HANA, SQL Server and Apache Hadoop. See our BigQuery 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.