Compare Microsoft Parallel Data Warehouse vs. SAP IQ

Microsoft Parallel Data Warehouse is ranked 7th in Data Warehouse with 9 reviews while SAP IQ is ranked 12th 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 SQL Data Warehouse, Oracle Exadata, Snowflake, VMware Tanzu Greenplum and Teradata, whereas SAP IQ is most compared with SAP Adaptive Server Enterprise, Apache Hadoop, SAP HANA, Oracle Database and SQL Server.
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: July 2020.
430,585 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
Collecting the data through SSIS packages from different sources and putting them all in one data repository is the most powerful thing. While others have this feature, they don't have the simplicity or ease of use when getting a resource and knowing everything about it.We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it.The most valuable feature is the business intelligence (BI) part of it.The data transmissions between the data models is the most valuable feature.The most valuable feature of this solution is performance.One of the most important features is the ease of using MS SQL.The most valuable feature for me is querying.The most valuable features are the performance and usability.

More Microsoft Parallel Data Warehouse Pros »

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

More SAP IQ Pros »

Cons
I would like the tool to support different operating systems.If the database is large with a lot of columns then it is difficult to clean the data.This solution would be improved with an option for in-memory data analysis.The reporting for certain types of data needs to be improved.I think that the error messages need to be made more specific.I would like to see better visualization features.More tools to help designers should be included.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 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
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.I think the program is well-priced compared to the other offerings that are out in the market.

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.
430,585 professionals have used our research since 2012.
Ranking
7th
out of 32 in Data Warehouse
Views
2,634
Comparisons
1,930
Reviews
9
Average Words per Review
463
Avg. Rating
7.7
12th
out of 32 in Data Warehouse
Views
3,152
Comparisons
2,174
Reviews
1
Average Words per Review
1,235
Avg. Rating
8.0
Popular Comparisons
Compared 20% of the time.
Compared 14% of the time.
Compared 10% of the time.
Compared 7% of the time.
Also Known As
Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data WarehouseSybase IQ
Learn
Microsoft
SAP
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 EuropeASR Group, Citrix, State of Indiana, PocketCard Co. Ltd.
Top Industries
REVIEWERS
Computer Software Company30%
Comms Service Provider10%
Healthcare Company10%
Hospitality Company10%
VISITORS READING REVIEWS
Computer Software Company34%
Financial Services Firm8%
Comms Service Provider7%
Media Company7%
REVIEWERS
Financial Services Firm67%
Healthcare Company11%
Insurance Company11%
Marketing Services Firm11%
VISITORS READING REVIEWS
Computer Software Company50%
Comms Service Provider16%
Government8%
Energy/Utilities Company5%
Find out what your peers are saying about Snowflake Computing, Oracle, Apache and others in Data Warehouse. Updated: July 2020.
430,585 professionals have used our research since 2012.

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.