We performed a comparison between Microsoft Parallel Data Warehouse, Teradata, and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."It handles high volumes of data very well."
"Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products."
"It is a stable solution...It is a scalable solution."
"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."
"Tools like the BI and SAS are excellent."
"The most valuable features are the performance and usability."
"It is a very stable database."
"It has massive parallel processing ability to do large amounts of concurrent querying."
"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."
"I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable."
"It's the same as your visual database. I like the fast load feature for data, the BTQ solution is very good, and storage procedures are very fast."
"Teradata's pretty fast."
"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."
"A conventional and easily defined way to build a data warehouse or a layer of data marts."
"Teradata's most valuable feature is that it's easy to use."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"Speed and resiliency are probably the best parts of this product."
"The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money."
"It has improved my organization's functionality and performance."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"The extensibility and efficiency provided by their C++ SDK."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"This solution would be improved with an option for in-memory data analysis."
"The feature updates on the on-premise solution come very slowly, and it would be great if they came faster."
"The query is slow if we don't optimize it."
"The only issue with the product is that the process is very slow when we have a huge amount of data."
"It needs more compatibility with common BI tools."
"It could offer more development across the solution."
"The product does not have all of the features that the native products have."
"I would like the ability to do more real-time type updates instead of batch-oriented updates."
"I would like to see more integration with many different types of data."
"Teradata hardly supports unstructured data or semi-structured data"
"Teradata is an old data warehouse, and they're not improving in terms of new, innovative features."
"We tried to use case Teradata for a data warehouse system, but we had some problems in relation to the Teradata system, CDC tools, and source databases. We were unable to transfer data from HPE Integrity mainframe to Teradata."
"I would like to see an improved Knowledge Base on the web."
"The solution could improve by having a cloud version or a cloud component. We have to use other solutions, such as Amazon AWS, Microsoft Azure, or Snowflake for the cloud."
"The setup is not straightforward."
"Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"When it is about to reach the maximum storage capacity, it becomes slow."
"Limitations in group by projections is where I would like to see an improvement."
"We faced some challenges when trying to use the temporary tables feature."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
"The geospatial functionality could be designed better."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"It needs integration with multiple clouds."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →