IBM Db2 Warehouse vs SAP Business Warehouse comparison

"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."

"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."

"Some of the best features are stored procedures, parallelism, and different indexing strategies."

"The solution is stable."

"The analytics engine is not bad at forecasting predictions."

"IBM Db2 Warehouse is more resilient when dealing with business intelligence applications."

"The most valuable features of IBM Db2 Warehouse include its availability, easy integration, ability to deal with a large size of data, excellent performance with no delays, powerful security mechanisms, and effective support."

"It can scale effectively as long as resources are available."

"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 product is very stable."

"The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."

"I like that it integrates to open-source."

"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."

"The warehouse is the solution's most valuable feature."

"Now, because of the HANA integration, the hard disk and RAM are together, and because of that, the output is very quick and very fast actually."

"The most valuable aspect of the solution is the integration with SAP ERP."

"It takes a long time to have a new version or release, similar to Oracle."

"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."

"IBM Db2 Warehouse needs to improve its interface."

"There should be more material available for training and training should be free."

"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."

"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 were some initial challenges with IBM Db2 Warehouse about eight months ago when I worked in this environment. When I coordinated with IBM support, they mentioned that the memory was insufficient for our needs. Our business environment required significantly more memory than the previous cluster could provide. Consequently, we have worked closely with on-site IBM technical personnel to address this issue."

"The primary challenges customers face with IBM Db2 Warehouse are related to its complexity in usage. It requires highly skilled professionals who understand Db2, and both training and support are challenging to obtain."

"I would like to see a different end solution in order to read the data and attract internal users."

"In the next release, my suggestion would be to have user-friendly interfaces and performance issues be addressed."

"The advanced structuring can be complicated and the interface is not very intuitive."

"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."

"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."

"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."

"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."

"The solution could offer better connectivity with other databases."

"In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."

"Overall, the pricing is not fixed and is expensive."

"It's moderately expensive, but definitely has its branding and price value for it."

"I would not recommend it to small-scale companies. The price is too much."

"The solution is quite expensive."

"It's quite pricey. SAP changed its pricing policy, so they give you one engine and then you have to buy everything next to it, like MSS, the BPC licenses, and everything else."

"The licensing cost for SAP Business Warehouse depends on your revenue. Its licensing structure is a little bit complicated. The more your revenue is, the higher the price, but SAP does have different pricing structures for various companies. For small businesses, licensing isn't based on revenue, but for big companies, it's revenue-based. There's some agreement regarding pricing for huge companies, so it's different, and SAP Business Warehouse pricing isn't fixed. On a scale of one to ten, I'm rating the licensing cost for SAP Business Warehouse as five because it's very high. As your revenue grows, your licensing cost also increases, so you have to factor that in when calculating your cost."

"SAP Business Warehouse licensing is a bit expensive compared to other products in the market."

"The license for SAP Business Warehouse is paid yearly, and there's no extra cost in addition to the standard licensing fees."