IBM Db2 Warehouse vs SAP Business Warehouse comparison

"Provides good security and reliability."

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

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

"The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data."

"The solution is stable."

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

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

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

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

"The solution has functionality that makes it easy for end-users to readily extract data directly from Business Warehouse into Excel and carry on their analysis on their own."

"In terms of stability, comparatively, the solution is quite stable."

"Having the back-end data set with the right information is the best qualification for this solution."

"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 most useful feature is definitely the speed."

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

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

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

"IBM Db2 Warehouse needs to improve its interface."

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

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

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

"SAP Business Warehouse could integrate better with other ETL tools."

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

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

"I get all the information quickly, but it is one day old."

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

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

"It's a product that is at the end of life so they will not improve it anymore."

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

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

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

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

"The solution is quite expensive."

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

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

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

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