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."I like the reporting features of the solution."
"The most valuable feature is the dashboard."
"It is a stable solution...It is a scalable solution."
"The product has efficient 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."
"It is a stable solution."
"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."
"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."
"SQL Server Profiler makes finding and debugging easy."
"The feature that I have found most valuable is that it is easy to code."
"SQL Server's Management Studio is very user friendly. I like their database and the additional features it offers. It's also easy to integrate SQL Server with things like CLR, PowerShell, and command shell"
"It's easy to use and fairly intuitive. I do development and data analysis, so we do a lot of work with SSIS and SQL Job Scheduler. Deploying new databases is very simple with things like BACPAC."
"I haven't really experienced any issues that required the assistance of technical support."
"I have seen that this is a very stable product."
"can extract data from the server and store it in a local data source for BI purposes."
"Backups hardly get corrupt."
"The solution does occasionally get a few bugs, but this is typical for any product."
"The monitoring for the remodeling feature is very difficult to understand."
"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."
"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."
"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."
"I would like to be able to design new reports in a future release."
"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 product needs to improve with more performance and fewer data layers."
"Microsoft support is an issue unto itself."
"The reporting services of the solution (SSRS and now Power BI) are the less valuable items of the SQL Server suite."
"Third-party services from Redgate should be built-in to it, like SQL Search."
"We pay a license fee, it could always be cheaper."
"In the next release, I would like to see a better user interface and a familiar syntax."
"The solution could improve by having more integration with other operating systems and other platforms."
"The scalability and the high availability feature can be expanded or improved. Currently, there is a limitation on scalability. A feature similar to the Oracle Diagnostic feature can be included to provide a better user experience."
"SQL Server is an expensive solution"
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.