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 is not a pricey product compared to other data warehouse solutions."
"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 has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time."
"The most valuable feature is the business intelligence (BI) part of it."
"Data collection and reporting are valuable features of the solution."
"It is a stable solution...It is a scalable solution."
"The solution's integration is good."
"I am very satisfied with the customer service/technical support."
"The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security."
"It's very mature from a technology perspective."
"Teradata's capabilities enhance data management efficiency, support scalability, and contribute to faster query performance."
"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."
"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."
"Improved performance of ETL procedures, reporting."
"It has given our business the ability to gain insights into the data and create data labs for analysis and PoCs."
"It is a stable program."
"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."
"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. "
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"It has improved my organization's functionality and performance."
"In the future I would love to see a slightly better automation engine, just for the data integration layer, to make it slightly easier for end-users or junior developers to get involved in incremental updating."
"The product does not have all of the features that the native products have."
"SQL installation is pretty tricky. The scalability and customer support also should be improved."
"They need to incorporate a machine learning engine."
"Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution."
"The solution is expensive and has room for improvement."
"It could offer more development across the solution."
"It needs more compatibility with common BI tools."
"The current operational approach needs improvement."
"The SQL Assistant is very basic. This tool can be improved for usability."
"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."
"The user interface needs to be improved."
"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 needs to pay attention to the cloud-based solution to make sure it runs smoothly."
"The solution needs improvement in its stability, support and pricing."
"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."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"The geospatial functionality could be designed better."
"Documentation has become much better, but can always use some improvement."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"We faced some challenges when trying to use the temporary tables feature."
"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."
"It would be great if this were a managed service in AWS."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →