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."From an ERP point of view and a functionality point of view, it works very well. The benefits are in that of financial costing and material management."
"Some of the main features of this solution are that it uses HANA and it has good performance."
"It's quite scalable."
"The solution is useful for connecting with external systems."
"It is a very stable solution."
"The most valuable feature is the dashboard."
"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 performance is reliable."
"I have found the most valuable features to be the flexibility and the vast amount of features available."
"SQL Server is easy to manage."
"Agent service is a good feature of SQL Server, where you can schedule certain tasks."
"The feature that I have found most valuable is that it is easy to code."
"It's much more friendly in comparison with Oracle."
"You could have an offsite and an onsite, and if the onsite goes down, the offsite picks it up. I like that flexibility to provide continuing operations."
"The most valuable feature is easy installation. It was very easy to install."
"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."
"The solution does occasionally get a few bugs, but this is typical for any product."
"I don't see SAP actively supporting the solution now...a better support from SAP would be appreciated."
"Other competitors provide better solutions that are more up to date with current technology."
"In the next release, I would like to see their BI component introduced with a mobile version, as it is not currently present."
"The solution is not scalable. It does not have a data streaming feature as well."
"I would like more integration."
"The solution is not easy to implement. It requires a lot of learning at the beginning."
"One thing I don't like about SQL Server is the way they've set up security with users and groups. It just doesn't seem that intuitive to me. Adding some more explanatory information might help some."
"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 could improve by enhancing the integration abilities, adding more inbuilt data security features, and simplifying the maintenance."
"The solution could improve by being more user-friendly."
"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."
"They do not offer the SQL Server Management tool via the installation. It is a separate tool I use when I'm trying to configure the mirroring with SQL Server Mirroring. This is not supported and I'm getting some errors on the database mirroring."
"The solution could use better governance on the management side, especially around data governance."
"There is room for improvement in terms of pricing for SQL Server."
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.