Apache Hadoop vs SAP Business Warehouse comparison

"Hadoop is extensible — it's elastic."

"What comes with the standard setup is what we mostly use, but Ambari is the most important."

"The most valuable feature is scalability and the possibility to work with major information and open source capability."

"As compared to Hive on MapReduce, Impala on MPP returns results of SQL queries in a fairly short amount of time, and is relatively fast when reading data into other platforms like R."

"Hadoop can store any kind of data—structured, unstructured, and semi-structured—and presents it using the relational model through Hive."

"Its integration is Hadoop's best feature because that allows us to support different tools in a big data platform."

"​​Data ingestion: It has rapid speed, if Apache Accumulo is used."

"We selected Apache Hadoop because it is not dependent on third-party vendors."

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

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

"With the technical support, the response has been pretty good from the SAP side."

"Out-of-the-box reports are very useful."

"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 most valuable aspect of the solution is the integration with SAP ERP."

"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 solution is very expensive."

"It would be helpful to have more information on how to best apply this solution to smaller organizations, with less data, and grow the data lake."

"The stability of the solution needs improvement."

"The solution needs a better tutorial. There are only documents available currently. There's a lot of YouTube videos available. However, in terms of learning, we didn't have great success trying to learn that way. There needs to be better self-paced learning."

"In certain cases, the configurations for dealing with data skewness do not make any sense."

"Based on our needs, we would like to see a tool for data visualization and enhanced Ambari for management, plus a pre-built IoT hub/model. These would reduce our efforts and the time needed to prove to a customer that this will help them."

"It would be good to have more advanced analytics tools."

"It could be more user-friendly."

"SAP Business Warehouse could improve by having more out-of-the-box use cases to cover more business types or operations."

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

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

"I'm not sure if our issue is related to BW or the Analysis Office. However, we're having performance issues in terms of time. It takes a long time to generate the report."

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

"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 advanced structuring can be complicated and the interface is not very intuitive."

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

"We just use the free version."

"The product is open-source, but some associated licensing fees depend on the subscription level."

"The price could be better. Hortonworks no longer exists, and Cloudera killed the free version of Hadoop."

"This is a low cost and powerful solution."

"It's reasonable, but there's room for improvement in cost-effectiveness."

"Do take into consider that data storage and compute capacity scale differently and hence purchasing a "boxed" / 'all-in-one" solution (software and hardware) might not be the best idea."

"We don't directly pay for it. Our clients pay for it, and they usually don't complain about the price. So, it is probably acceptable."

"If my company can use the cloud version of Apache Hadoop, particularly the cloud storage feature, it would be easier and would cost less because an on-premises deployment has a higher cost during storage, for example, though I don't know exactly how much Apache Hadoop costs."

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

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

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

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

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