Compare Microsoft Parallel Data Warehouse vs. SAP IQ

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Snowflake Computing, Oracle, Apache and others in Data Warehouse. Updated: June 2021.
511,607 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
"I am very satisfied with the customer service/technical support.""The most valuable features are the performance and usability.""The most valuable feature for me is querying.""One of the most important features is the ease of using MS SQL.""The most valuable feature of this solution is performance.""The data transmissions between the data models is the most valuable feature.""The most valuable feature is the business intelligence (BI) part of it.""We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."

More Microsoft Parallel Data Warehouse Pros »

"Unbeatable speed and compression with a colummn-structured relational database."

More SAP IQ Pros »

Cons
"In the future I would love to see a slightly better automation engine, just for the data integration layer, to make it slightly easier for end-users or junior developers to get involved in incremental updating.""More tools to help designers should be included.""I would like to see better visualization features.""I think that the error messages need to be made more specific.""The reporting for certain types of data needs to be improved.""This solution would be improved with an option for in-memory data analysis.""If the database is large with a lot of columns then it is difficult to clean the data.""I would like the tool to support different operating systems."

More Microsoft Parallel Data Warehouse Cons »

"The organization who owns the product does not support it well and appears not to be doing significant development for the future."

More SAP IQ Cons »

Pricing and Cost Advice
"I think the program is well-priced compared to the other offerings that are out in the market.""Microsoft has an agreement with the government in our country, so our customers get their licensing costs from the Ministry. Whenever we work with any government, company, or government institute, which is mainly what we are doing, that license comes directly from the Ministry of Technology and Information.""All the features that we use do not require any additional subscription or yearly fees."

More Microsoft Parallel Data Warehouse Pricing and Cost Advice »

"The only costs after standard licensing fees are for add-ons and upgrades."

More SAP IQ Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
511,607 professionals have used our research since 2012.
Questions from the Community
Top Answer: I'd like to connect something like ES that I can use on objects on our SQL Server. We'd like to be able to understand how to export data to something like Semantic Technologies or like Graph DB. Some… more »
Ask a question

Earn 20 points

Ranking
6th
out of 30 in Data Warehouse
Views
2,570
Comparisons
1,902
Reviews
11
Average Words per Review
486
Rating
7.6
11th
out of 30 in Data Warehouse
Views
2,237
Comparisons
1,551
Reviews
1
Average Words per Review
1,235
Rating
8.0
Popular Comparisons
Also Known As
Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse, MS Parallel Data Warehouse, MS Parallel Data Warehouse
Sybase IQ
Learn More
Overview

The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.

SAP® IQ software delivers speed and power for extreme-scale enterprise data warehousing and analytics. Its column-oriented, grid-based massively parallel processing (MPP) architecture and patented data compression and indexing technologies enable companies to exploit the value of huge amounts of data at the speed of business.

Offer
Learn more about Microsoft Parallel Data Warehouse
Learn more about SAP IQ
Sample Customers
Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe
ASR Group, Citrix, State of Indiana, PocketCard Co. Ltd.
Top Industries
REVIEWERS
Computer Software Company27%
Pharma/Biotech Company18%
Comms Service Provider9%
Hospitality Company9%
VISITORS READING REVIEWS
Computer Software Company24%
Comms Service Provider15%
Financial Services Firm10%
Insurance Company7%
REVIEWERS
Financial Services Firm67%
Marketing Services Firm11%
Healthcare Company11%
Insurance Company11%
VISITORS READING REVIEWS
Computer Software Company37%
Comms Service Provider13%
Financial Services Firm12%
Government6%
Company Size
REVIEWERS
Small Business32%
Midsize Enterprise18%
Large Enterprise50%
REVIEWERS
Small Business19%
Midsize Enterprise13%
Large Enterprise69%
Find out what your peers are saying about Snowflake Computing, Oracle, Apache and others in Data Warehouse. Updated: June 2021.
511,607 professionals have used our research since 2012.

Microsoft Parallel Data Warehouse is ranked 6th in Data Warehouse with 11 reviews while SAP IQ is ranked 11th in Data Warehouse with 1 review. Microsoft Parallel Data Warehouse is rated 7.6, while SAP IQ is rated 8.0. The top reviewer of Microsoft Parallel Data Warehouse writes "Collects data through SSIS packages from different sources and puts them all in one data repository". On the other hand, the top reviewer of SAP IQ writes "An excellent column-based, enterprise relational database solution with good speed and compression". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, Snowflake, SAP BW4HANA and Teradata, whereas SAP IQ is most compared with SAP Adaptive Server Enterprise, Apache Hadoop, SAP HANA, Oracle Database and SQL Server.

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.