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."The solution is based on SAP ERP, so there's some business content already included. For customers who use SAP ERP, SAP BW4HANA is a good choice for their DW implementation."
"I like how it blends no-code and ABAP code for complex transformations during data loading."
"The product is stable."
"You can do hierarchical alert slicing and dicing out-of-box, which is not available in other solutions. I haven't come across that in Oracle or any other software provider."
"The solution seamlessly integrates with SAP products."
"The most valuable features are the speed of reporting and the HANA database."
"It is a stable solution."
"I like the reporting features of the solution."
"Very stable relational database management system that offers ease of management, querying, and scaling. It has well-designed databases."
"I like that it's relatively stable."
"The technical support is good."
"SQL Server is a stable product."
"The most valuable aspect of the solution is that it's integrated with the Visual Studio and also with Microsoft SQL Server Management Studio. It's a tool they have and it's quite easy to use and understand. It's the interface for programming for SQL Services."
"The solution is configurable."
"SQL Server is widely used and it's simple. You cannot do without Microsoft if you want to manage IT for a business customer."
"I have contacted technical support, and overall my experience with technical support was okay."
"The solution does occasionally get a few bugs, but this is typical for any product."
"The solution is not scalable. It does not have a data streaming feature as well."
"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."
"The solution is not easy to implement. It requires a lot of learning at the beginning."
"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."
"One thing that could be enhanced in SAP BW4HANA is the user interface for process chains."
"If I want to have good reporting, then I have to buy a separate license."
"Other competitors provide better solutions that are more up to date with current technology."
"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."
"Support could be improved."
"I would like to see SQL Server add the ability to write to multiple sites or support replication between multiple sites at the transaction level."
"While using it, we really didn't experience any pain points."
"SQL is a highly unstable server - there are patch updates on the Windows server every week, which is why we only use it for non-critical systems."
"Could have additional security."
"Better integration with other platforms would be an improvement."
"We want to move to Azure, and the solution could be made better to make the process easier for the migration from on-premise to the cloud."
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 IQ, 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.