We performed a comparison between IBM Db2 Warehouse and SAP Business Warehouse based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Provides good security and reliability."
"The analytics engine is not bad at forecasting predictions."
"Some of the best features are stored procedures, parallelism, and different indexing strategies."
"The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data."
"I think it scales really well and as long as you take enough time to learn a little bit about it, it works really well."
"It can be mounted on the cloud, which is a huge plus. If the client, for example, starts small with on-premise deployment and then it rapidly needs to grow, we can transfer this to the cloud easily."
"The warehouse is the solution's most valuable feature."
"The most useful feature has been he ability to feed data into multiple systems in various formats."
"The key element in this solution is its rapid response. If you have a question about prices, buyers, customers, providers, or services, you need the answer in a minute or two. That's the key benefit for us that a solution like BW gives us."
"Predominantly, our company uses SAP Business Warehouse for reporting purposes across various departments, especially for managers to gain a quick understanding of their current standing and make informed decisions."
"Having the back-end data set with the right information is the best qualification for this 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 valuable feature of this solution is the advanced structuring of data capabilities. You can get different structures of data to suit your needs."
"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."
"IBM Db2 Warehouse needs to improve its interface."
"Lacks sufficient documentation and particularly in Spanish."
"The biggest challenge anyone could have with Db2 Warehouse is their references or online resources and documentation. They are very, very, very limited on the web."
"In terms of improvement, IBM Db2 Warehouse should be more scalable."
"The biggest problems we have is when the backup solution is failing or slow and we run out of log space, which has happened probably a couple of times in the last four years."
"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."
"There should be more material available for training and training should be free."
"I get all the information quickly, but it is one day old."
"The advanced structuring can be complicated and the interface is not very intuitive."
"We are very unhappy with technical support. First of all, they send their sales agents or pre-sales agents and most of them who don't know the solution as a properly trained tech would. We have an on-site SAP representative who is supposed to help us with our high priority and production issues, and they're not satisfactory to say the least."
"SAP Business Warehouse could integrate better with other ETL tools."
"The problem with BW, and the factor that differentiated it from the original BW, is that you only get limited functionality with your runtime license. So, you have to pay extra for extracting data."
"More integration with Microsoft Office products (not just Excel) would be helpful."
"So far, the initial setup process in our company has not been easy enough for us to understand."
"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."
IBM Db2 Warehouse is ranked 14th in Data Warehouse with 8 reviews while SAP Business Warehouse is ranked 8th in Cloud Data Warehouse with 25 reviews. IBM Db2 Warehouse is rated 7.6, while SAP Business Warehouse is rated 7.8. The top reviewer of IBM Db2 Warehouse writes "Useful for ETL process and has good documentation ". On the other hand, the top reviewer of SAP Business Warehouse writes "Offers powerful analytics and integration capabilities but requires improved upgrade processes". IBM Db2 Warehouse is most compared with Oracle Exadata, Snowflake, Amazon Redshift, Apache Hadoop and IBM Db2 Warehouse on Cloud, whereas SAP Business Warehouse is most compared with Microsoft Azure Synapse Analytics, Snowflake, BigQuery, SAP BW4HANA and Amazon Redshift. See our IBM Db2 Warehouse vs. SAP Business Warehouse report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all 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.