We performed a comparison between Microsoft Parallel Data Warehouse, Teradata, and Teradata Cloud Data Warehouse based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets."
"The data transmissions between the data models is the most valuable feature."
"We can store the data in a data lake for a very low cost."
"Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products."
"It is a very stable database."
"We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."
"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."
"It is not a pricey product compared to other data warehouse solutions."
"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."
"There are several features of Teradata that I like. One of the most basic is the indexes. I also like that it provides lower TCO. It also has the optimizer feature which is a good feature and isn't found in other legacy systems. Parallelism is also another feature I like in Teradata because when you are running or hosting on multiple systems, you have this shared-nothing architecture that helps. Loading and unloading in Teradata are also really helpful compared to other systems."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"I like this solution's ease of design and the fact that its performance is quite good. It is stable as well."
"Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services."
"I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable."
"It has reduced a lot of reworking on maintaining indexes, partitions, etc."
"Teradata can be deployed on-premise, on the cloud, or in a virtual machine, which means customers can move without having to create their architecture all over again."
"The product is reliable."
"The most valuable feature is the ease of running queries."
"The cloud is ten times better than physical hardware; it is more cost-effective and the upgrade process is ten times easier."
"We'd like to see it be a bit more compatible with other solutions."
"The feature updates on the on-premise solution come very slowly, and it would be great if they came faster."
"The only issue with the product is that the process is very slow when we have a huge amount of data."
"I would like the tool to support different operating systems."
"I would like to see better visualization features."
"Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution."
"SQL installation is pretty tricky. The scalability and customer support also should be improved."
"It needs more compatibility with common BI tools."
"There is some improvement required on OLTP level and some analytical function is missing."
"The increasing volumes of data demand more and more performance."
"Query language and its functionality are rather limited, compared to Oracle or even SQL Server. However, it is possible to perform any kind of logic in it (though some workarounds may be required)."
"GUI of administrative tools is really outdated."
"Teradata's UI could be improved."
"Teradata hardly supports unstructured data or semi-structured data"
"The SQL Assistant is very basic. This tool can be improved for usability."
"The user interface needs to be improved."
"The cost of Teradata Cloud Data Warehouse has room for improvement."
"Stability-wise, we have had some issues with automation and the ability to handle large datasets."
"It could be a bit more user-friendly."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →
More Teradata Cloud Data Warehouse Pricing and Cost Advice →