We performed a comparison between SAP Business Warehouse and Vertica based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Out-of-the-box reports are very useful."
"The most valuable feature of SAP Business Warehouse is transformation, where I extract data from different sources, particularly the raw data. Then I do some transformations and store that in a format that allows me to do reporting easily."
"The most valuable aspect of the solution is the integration with SAP ERP."
"What I like most about SAP Business Warehouse is that it's a seamless integration platform. A valuable feature in the tool is the monitoring alert that makes you aware of what process chain has failed. There's no manual monitoring required if you have configured an alert system, so the process chain can run in the background, and you can get alerts about it. The functionalities I find good in SAP Business Warehouse are alerting and monitoring. If you have configured the tool and have integrated it with SAP Solution Manager, then it's a good product to use."
"In terms of stability, comparatively, the solution is quite stable."
"We are currently in a basic stage of analytics and the first goal we have is to make sure the numbers are correct. BW has some features that help you to build factors and ETL in such a way that it's easy to get to correct responses. That's the number one condition that you have to have in an analytic solution."
"The most valuable feature of SAP Business Warehouse is its hybrid functionality, allowing users to leverage both SQL-based data warehouse capabilities from HANA and feature-based data warehousing from BW."
"The most useful feature has been he ability to feed data into multiple systems in various formats."
"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 fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"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."
"The solution is quick, has good compression data, and is not expensive."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"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."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"What I'd like to improve in SAP Business Warehouse is its data structure, that's a little bit rigid. It could be a bit more flexible, so you can design your data structure and improve performance when creating a solution. Currently, the way data is stored in SAP Business Warehouse is rigid."
"It's a product that is at the end of life so they will not improve it anymore."
"Areas for improvement in SAP Business Warehouse include enhancing scheduling and monitoring tools, as well as improving communication about hidden features to make them more accessible to users."
"It takes more work to get the data, including reporting on that data, because some coding is required, and a significant level of transformation is needed when using SAP Business Warehouse."
"The way the data is stored is kind of rigid in SAP BW as a product. It could be more flexible so that when we are designing a solution, we can design our own data structures and try to improve performance."
"More integration with Microsoft Office products (not just Excel) would be helpful."
"The solution could offer better connectivity with other databases."
"I get all the information quickly, but it is one day old."
"It needs integration with multiple clouds."
"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."
"Support is an area where it could get better."
"I have found that coding support could be simplified."
"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."
"I believe the installation process could be streamlined."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
SAP Business Warehouse is ranked 8th in Cloud Data Warehouse with 25 reviews while Vertica is ranked 6th in Cloud Data Warehouse with 82 reviews. SAP Business Warehouse is rated 7.8, while Vertica is rated 8.4. The top reviewer of SAP Business Warehouse writes "Offers powerful analytics and integration capabilities but requires improved upgrade processes". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". SAP Business Warehouse is most compared with Microsoft Azure Synapse Analytics, Snowflake, BigQuery, SAP BW4HANA and Amazon Redshift, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata. See our SAP Business Warehouse vs. Vertica report.
See our list of best Cloud Data Warehouse vendors and best Data Warehouse vendors.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.