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."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."
"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 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 most valuable feature is the dashboard."
"It is a stable solution."
"It is a stable solution...It is a scalable solution."
"The most valuable feature is that we can transform a huge amount of data and apply business logic as per the requirements."
"The solution seamlessly integrates with SAP products."
"The security and vulnerability management are well-managed through the vendor."
"The product is easy to use."
"I have seen that this is a very stable product."
"There was an online system in which we had about 2500 requests to the DB per second. Every request had a completion window of one second to process and retrieve data. After switching to SQL Server, and AlwaysOn, and Snapshot, and tinkering, and configuring and tinkering, the handling capacity we measured increased to about 5000 requests per second, while the time decreased to 0.5 seconds per request."
"Microsoft SQL Server is one of the better database administration software packages out there. It runs primarily on Windows Server platforms, but it can also run on Linux platforms."
"We're satisfied with the stability."
"Microsoft is less demanding because everything is GUI, unlike Oracle, where you need to use command lines."
"SQL Server's performance is fine."
"Pricing would be a good improvement. A lot of customers think that it's very expensive and especially support is very expensive."
"If I want to have good reporting, then I have to buy a separate license."
"The tool is not cloud-compatible."
"The dashboard should be simplified and made easier for exploration and decision making."
"We cannot integrate with third-party tools like Python or advanced integration options. You can't fine-tune tables within BW or generate specific views or reports."
"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."
"In the next release, I would like to see their BI component introduced with a mobile version, as it is not currently present."
"Price wise, this solution is on the higher side."
"I do not think SQL Server is suited for a typical database warehouse environment. However, people do use SQL Server for data warehouse environments but the best use case is for very small databases. If somebody wants to store more than 10 TB of data querying then the performance really degrades. The performance should be improved in the future to allow more scalability."
"Its support for JSON should be improved. It does support JSON, but the support is not good enough currently. They should also improve the way indexes work. Its performance can also be improved because sometimes it becomes very slow for certain table designs. It cannot have more than a certain amount of data. As compared to other databases, its capability to handle large volumes of data is not very good."
"While using it, we really didn't experience any pain points."
"There is room for improvement in terms of pricing for SQL Server."
"Its security can be improved. When you look at the Windows environment, it isn't the most secure environment. It is exposed to so many attacks. They continuously need to improve the security of the platform on which it sits."
"It needs to be improved to handle big data for large volumes of transactions for big industries. As compared to Oracle Database, SQL Server is not suitable for big data or large organizations where the database size could be more than 100 GB or more. In our country, for a large database and a large volume of transactions, we normally use Oracle Database. Most of the large banks are shifting from SQL Server to Oracle Database because of its slowness."
"There are a lot of improvements in the cloud space about which we open a case with Microsoft every now and then. These improvements are not in terms of features or functionality. They are more related to their own compatibility or connectivity on which they keep on working to improve the product."
"Improvements to the indexing, columnstore indexing, and high availability groups are good improvements for future versions."
SAP BW4HANA is ranked 7th in Data Warehouse with 36 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, SAP HANA, Amazon Redshift 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.