Microsoft Parallel Data Warehouse vs SAP IQ

Microsoft Parallel Data Warehouse is ranked 11th in Data Warehouse with 3 reviews vs SAP IQ which is ranked 5th in Data Warehouse with 6 reviews. The top reviewer of Microsoft Parallel Data Warehouse writes "Gives us the ability to distribute large data sets across nodes". The top reviewer of SAP IQ writes "A column-based solution with the highest performance on query". Microsoft Parallel Data Warehouse is most compared with Oracle Exadata, Teradata and Netezza. SAP IQ is most compared with SQL Server, SAP ASE and Oracle Database. See our Microsoft Parallel Data Warehouse vs SAP IQ report.
Cancel
You must select at least 2 products to compare!
+Add products to compare
Most Helpful Review
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs SAP IQ and others in Data Warehouse.
287,566 professionals have used our research since 2012.

Quotes From Members Comparing Microsoft Parallel Data Warehouse vs SAP IQ

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
Pros
It handles high volumes of data very well.​It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time.​

Read more »

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.Valuable features for us include the compression, speed, fast response time, and easy object maintenance.Columnar storage allows high compression, high load rates and high query performance.

Read more »

Cons
It needs more compatibility with common BI tools.​Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution.

Read more »

The room for improvement would be the marketing of the product, because this product is much better than advertised.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.Concurrency and functional error messaging.

Read more »

Pricing and Cost Advice
Information Not Available
Negotiation is very important.Negotiate based on the features required.Evaluate all options; check to see if you need expensive add-ons.

Read more »

report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
287,566 professionals have used our research since 2012.
Ranking
RANKING
Views
5,395
Comparisons
3,195
Reviews
3
Followers
641
Avg. Rating
5.7
Views
9,884
Comparisons
6,243
Reviews
6
Followers
514
Avg. Rating
7.8
Top Comparisons
Top ComparisonsSee more Microsoft Parallel Data Warehouse competitors »
Compared 28% of the time.
Compared 20% of the time.
Compared 12% of the time.
See more SAP IQ competitors »
Also Known As
Also Known AsMicrosoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data WarehouseSybase IQ
Website/Video
Website/VideoMicrosoft
SAP
Overview
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.

Transform your business and enhance in-the-moment decision making with SAP IQ (formerly Sybase IQ). This columnar relational database management system (RDBMS) is highly optimized for Big Data analytics. Leverage SAP IQ's extreme scalability and robust security features for enterprise data warehouse (EDW) use cases - and get unprecedented insights in a data-intensive world.

OFFER
Learn more about Microsoft Parallel Data Warehouse
Learn more about SAP IQ
Sample Customers
Sample CustomersAuckland 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
Top Industries
VISITORS READING REVIEWS
Financial Services Firm
21%
Hospitality Company
10%
Comms Service Provider
9%
Insurance Company
8%
REVIEWERS
Financial Services Firm
75%
Marketing Services Firm
13%
Healthcare Company
13%
VISITORS READING REVIEWS
Financial Services Firm
43%
Energy/Utilities Company
19%
Marketing Services Firm
8%
Healthcare Company
6%
Company Size
Company Size
REVIEWERS
Small Business
38%
Midsize Enterprise
13%
Large Enterprise
50%
VISITORS READING REVIEWS
Small Business
11%
Midsize Enterprise
19%
Large Enterprise
70%
REVIEWERS
Small Business
20%
Midsize Enterprise
13%
Large Enterprise
67%
VISITORS READING REVIEWS
Small Business
14%
Midsize Enterprise
22%
Large Enterprise
64%
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs SAP IQ and others in Data Warehouse.
Download now
287,566 professionals have used our research since 2012.
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.

Sign Up with Email