Apache Hadoop vs SAP Business Warehouse comparison

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

"They have integrated other tools as well, like Power BI and Oracle BI, both on Azure, for reporting. Oracle BI is difficult to integrate."

"The performance is pretty good."

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

"The best thing about this solution is that it is very powerful and very cheap."

"It's primarily open source. You can handle huge data volumes and create your own views, workflows, and tables. I can also use it for real-time data streaming."

"Hadoop is designed to be scalable, so I don't think that it has limitations in regards to scalability."

"The tool's stability is good."

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

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

"Having the integration with the reporting tool which is provided by SAP is great."

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

"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 warehouse is the solution's most valuable feature."

"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 most valuable feature of SAP Business Warehouse is transformation, where I extract data from different sources, particularly the raw data. Then I do some transformations and store that in a format that allows me to do reporting easily."

"I would like to see more direct integration of visualization applications."

"The solution is very expensive."

"It needs better user interface (UI) functionalities."

"The load optimization capabilities of the product are an area of concern where improvements are required."

"The solution could use a better user interface. It needs a more effective GUI in order to create a better user environment."

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

"It requires a great deal of learning curve to understand. The overall Hadoop ecosystem has a large number of sub-products. There is ZooKeeper, and there are a whole lot of other things that are connected. In many cases, their functionalities are overlapping, and for a newcomer or our clients, it is very difficult to decide which of them to buy and which of them they don't really need. They require a consulting organization for it, which is good for organizations such as ours because that's what we do, but it is not easy for the end customers to gain so much knowledge and optimally use it."

"The product's availability of comprehensive training materials could be improved for faster onboarding and skill development among team members."

"The solution should be more open to the cloud."

"They should reduce the product’s installation package size for easier downloading."

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

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

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

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

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

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

"This is a low cost and powerful solution."

"The price of Apache Hadoop could be less expensive."

"For any big enterprise the costs can be handled, and it is suitable for big enterprises because the scale of data is large. For medium and small enterprises, the tool is on the high-price side."

"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 price could be better. Hortonworks no longer exists, and Cloudera killed the free version of Hadoop."

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

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

"​There are no licensing costs involved, hence money is saved on the software infrastructure​."

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

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

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