IBM Db2 Warehouse vs SAP Business Warehouse comparison

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

"Provides good security and reliability."

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

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

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

"The solution is stable."

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

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

"The best features of SAP Business Warehouse that I am fond of are how this technology handles navigational attributes and the hierarchy; these are two interesting features."

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

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

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

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

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

"The real-time information is great."

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

"Lacks sufficient documentation and particularly in Spanish."

"In terms of improvement, IBM Db2 Warehouse should be more scalable."

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

"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."

"Responding to support tickets takes a lot of time. It can range from two to four days, even for critical issues."

"Integration with SAP Business Warehouse's ETL tools is not straightforward."

"So far, the initial setup process in our company has not been easy enough for us to understand."

"What I'd like improved in SAP Business Warehouse is its setup. It could be more flexible, and it could be a configuration-based setup."

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

"One of our requirements is the ability to easily get answers regarding trends and exceptions. In BW, it is not that easy to get such information. I expect better trend and exception detection, better pattern detection."

"There is room for improvement from a technical perspective."

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

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

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

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

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

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

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

"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 license for SAP Business Warehouse is paid yearly, and there's no extra cost in addition to the standard licensing fees."