We performed a comparison between Microsoft Parallel Data Warehouse, SAP NetWeaver Business Warehouse, 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."Tools like the BI and SAS are excellent."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."
"I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets."
"It is a very stable database."
"The solution's integration is good."
"It handles high volumes of data very well."
"It performs very well overall."
"It's an excellent over-all tool for managers to analyze their business."
"It provides us with proof of data, we can centralize all of the information, check it, and then provide the information to our users."
"The security and audit procedures are the most valuable features."
"Data modeling is a valuable feature."
"It is a robust system."
"A robust and efficient product."
"Transformation is a valuable feature of SAP NetWeaver. I can transform the data as per my needs or my client's needs. For example, flat tables can be transformed with respect to our requirements to combine multiple modules into one single table, and we can derive analytics."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI."
"The product's initial setup phase is extremely simple."
"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 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."
"The performance is very good and the aggregate records are fast."
"The most valuable feature is Vertica's performance and the ease of using the database."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"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 query is slow if we don't optimize it."
"The reporting for certain types of data needs to be improved."
"Some compatibility issues occur during deployment, so we need to build the product from scratch for some features."
"Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced."
"More tools to help designers should be included."
"The only issue with the product is that the process is very slow when we have a huge amount of data."
"This solution would be improved with an option for in-memory data analysis."
"I think more integration with other applications would be perfect."
"Connectors are complex, and it is difficult to understand or know which connector should be used. For instance, if I want to connect APIs, I will not be able to do it directly. I would have to go to the portal integration to get the data. Therefore, having simplified connectors will make things much easier."
"The program is difficult to learn to use"
"The product could provide more features."
"There are performance issues in terms of scalability and availability."
"Design and modeling could be simplified."
"It is difficult when your native language is not English. It is difficult for us to explain our issue and also difficult for the technical team to explain a resolution to us."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
"We faced some challenges when trying to use the temporary tables feature."
"Suboptimal projection design causes queries to not scale linearly."
"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."
"Limitations in group by projections is where I would like to see an improvement."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"The integration of this solution with ODI could be improved."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →
More SAP NetWeaver Business Warehouse Pricing and Cost Advice →