Apache Hadoop vs SAP Business Warehouse comparison

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

"Initially, with RDBMS alone, we had a lot of work and few servers running on-premise and on cloud for the PoC and incubation. With the use of Hadoop and ecosystem components and tools, and managing it in Amazon EC2, we have created a Big Data "lab" which helps us to centralize all our work and solutions into a single repository. This has cut down the time in terms of maintenance, development and, especially, data processing challenges."

"The most important feature is its ability to handle large volumes. Some of our customers have really large volumes, and it is capable of handling their data in terms of the core volume and daily incremental volume. So, its processing power and speed are most valuable."

"The tool's stability is good."

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

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

"It is a reliable product."

"The most valuable feature is the database."

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

"The product is very stable."

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

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

"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 features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."

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

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

"Improvements in security measures would be beneficial, given the large volumes of data handled."

"From the Apache perspective or the open-source community, they need to add more capabilities to make life easier from a configuration and deployment perspective."

"Real-time data processing is weak. This solution is very difficult to run and implement."

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

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

"There is a lack of virtualization and presentation layers, so you can't take it and implement it like a radio solution."

"The integration with Apache Hadoop with lots of different techniques within your business can be a challenge."

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

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

"More integration with Microsoft Office products (not just Excel) would be helpful."

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

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

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

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

"You can start quickly but, when you have to get a little more detailed, when you have to change something, when you have to solve problems, it's not that easy. It's easy to start but evolving is not that easy."

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

"We just use the free version."

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

"This is a low cost and powerful solution."

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

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

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

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

"The license for SAP Business Warehouse is paid yearly, and there's no extra cost in addition to the standard licensing fees."

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

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

"The solution is quite expensive."

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