We performed a comparison between SAP IQ and Snowflake based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Columnar storage allows high compression, high load rates and high query performance."
"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."
"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."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"It's ultra-fast at handling queries, which is what we find very convenient."
"The adaptation to development languages is most valuable. Our developers can SQL code or something else. It has been convenient in that regard."
"As long as you don't need to worry about the storage or cost, this solution would be one of the best ones on the market for scalability purposes."
"I like the fact that we don't need a DBA. It automatically scales stuff."
"We find the data sharing and data marketplace aspects of Snowflake absolutely amazing."
"My company wanted to have all our data in one single place and this what we use Snowflake for. Snowflake also allows us to build connectors to different data sources."
"Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert."
"The solution is stable."
"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 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 room for improvement would be the marketing of the product, because this product is much better than advertised."
"They don't have any SLAs in place. It would be better if they did."
"The complexity of the initial setup of Snowflake depends on the use case. However, Snowflake itself, we don't set it up. The difficulty comes from the ingestion patterns, depending on what data I'm putting in, what kind of enrichment, and what additional value we have to add. However, it does tend to get complex because we have a lot of semi-structured data which we need to handle in Snowflake. There have been some challenges."
"The solution could use a little bit more UI."
"The solution could improve the user interface and add functionality to the system."
"We would like to be able to do modeling with Snowflake. It should support statistical modeling."
"There is a need for improvements in the documentation, this would allow more people to switch over to this solution."
"It's not that flexible when compared to Oracle."
"It's difficult to know how to size everything correctly."
SAP IQ is ranked 16th in Data Warehouse with 17 reviews while Snowflake is ranked 1st in Data Warehouse with 92 reviews. SAP IQ is rated 8.0, while Snowflake is rated 8.4. The top reviewer of SAP IQ writes "Easy to use, highly stable, but integration could improve". On the other hand, the top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". SAP IQ is most compared with SAP HANA, SQL Server, SAP BW4HANA, Apache Hadoop and SAP Adaptive Server Enterprise, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and AWS Lake Formation. See our SAP IQ vs. Snowflake report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all 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.