We performed a comparison between Microsoft Parallel Data Warehouse and Teradata based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It performs very well overall."
"We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."
"It is not a pricey product compared to other data warehouse solutions."
"It is a very stable database."
"The most valuable feature for me is querying."
"Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products."
"We can store the data in a data lake for a very low cost."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"Teradata has good performance, the response times are very fast. Overall the solution is easy to use. When we do the transformation, we have all of our staging and aggregation data available."
"I like this solution's ease of design and the fact that its performance is quite good. It is stable as well."
"It's very mature from a technology perspective."
"It has massive parallel processing ability to do large amounts of concurrent querying."
"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."
"The ability to handle machine data parallel processing is the most valuable feature of Teradata."
"It handles large amounts of information with a linear performance increase, in relation to a HW investment."
"It is a stable program."
"If the database is large with a lot of columns then it is difficult to clean the data."
"I would like to see better visualization features."
"The solution is expensive and has room for improvement."
"Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced."
"More tools to help designers should be included."
"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 think that the error messages need to be made more specific."
"Limited interest and success in some areas make us hesitate about upgrading."
"Teradata needs to expand the kind of training that's available to customers. Teradata only offers training directly and doesn't delegate to any third-party companies. As a result, it's harder to find people trained on Teradata in our market relative to Oracle."
"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."
"Teradata hardly supports unstructured data or semi-structured data"
"It needs a teaching web site with more training on third-party tools used for BI."
"The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."
"The scalability could be better. The on-premises solution is always more complicated to scale."
"Needs compatibility with more Big Data platforms."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →
Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 32 reviews while Teradata is ranked 3rd in Data Warehouse with 54 reviews. Microsoft Parallel Data Warehouse is rated 7.6, while Teradata is rated 8.2. The top reviewer of Microsoft Parallel Data Warehouse writes "An easy to setup tool that allows its users to write stored procedure, making it a scalable product". On the other hand, the top reviewer of Teradata writes "Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA, VMware Tanzu Greenplum and Snowflake, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and BigQuery. See our Microsoft Parallel Data Warehouse vs. Teradata report.
See our list of best 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.
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.
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