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's performance is really good. Also, it's easy to operate, easy to administer, and relatively simple to install."
"The solution is useful for connecting with external systems."
"The solution seamlessly integrates with SAP products."
"We can get good visualization and less redundant data."
"I like that it's quite quick."
"The processes are the most valuable aspect of this solution."
"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."
"We like that it is an SAP product, so we can easily connect with the SAP ERP system."
"SQL Server scales well."
"We have found the solution to be scalable."
"Backups hardly get corrupt."
"It's a very stable solution."
"The documentation and manuals are very good."
"The solution is very easy to use. It's intuitive and easy to navigate. Overall, it's a straightforward product."
"The ease of administration, in general, is the solution's most valuable aspect."
"SQL Server's most valuable features are that it is a large number of community resources to help you out. that's one, and then it is quite powerful."
"The solution does occasionally get a few bugs, but this is typical for any product."
"Not a ten because it's expensive and its ecosystem is not very open."
"The speed of operations could be a little faster."
"The product needs to improve with more performance and fewer data layers."
"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."
"Support could be more reliable."
"I would like more integration."
"BW/4HANA could improve query optimization. For example, there could be an error message that pops up when you hover over it if any query fails. That would make it easier to find out what went gone wrong. Guided SAP help tools would make it easier for us to go forward."
"Performance could be better. But I don't know if it's a problem with my application or with my database."
"I have experience working with SQL Server 2016 and older versions, including handling JSON data. Initially, I found the JSON capabilities to be less helpful, but over time, they have greatly improved. SQL Server now offers extensive capabilities for working with various forms of data, particularly when communicating with text, such as in JSON format. I particularly prefer working with these features on Azure, as it provides numerous possibilities, especially in the field of business intelligence (BI). Additionally, the serverless platform offered by Azure is highly beneficial and makes tasks easier to manage."
"I would like Microsoft to evolve SQL Server because stateful databases dying are in a way. We would like to find out if it can absorb Hadoop and other similar things. They should make it useful for data mining. Data is evolving forever, and how we store it is also changing constantly. So, SQL Server also needs to change."
"SQL Server could improve by having better usability or user guidance."
"There should be more tools and documentation for tuning the performance of Microsoft SQL Server. It would be nice to have more tools for tuning because currently, all the tuning that we have to do with our databases is almost manual. We have to read a bunch of knowledge base articles, and this information should be better documented. Its free text search should also be improved. It is quite important for us. Currently, we're developing our own free text search because of the lacking flexibility in Microsoft SQL Server. Therefore, we're kind of using elastic search and making different implementations in order to reach our targets. Using just the native free text search of Microsoft SQL Server is not enough for us. It should have more flexible features as compared to the current version."
"SQL Server backups could be better."
"The UX design of this system needs improvement."
"We have had problems implementing a data warehouse using SQL Server."
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 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.