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."It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time."
"The most valuable features are the performance and usability."
"Tools like the BI and SAS are excellent."
"The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"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."
"I am very satisfied with the customer service/technical support."
"We primarily use it for OLTP, which has improved our costs."
"The most valuable features of the solution revolve around its performance, simplicity, and its installation phase."
"The Oracle database is able to get the data, process it, and return it to the company's CEO's and CFO's within a single day, and thus they are able to find out yesterday's P and L by today. It has drastically reduced the amount and time of processing from seven days to one day."
"The solution is simple to use and easy to maintain."
"The product is good value for money. It is a secure solution."
"Oracle is a stable database."
"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’s valuable feature is its capability to pre-configure and pre-install the settings."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"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 has improved my organization's functionality and performance."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"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."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"I think that the error messages need to be made more specific."
"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."
"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."
"I would like to see better visualization features."
"The query is slow if we don't optimize it."
"It could be made more user-friendly for business users which would increase the user base."
"More tools to help designers should be included."
"Oracle Database Appliance could improve by having better integration."
"Sometimes, we cannot upgrade or patch it easily. The performance needs to improve."
"The product's technical support services need improvement."
"It would be beneficial to have dedicated RAM included in the Oracle Database Appliance."
"Oracle's product support is an area of concern where improvements are required."
"The feature that I would like to see improve is the interface. It is really not good. I almost have to work on script by script in it. There is always some issue with the user interface."
"Oracle Database Appliance patching comes out two to three months after the regular patching cycle."
"I would be happy to see the Oracle Auto Service Request (ASR) pre-installed in it instead of installing it in a separate machine."
"It needs integration with multiple clouds."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"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."
"Documentation has become much better, but can always use some improvement."
"The integration of this solution with ODI could be improved."
"It would be great if this were a managed service in AWS."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →