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."We like that it is an SAP product, so we can easily connect with the SAP ERP system."
"I like the reporting features of the solution."
"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."
"It is a stable solution...The initial setup was easy."
"Some of the main features of this solution are that it uses HANA and it has good performance."
"The most valuable feature is that it's robust."
"The product is stable."
"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."
"SQL Server stands out due to its robust parallel processing capabilities."
"The most valuable aspect is the ability to utilize jobs and various functions to accomplish specific tasks, which cannot be achieved with standard procedures alone. This allows for a combination of features and functionalities to be employed."
"The product can scale if a company needs it to."
"I've been using SQL Server for 20 years, and there is nothing that it can't do. It is awesome."
"I have found that SQL Server works very well in the Microsoft Dynamics environment."
"I have found the most valuable features to be the flexibility and the vast amount of features available."
"Having everything in one centralized set of databases is the most valuable feature."
"Very good security features."
"In the next release, I would like to see their BI component introduced with a mobile version, as it is not currently present."
"Pricing would be a good improvement. A lot of customers think that it's very expensive and especially support is very expensive."
"The monitoring for the remodeling feature is very difficult to understand."
"Support could be more reliable."
"I would like to be able to design new reports in a future release."
"Other competitors provide better solutions that are more up to date with current technology."
"There's one area where the other vendors have an upper edge, which is the data lake. I think SAP is trying to figure out whether to stick with IQ, their own data lake solution, or push customers toward customer-preferred vendors, like Azure Data Lake, AWS, or any other provider."
"One thing that could be enhanced in SAP BW4HANA is the user interface for process chains."
"It would be great if we were able to run it on multiple operating systems and not only stick with Windows."
"The tool needs to improve its pricing and technical support."
"Indexing, as well as integration, are areas of this product that need improvement."
"More things in SQL Server need to be automated."
"It may be a licensing issue, but sometimes its operating speed becomes slow if we have multiple users. It's lacking some performance, but it's acceptable because we have a heavy load."
"The performance degrades when the data is huge."
"From a DB administrator perspective, I would like to see more space requirements and space capacity history, so that we are able to see which DBs are growing, and by how much per day or week."
"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 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 "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 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.