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 product has efficient performance."
"SAP BW4HANA aids in managing data from ER to front-end analysis, contributes to ROI, and fosters business growth understanding. I like that the solution breaks down components to a very granular level, allowing for customization and implementation based on specific requirements. The solution is stable. The solution is scalable."
"It is a stable solution...The initial setup was easy."
"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 most valuable feature is that we can transform a huge amount of data and apply business logic as per the requirements."
"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."
"The solution's performance is really good. Also, it's easy to operate, easy to administer, and relatively simple to install."
"Some of the main features of this solution are that it uses HANA and it has good performance."
"I've been using SQL Server for 20 years, and there is nothing that it can't do. It is awesome."
"SQL Server is essentially the backbone of every microservice. From a developer's perspective, it is the backbone of all microservices. The tool enables data retrieval, set data, and essential operations, ensuring the smooth functioning of applications. In essence, it is the integral part that keeps applications operational."
"Managing database is very good."
"It's a flexible solution."
"The most valuable feature of SQL Server is that it is easy to set up."
"SQL Server is a highly stable solution."
"Its availability for a secured server is one of its most valuable features. Also its replications - we can manage eight replicas. Their clustering and availability groups are also valuable."
"The columnstore index feature is useful for us, and we also use the integration services. It is also very stable."
"The dashboard should be simplified and made easier for exploration and decision making."
"I don't see SAP actively supporting the solution now...a better support from SAP would be appreciated."
"The product needs to improve with more performance and fewer data layers."
"In the next release, I would like to see their BI component introduced with a mobile version, as it is not currently present."
"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."
"I would like to be able to design new reports in a future release."
"Pricing would be a good improvement. A lot of customers think that it's very expensive and especially support is very expensive."
"The UI is not user-friendly."
"I would like to see the performance improved. Migrating should be easier and the scalability needs improvement."
"There are certain shortcomings in the scalability of the product, making it an area where improvements are required."
"Since this is a relational order system, scalability has a limit. If your system is very big, you need bigger servers and you have to spend more money. We scale a system up to a certain level, and then we move or shift data to the warehouse, which is NoSQL. We then do not have any bottleneck in scaling. For using this technique we are happy with it."
"The number of concurrent users is too limited and other databases are better than SQL in this regard."
"For a big amount of data, when we are speaking about IoT Segments, and Big Data projects, there are performance issues."
"It is very costly, and that's the reason people are moving away from SQL Server."
"We have no vision. We don't know when or how we have been hacked."
"The way SQL Server pivots data could be improved. For example, I would like built-in comma-separated pivot and unpivot functions."
SAP BW4HANA is ranked 7th in Data Warehouse with 34 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 "An easy-to-operate and administer tool that needs to consider revising its existing licensing cost". 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, Amazon Redshift, SAP HANA and SAP NetWeaver 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.