Compare Microsoft Parallel Data Warehouse vs. Teradata

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Teradata and other solutions. Updated: September 2020.
437,557 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
Tools like the BI and SAS are excellent.It is not a pricey product compared to other data warehouse solutions.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.

More Microsoft Parallel Data Warehouse Pros »

It is a stable program.The most valuable features are the Shared-nothing architecture and data protection functionality.The feature that we find most valuable is its ability to perform Massive Parallel Processing.

More Teradata Pros »

Cons
We find the cost of the solution to be a little high.It could be made more user-friendly for business users which would increase the user base.They need to incorporate a machine learning engine.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.

More Microsoft Parallel Data Warehouse Cons »

An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly.The user interface needs to be improved.I would like to see an improved Knowledge Base on the web.

More Teradata Cons »

Pricing and Cost Advice
All the features that we use do not require any additional subscription or yearly fees.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 price needs to be more competitive as Hadoop, Redshift, Snowflake, etc are constantly making way into EDW space.

More Teradata Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
437,557 professionals have used our research since 2012.
Questions from the Community
Top Answer: 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… more »
Top Answer: 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… more »
Top Answer: The setup has room for improvement. Some customers want to go to non-Windows Servers. Have the entire SQL Server done there though is an obstacle for us, as the configuration of Microsoft BI with… more »
Top Answer: It is a stable program.
Top Answer: What really needs to improve, is their general cloud services. That is their biggest downfall at the moment.
Top Answer: We are only consultants, so we don't use the program ourselves.
Ranking
6th
out of 32 in Data Warehouse
Views
2,637
Comparisons
1,942
Reviews
11
Average Words per Review
486
Avg. Rating
7.6
5th
out of 32 in Data Warehouse
Views
21,843
Comparisons
16,237
Reviews
3
Average Words per Review
159
Avg. Rating
8.0
Popular Comparisons
Compared 18% of the time.
Compared 16% of the time.
Compared 12% of the time.
Compared 10% of the time.
Compared 6% of the time.
Also Known As
Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse
Learn
Microsoft
Teradata
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.

Teradata's portfolio of big data analytic solutions, integrated marketing applications, and services help organizations gain a sustainable competitive advantage with data.

Offer
Learn more about Microsoft Parallel Data Warehouse
Learn more about Teradata
Sample Customers
Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel EuropeNetflix
Top Industries
REVIEWERS
Computer Software Company27%
Comms Service Provider9%
Healthcare Company9%
Hospitality Company9%
VISITORS READING REVIEWS
Computer Software Company36%
Media Company9%
Wholesaler/Distributor7%
Financial Services Firm7%
REVIEWERS
Comms Service Provider38%
Energy/Utilities Company13%
Financial Services Firm13%
Logistics Company13%
VISITORS READING REVIEWS
Computer Software Company48%
Media Company9%
Comms Service Provider8%
Financial Services Firm5%
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Teradata and other solutions. Updated: September 2020.
437,557 professionals have used our research since 2012.
Microsoft Parallel Data Warehouse is ranked 6th in Data Warehouse with 11 reviews while Teradata is ranked 5th in Data Warehouse with 3 reviews. Microsoft Parallel Data Warehouse is rated 7.6, while Teradata 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 Teradata writes "It is stable but it should be more cloud-friendly and scalability is poor". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure SQL Data Warehouse, Oracle Exadata, Snowflake, VMware Tanzu Greenplum and IBM Netezza Performance Server, whereas Teradata is most compared with SQL Server, Oracle Exadata, Snowflake, Amazon Redshift and Oracle Database. See our Microsoft Parallel Data Warehouse vs. Teradata 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.