Microsoft Parallel Data Warehouse vs Teradata comparison

Microsoft Parallel Data War...

Read 74 Teradata reviews

5,484 Views
4,269 Comparison Views

86% willing to recommend

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Oct 6, 2024

Microsoft Parallel Data Warehouse and Teradata offer comprehensive data warehousing solutions. Teradata is favored for its advanced features and performance, despite being more expensive, while Microsoft Parallel Data Warehouse is valued for its competitive pricing and strong support.

Features: Microsoft Parallel Data Warehouse is known for its scalability, seamless integration with Microsoft products, and robustness. Teradata is recognized for advanced analytics capabilities, flexibility in handling diverse data types, and suitability for complex analytical tasks.

Room for Improvement: Microsoft could improve its speed, expand analytical features, and enhance user interface intuitiveness. Teradata users highlight learning complexity, the need for system simplification, and a streamlined onboarding process.

Ease of Deployment and Customer Service: Microsoft Parallel Data Warehouse offers straightforward deployment and prompt customer service. Teradata provides a rich set of deployment tools requiring expertise, making it challenging for users without adequate support.

Pricing and ROI: Microsoft Parallel Data Warehouse is considered cost-effective with quicker ROI due to lower setup costs. Teradata's higher initial investment is justified by its extensive capabilities and significant long-term ROI as experienced by users.

To learn more, read our detailed Microsoft Parallel Data Warehouse vs. Teradata Report (Updated: October 2024).

Microsoft Parallel Data Warehouse vs. Teradata

October 2024

Download the complete report

Helped 813,418 peers since 2012

Categories and Ranking

Microsoft Parallel Data War...

Ranking in Data Warehouse

10th

Average Rating

7.8

Number of Reviews

Ranking in other categories

No ranking in other categories

Teradata

Ranking in Data Warehouse

3rd

Average Rating

8.2

Number of Reviews

Ranking in other categories

Customer Experience Management (3rd), Backup and Recovery (20th), Data Integration (17th), Relational Databases Tools (7th), BI (Business Intelligence) Tools (10th), Marketing Management (6th), Cloud Data Warehouse (6th)

Mindshare comparison

As of October 2024, in the Data Warehouse category, the mindshare of Microsoft Parallel Data Warehouse is 1.1%, down from 1.3% compared to the previous year. The mindshare of Teradata is 16.8%, up from 15.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Warehouse

Q&A Highlights

it_user104457

Consultant at a comms service provider with 51-200 employees

Apr 13, 2014

Infobright vs. Exadata vs. Teradata vs. SQL Server Data Warehouse- which is most compatible with front end tools?

I think hands down it's Exadata since for the front end apps it's just another Oracle database which means everything under the sun is compatible with it.

Strong scalable solution with streamlined metadata warehousing

Featured Reviews

StevenLai

Sr. Data Engineer at Amrock

Sep 20, 2024

We use it to build our data warehouse and databases, and everything in the back end It helps streamline our metadata warehousing process. As it is our only type of data warehouse and database, it serves as our source, destination, and staging area. This product has many features which are useful…

Read full review

SurjitChoudhury

Data engineer at Cocos pt

Feb 20, 2024

Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities

We created and constructed the warehouse. We used multiple loading processes like MultiLoad, FastLoad, and Teradata Pump. But those are loading processes, and Teradata is a powerful tool because if we consider older technologies, its architecture with nodes, virtual processes, and nodes is a unique concept. Later, other technologies like Informatica also adopted the concept of nodes from Informatica PowerCenter version 7.x. Previously, it was a client-server architecture, but later, it changed to the nodes concept. Like, we can have the database available 24/7, 365 days. If one node fails, other nodes can take care of it. Informatica adopted all those concepts when it changed its architecture. Even Oracle databases have since adapted their architecture to them. However, this particular Teradata company initially started with its own different type of architecture, which major companies later adopted. It has grown now, but initially, whatever query we sent it would be mapped into a particular component. After that, it goes to the virtual processor and down to the disk, where the actual physical data is loaded. So, in between, there's a map, which acts like a data dictionary. It also holds information about each piece of data, where it's loaded, and on which particular virtual processor or node the data resides. Because Teradata comes with a four-node architecture, or however many nodes we choose, the cost is determined by that initially. So, what type of data does each and every node hold? It's a shared-no architecture. So, whatever task is given to a virtual processor it will be processed. If there's a failure, then it will be taken care of by another virtual processor. Moreover, this solution has impacted the query time and data performance. In Teradata, there's a lot of joining, partitioning, and indexing of records. There are primary and secondary indexes, hash indexing, and other indexing processes. To improve query performance, we first analyze the query and tune it. If a join needs a secondary index, which plays a major role in filtering records, we might reconstruct that particular table with the secondary index. This tuning involves partitioning and indexing. We use these tools and technologies to fine-tune performance. When it comes to integration, tools like Informatica seamlessly connect with Teradata. We ensure the Teradata database is configured correctly in Informatica, including the proper hostname and properties for the load process. We didn't find any major complexity or issues with integration. But, these technologies are quite old now. With newer big data technologies, we've worked with a four-layer architecture, pulling data from Hadoop Lake to Teradata. We configure Teradata with the appropriate hostname and credentials, and use BTEQ queries to load data. Previously, we converted the data warehouse to a CLD model as per Teradata's standardized procedures, moving from an ETL to an EMT process. This allowed us to perform gap analysis on missing entities based on the model and retrieve them from the source system again. We found Teradata integration straightforward and compatible with other tools.

Read full review

Quotes from Members

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

Pros

"It is a very stable database."

"It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time."

"The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."

"The most valuable feature for me is querying."

"The solution's integration is good."

"One of the most important features is the ease of using MS SQL."

"The data transmissions between the data models is the most valuable feature."

"I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets."

More Microsoft Parallel Data Warehouse pros

"Teradata's pretty fast."

"It is quick, secure, and has less hassles because we don't have to involve our networking team, infrastructure, etc. It is very easy to deploy and make market ready."

"It effectively has allowed us to remove over 20 portion copies of the data sets on other DB platforms for real-time operational reporting purposes."

"Building a data warehouse with Teradata has definitely helped a lot of our downstream applications to more easily access information."

"The key advantages are Performance when processing Terabytes of data and scalability."

"The initial setup was straightforward."

"Auto-partitioning and indexing, and resource allocation on the fly are key features."

"The tool's most valuable feature is the warehousing model."

More Teradata pros

Cons

"I would like the tool to support different operating systems."

"The only issue with the product is that the process is very slow when we have a huge amount of data."

"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 ability to do more real-time type updates instead of batch-oriented updates."

"A major issue is with table statistics. Sometimes the statistics are not refreshed correctly, which causes issues for us."

"Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution."

"The query is slow if we don't optimize it."

More Microsoft Parallel Data Warehouse cons

"There is a need to improve performance in high transaction processes, as well as the reporting system."

"The initial setup is complex because there are a lot of factors that come into play, including the amount of software and applications that require access."

"They should add more connectors to different platforms."

"It could be a bit more user-friendly."

"The setup is not straightforward."

"Teradata could improve by being less complicated. There are some aspects that are not available on the Unix server and a Unix system is required to access some data, such as in case of an emergency."

"The primary challenge with Teradata lies in its cost structure, encompassing subscription fees, software licenses, and hardware expenses."

"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."

More Teradata cons

Pricing and Cost Advice

"Technical support is an additional fee and is expensive."

"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."

"The solution is cost-effective."

"They offer an annual subscription. The pricing depends on the size of the environments."

"The tool could be expensive if we need to manage a lot of data."

"All the features that we use do not require any additional subscription or yearly fees."

"The solution's pricing is fairly decent for organizations with huge data sizes."

"I think the program is well-priced compared to the other offerings that are out in the market."

"I am using the free version of Teradata."

"I rate the product price a nine on a scale of one to ten, where one is cheap and ten is expensive."

"Teradata used to be expensive, but they have been lowering their prices."

"In the past, it turned out that other solutions, in order to provide the full range of abilities that the Teradata platform provides plus the migration costs, would end up costing more than Teradata does."

"The initial cost may seem high, but the TCO is low."

"In this day and age, we want to get things done quickly. So, we go to the AWS Marketplace."

"When looking into implementing this product, pricing is the main issue followed by technical expertise."

"The price of Teradata is on the higher side, and I think that it where they lose out on some of their business."

More Teradata pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.

See recommendations

813,418 professionals have used our research since 2012.

Comparison Review

it_user232068

Senior Data Architect at a pharma/biotech company with 1,001-5,000 employees

Aug 5, 2015

Netezza vs. Teradata

Original published at https://www.linkedin.com/pulse/should-i-choose-net Two leading Massively Parallel Processing (MPP) architectures for Data Warehousing (DW) are IBM PureData System for Analytics (formerly Netezza) and Teradata. I thought talking about the similarities and differences…

Read full review

Answers from the Community

it_user104457

Consultant at a comms service provider with 51-200 employees

Apr 13, 2014

Infobright vs. Exadata vs. Teradata vs. SQL Server Data Warehouse- which is most compatible with front end tools?

I think hands down it's Exadata since for the front end apps it's just another Oracle database which means everything under the sun is compatible with it.

2 out of 3 answers

it_user89046

Sales at Information Builders

Apr 10, 2014

Given we partner with many or all of the above, or can get to them as we access all data, I have the following opinion - InfoBright is very new and probable to be sold long term. It is also an expensive subscription so presents highest risk to me. Exidata is Oracle - if you like Oracle and their style, it maybe ok, but then it is Oracle. Microsoft is Microsoft - tends to be cheap to acquire and expensive to implement and maintain. Teradata is pricey but of the group presents the least risk and the greatest number of front end partners. The product I represent is unique as it is designed for high complexity large numbers of users and data and runs inside Teradata taking better advantage of the architecture. Disclosure: I work for Information Builders

Read full answer

it_user3309

Presenter at a consultancy

Apr 10, 2014

You are asking about front end tools but you do not mention which ones. What you have are "database backends" and each has different features. The utilization will depend on what kind of expertise you have available else you will end up trying to implement say, Teradata on Exadata which may not give you the best solution. What are your criteria for success? Based on these you will have to evaluate each solution -- I am sure each vendor will be happy to set up the environment and work with your set of sampl,e data to show you have they evaluate against your criteria.

Read full answer

See all 3 answers

Top Industries

By visitors reading reviews

Computer Software Company

27%

Financial Services Firm

18%

Insurance Company

Government

Financial Services Firm

25%

Computer Software Company

11%

Manufacturing Company

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about Microsoft Parallel Data Warehouse?

Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time.

What is your experience regarding pricing and costs for Microsoft Parallel Data Warehouse?

I am not very sure about the pricing or licensing.

What needs improvement with Microsoft Parallel Data Warehouse?

There are many areas for improvement. A major issue is with table statistics. Sometimes the statistics are not refreshed correctly, which causes issues for us. When we update a table, it should tri...

Comparing Teradata and Oracle Database, which product do you think is better and why?

I have spoken to my colleagues about this comparison and in our collective opinion, the reason why some people may declare Teradata better than Oracle is the pricing. Both solutions are quite simi...

Which companies use Teradata and who is it most suitable for?

Before my organization implemented this solution, we researched which big brands were using Teradata, so we knew if it would be compatible with our field. According to the product's site, the comp...

Is Teradata a difficult solution to work with?

Teradata is not a difficult product to work with, especially since they offer you technical support at all levels if you just ask. There are some features that may cause difficulties - for example,...

Microsoft Azure Synapse Analytics vs Microsoft Parallel Data Warehouse

Comparisons

Compared 36% of the time

Oracle Exadata vs Microsoft Parallel Data Warehouse

Compared 21% of the time

SAP BW4HANA vs Microsoft Parallel Data Warehouse

Compared 21% of the time

More Microsoft Parallel Data Warehouse Competitors

SQL Server vs Teradata

Compared 14% of the time

Oracle Exadata vs Teradata

Compared 13% of the time

Snowflake vs Teradata

Compared 9% of the time

MySQL vs Teradata

Compared 8% of the time

Vertica vs Teradata

Compared 5% of the time

More Teradata Competitors

Product Reports

Microsoft Parallel Data Warehouse

October 2024

Microsoft Parallel Data Warehouse report

Download Microsoft Parallel Data Warehouse product report

Download Teradata product report

September 2024

Also Known As

Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse

IntelliFlex, Aster Data Map Reduce, , QueryGrid, Customer Interaction Manager, Digital Marketing Center, Data Mover, Data Stream Architecture

Learn More

Microsoft

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 is a scalable data analytics platform designed to meet enterprise demands for large-scale data management and processing, focusing on performance, scalability, and security for complex query executions.

As a leading data warehousing solution, Teradata integrates advanced analytics enabling organizations to derive insights from massive datasets. It supports high-volume data workloads with its architecture optimized for analytical queries. Users benefit from its robust scalability, allowing seamless expansion as data grows. Teradata's SQL engine is compatible with a wide range of data types, ensuring flexibility in data analysis. With advanced security measures, it protects sensitive data across various environments, providing peace of mind to users handling critical information.

What are the most important features of Teradata?

Linear Scalability: Easily expands data processing capabilities to handle increasing data loads without performance degradation.
Advanced Analytics: Supports complex analytical operations integrating machine learning and AI for predictive insights.
SQL Compatibility: Offers a comprehensive SQL interface that supports complex queries across diverse data types.
Data Security: Implements rigorous security protocols to protect data integrity and confidentiality.

What benefits and ROI should users look for?

Improved Decision-Making: Derive actionable insights quickly for strategic business decisions.
Cost Efficiency: Optimized resource usage reduces operational costs associated with data processing.
Increased Productivity: Streamlined data operations save time, allowing teams to focus on analysis.
Enhanced Scalability: Seamless growth without significant additional investment as data volumes increase.

Teradata is widely used in industries like finance, telecommunications, and healthcare, where data-driven decisions are critical. Companies leverage its robust analytics capabilities to enhance customer experiences, streamline operations, and ensure compliance with regulatory requirements. In these sectors, quick access to data insights can significantly impact competitive advantage.

Sample Customers

Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe

Netflix