We performed a comparison between SAP BW4HANA and SQL Server based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."Some of the main features of this solution are that it uses HANA and it has good performance."
"It can calculate data in detail. Before we could not calculate financial documents and accountant documents in detail, we could not do it at a document level but now we can. This is the most important feature. It also has predictive analysis memory."
"The solution's performance is really good. Also, it's easy to operate, easy to administer, and relatively simple to install."
"The product is stable."
"The UI is completely new, beautiful, and user-friendly. There are some other helpful features like global filters and advanced tools. We can perform custom calculations easily From a technical perspective, the performance has been enhanced and optimized for a limited number of flows. The content settings are more advanced, and there are so many other features that I can't name them all."
"Its direct approach is the most valuable. You get more real time and capabilities than BW."
"One significant advantage of SAP BW/4HANA is the direct integration with the SAP HANA database, providing seamless access to real-time analytics. Additionally, it enables real-time data integration. We don't need to rely on historical data alone; we can provide reporting and features based on real-time information."
"It is a stable solution...The initial setup was easy."
"SQL Server is very scalable because we use it across a couple of different types of applications, such as micro-infrastructure setup and server farm."
"I find query optimization to be highly valuable for data management. Additionally, drag-and-drop query creation greatly facilitates data management tasks."
"There is a lot of information about the solution readily available online."
"As a data warehouse and storage solution, it's quite good."
"I like that it's a cloud solution, is simple to set up, and is simple to use."
"The solution has a reliable database."
"We are using the net for our environment. We're using the ADF Azure data factory for our analysis services, and it is pretty good."
"The most valuable features for database management in SQL Server are SQL Server Management Studio and Visual Studio Code with its administration capabilities."
"Challenges arise with real-time client requirements when clients are accustomed to Microsoft Excel's extensive features for data analysis. They expect similar flexibility and customization in the solution, particularly regarding headers displaying keys and descriptions or just keys. Achieving this level of customization can be challenging, and it's an area that may need improvement."
"The cost of the product might be an area that might introduce some restrictions or limitations to customers, making it one of the aspects where improvements are required."
"The tool is not easy to use for an end user."
"I cannot integrate it with my other tools. It's not possible to do something in the predictive analysis. Mobile reporting is also not available."
"From a technical perspective, it could be even more related to legacy systems. The connectivity requirement is quite high and requires systems that are up-to-date."
"One thing that could be enhanced in SAP BW4HANA is the user interface for process chains."
"It's complicated to use. You need to spend a lot of time learning about it. The interface could be improved. It's not intuitive to build a data model and use their ETL tools."
"The speed of operations could be a little faster."
"The user interface and the reporting could also be improved."
"It would be ideal if the solution offered better integration capabilities."
"In the next releases, I would only like more enhanced backups and more restore points."
"SQL Server is an expensive solution"
"Something that could be improved is the cost because it's very high. That's the only thing I'm concerned about but the technology is good."
"Scalability of the database could be improved if it could handle increased volumes of data."
"In some cases it is quite difficult, like the lack of ease of the replication and other issues. They have to improve on that. They do not have features like "always on," which is complicated."
"Microsoft doesn't have active-active load balancing scenarios. It's always a failover cluster."
SAP BW4HANA is ranked 8th in Data Warehouse with 37 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. SAP BW4HANA is rated 7.4, while SQL Server is rated 8.4. The top reviewer of SAP BW4HANA writes "Performs all necessary data warehouse tasks and offers additional functionalities". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". SAP BW4HANA is most compared with Microsoft Azure Synapse Analytics, Snowflake, SAP HANA, Amazon Redshift and SAP Business Warehouse, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and IBM Db2 Database.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.