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."
"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."
"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."
"Scaling is a big plus point of Snowflake."
"It requires no maintenance on our part. They handle all that. The speed is phenomenal. The pricing isn't really anything more than what you would be paying for a SQL server license or another tool to execute the same thing. We have zero maintenance on our side to do anything and the speed at which it performs queries and loads the data is amazing. It handles unstructured data extremely well, too. So, if the data is in a JSON array or an XML, it handles that super well."
"The ability to share the data and the ability to scale up and down easily are the most valuable features. The concept of data sharing and data plumbing made it very easy to provide and share data. The ability to refresh your Dev or QA just by doing a clone is also valuable. It has the dynamic scale up and scale down feature. Development and deployment are much easier as compared to other platforms where you have to go through a lot of stuff. With a tool like DBT, you can do modeling and transformation within a single tool and deploy to Snowflake. It provides continuous deployment and continuous integration abilities. There is a separation of storage and compute, so you only get charged for your usage. You only pay for what you use. When we share the data downstream with business partners, we can specifically create compute for them, and we can charge back the business."
"The tool is very easy to use. The solution’s desktop features are also very easy to use. Also, the product’s SQL-based connectivity is also good. It can connect with any tool."
"Snowflake is an enormously useful platform. The Snowpipe feature is valuable because it allows us to load terabytes and petabytes of data into the data mart at a very low cost."
"I like the fact that we don't need a DBA. It automatically scales stuff."
"This solution has helped our organization by being easy to maintain and having good technical support."
"From a data warehouse perspective, it's an excellent all-round solution. It's very complete."
"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."
"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."
"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."
"I think the universe should be part of the Sybase IQ tool set."
"Product activation queries can't be changed while executing."
"Their UiPath, the workspace area, needs some work."
"Its stability could be better."
"The solution could use a little bit more UI."
"The product's performance could be improved."
"The cost is a bit high."
"If we can have a feature where the results can be moved to different tabs, so that I can compare the results with earlier queries before applying the changes, it would be great."
"The design of the product is easily misunderstood."
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, SAP BW4HANA, SQL Server, 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.