We performed a comparison between Microsoft Azure Synapse Analytics and SAP IQ 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."The solution's best feature is its predictive analytics."
"The product works well with other Azure products."
"Azure elasticity allows us to scale as much as we want, and it is pay-as-you-go, so we can scale up as we need to."
"The solution handles single or complex items within a second."
"Very interactive and provides flexibility."
"The most important feature for me is the integration with PolyBase."
"It's scalable; you can scale up and scale down."
"The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis."
"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."
"Columnar storage allows high compression, high load rates and high query performance."
"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."
"With respect to what needs to be improved, concurrent connectivity has some limitations."
"One area that could be improved is the schema management."
"It could be more stable."
"Microsoft Azure Synapse Analytics's overall integration within the Azure ecosystem could improve. The native Microsoft solution versus another solution, such as Databricks, there are areas where there could be some improvements."
"The initial setup has a bit of a learning curve."
"Integration with other vendors has limitations and could be improved."
"Synapse Analytics needs to develop an automation framework because now you have to build a cache yourself. You have to build a pipeline in WhereScape, which does end-to-end pipeline automation well. Microsoft should come up with a framework to save people time. If they developed a tool like WhereScape, it would dramatically reduce development time."
"It needs strong support for social media, internet data, and native support for NoSQL."
"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."
"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."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 85 reviews while SAP IQ is ranked 16th in Data Warehouse with 17 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while SAP IQ is rated 8.0. The top reviewer of Microsoft Azure Synapse Analytics writes "No competitors provide the entire solution to one place ". On the other hand, the top reviewer of SAP IQ writes "Easy to use, highly stable, but integration could improve". Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and Teradata, whereas SAP IQ is most compared with Snowflake, SAP HANA, SQL Server, SAP BW4HANA and Apache Hadoop. See our Microsoft Azure Synapse Analytics vs. SAP IQ 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.