Apache Hadoop vs SAP Business Warehouse comparison

"Most valuable features are HDFS and Kafka: Ingestion of huge volumes and variety of unstructured/semi-structured data is feasible, and it helps us to quickly onboard a new Big Data analytics prospect."

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

"Hadoop is a distributed file system, and it scales reasonably well provided you give it sufficient resources."

"The most valuable feature is the database."

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

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

"The platform's quick data processing capabilities have been instrumental in supporting our AI-driven projects."

"It's good for storing historical data and handling analytics on a huge amount of data."

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

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

"The product is very stable."

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

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

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

"What I like most about SAP Business Warehouse is its ability to feed data into new, multiple systems in various formats. It can open its data to any system over gateway services or a portal or application that needs to consume and analyze data."

"The main thing is the lack of community support. If you want to implement a new API or create a new file system, you won't find easy support."

"Hadoop's security could be better."

"General installation/dependency issues were there, but were not a major, complex issue. While migrating data from MySQL to Hive, things are a little challenging, but we were able to get through that with support from forums and a little trial and error."

"I think more of the solution needs to be focused around the panel processing and retrieval of data."

"The stability of the solution needs improvement."

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

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

"There are certain shortcomings when it comes to the product's technical support part, making it an area where improvements are required."

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

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

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

"A few things which are missing include the visualization of reports. That's where your costs and licensing become heavy. When it comes to this database compared Microsoft Warehouse, it's an expensive solution."

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

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

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

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

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

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

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

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

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

"We just use the free version."

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

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

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

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

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

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