We performed a comparison between SAP IQ and Snowflake Analytics 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 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."
"Columnar storage allows high compression, high load rates and high query performance."
"Unbeatable speed and compression with a colummn-structured relational database."
"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."
"The computational power of Snowflake is very good."
"Scalability-wise, I rate the solution a ten out of ten."
"The performance has been good."
"Very good flexibility and it offers computation completely decoupled from the storage."
"It can run complex workloads with varied compute."
"Deployment is straightforward as it's a SaaS product. No maintenance required."
"The Snowflake features I find most beneficial for data analysis are primarily related to analytics, particularly their features like materialized views and queues, which are especially useful for dashboarding purposes."
"One of the valuable features is the solution’s time travel capability. The solution is highly stable. The solution is highly scalable. The initial setup is straightforward, and the deployment process is quick and efficient. I recommend the solution. Overall, I rate it a perfect ten."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"I think the universe should be part of the Sybase IQ tool set."
"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 solution needs to consider including some updates in the future."
"One area that could benefit from enhancement is the user interface for more visual ESM features."
"The UI could be more user-friendly."
"Machine learning should be improved."
"Machine learning in Snowflake isn't as advanced as in other products. I haven't heard of any successful industry-wide use cases of machine learning implemented in Snowflake. It might take a couple of years to reach the same level as Databricks."
"We haven't seen any areas that are lacking."
"The scheduling of jobs requires improvement, particularly in terms of the user interface which currently lacks certain features found in comparable platforms."
"End-to-end execution of jobs isn't possible with Snowflake, which means we have to do some customization."
SAP IQ is ranked 21st in Relational Databases Tools with 17 reviews while Snowflake Analytics is ranked 7th in Cloud Data Warehouse with 28 reviews. SAP IQ is rated 8.0, while Snowflake Analytics 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 Analytics writes "A scalable tool useful for data lake and data mining processes". SAP IQ is most compared with Snowflake, SAP HANA, SQL Server, SAP BW4HANA and Apache Hadoop, whereas Snowflake Analytics is most compared with Azure Data Factory, Adobe Analytics, Mixpanel, Amplitude and Glassbox. See our SAP IQ vs. Snowflake Analytics 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.