We performed a comparison between Microsoft Parallel Data Warehouse, Teradata, and TIBCO Live Datamart based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."It is a very stable database."
"I am very satisfied with the customer service/technical support."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"The solution has been reliable."
"We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."
"We can store the data in a data lake for a very low cost."
"The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."
"The data transmissions between the data models is the most valuable feature."
"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 flexibility in design is very good."
"It's very mature from a technology perspective."
"Things have started moving faster in my company, such as data retrieval happens more quickly."
"It has massive parallel processing ability to do large amounts of concurrent querying."
"The functionality of the solution is excellent."
"Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services."
"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."
"The solution has a powerful aggregating feature"
"You can create your own rules that include mathematic calculations."
"I would like to see better visualization features."
"SQL installation is pretty tricky. The scalability and customer support also should be improved."
"Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution."
"We find the cost of the solution to be a little high."
"I think that the error messages need to be made more specific."
"The product must provide more frequent updates."
"The feature updates on the on-premise solution come very slowly, and it would be great if they came faster."
"It could be made more user-friendly for business users which would increase the user base."
"Teradata is an expensive tool. Like, if you're already using Microsoft products like Windows, they'll market all their products together. And with the rise of cloud technologies, companies will adopt solutions that offer them some privileges or facilities. Similar to how SAP does it in the market, so do Microsoft and other companies. Even Oracle and other such tools are quite commonly seen compared to Teradata's competitors in everyday solutions."
"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."
"Teradata is an old data warehouse, and they're not improving in terms of new, innovative features."
"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)."
"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."
"I would like to see an improved Knowledge Base on the web."
"The following could be better: licensing, architecture openness, integration with other tools."
"The solution's setup could be quicker and easier."
"Improvements need to be made on the load balancing side."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →