We performed a comparison between Microsoft Parallel Data Warehouse, Oracle Database Appliance, 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."The most valuable feature is the business intelligence (BI) part of it."
"The most valuable features are the performance and usability."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"The solution's integration is good."
"It is not a pricey product compared to other data warehouse solutions."
"The most valuable feature of this solution is performance."
"Data collection and reporting are valuable features of the solution."
"The data transmissions between the data models is the most valuable feature."
"Oracle Database Appliance is a stable solution. We have clients that have been running it for 10 years."
"The performance of the system is the solution's most valuable aspect. In combination with the database, it gives perfect results. It's a better system than using other kinds of integrated systems. In general, the ODA control is much simpler to use and offers up the best performance."
"The product is very light."
"We use the solution for our Java applications."
"Oracle Database Appliance provides high stability."
"The product is good value for money. It is a secure solution."
"The most valuable feature of Oracle Database Appliance is the ease of management."
"The solution is stable. The product is scalable. The technical support is very helpful. The initial setup is straightforward. I consider the product a strong solution for our customers."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"Its projections and encoding are excellent tools for tuning large volumes."
"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. "
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"The most valuable feature of Vertica is the unmatchable database performance."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage."
"SQL installation is pretty tricky. The scalability and customer support also should be improved."
"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 solution is expensive and has room for improvement."
"The reporting for certain types of data needs to be improved."
"I would like to see better visualization features."
"It could be made more user-friendly for business users which would increase the user base."
"Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced."
"It needs more compatibility with common BI tools."
"They could incorporate a more secure and internet-centric management system for the platform."
"I would rate the scalability a seven out of ten. It has some problems. Databases are huge. This leads to needing more and more RAM and capacity resources, making it hard to scale. Because of this, we use Exadata. That's definitely a point for improvement."
"The product is quite complex to set up, initially. It would be ideal if it was simpler."
"The solution's initial setup is not easy."
"Technical support is not so great. It could be much better. The maintenance, for an enterprise system, isn't so great. It's also extremely expensive."
"The main thing would be to make ODA more affordable, to make it a more economical machine. Also, I would like to see virtualization, so you could implement all of your functions on one machine. Finally, improvement in the speed and performance would be good."
"Since we don't have the room to scale up, I rate this solution a six out of ten for scalability."
"If we were able to use Oracle Database to create mobile apps, that would be great. I don't know multiple languages, like Java, etc. I need to learn a separate language, right now in order to do this."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"It should provide a GUI interface for data management and tuning."
"I believe the installation process could be streamlined."
"It needs integration with multiple clouds."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down."
"They could improve on customer service."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →