We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"The useability, the user interface, is very user-friendly."
"The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis."
"The whole solution is interesting for us."
"The most important feature for me is the integration with PolyBase."
"We also like governance. It looks at what the requirements are for the company to identify the best way to ensure compliance is met when you move to the cloud."
"I like its performance. It is well-structured and offers a lot of practical options. Because of the visual design of the product, it is very easy to find icons and other visual elements. It took me more than two weeks to understand how it works. I had an intensive training session to understand it, which was enough. It was not hard to understand how it works."
"The most valuable feature is performance gains."
"The most valuable feature is that you can suspend the computer if it is not being used, which means that you don't incur costs."
"In terms of stability, comparatively, the solution is quite stable."
"I like that it integrates to open-source."
"Having the back-end data set with the right information is the best qualification for this solution."
"The solution has functionality that makes it easy for end-users to readily extract data directly from Business Warehouse into Excel and carry on their analysis on their own."
"The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."
"The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them."
"While the solution is flexible, sometimes this works against the user."
"With respect to what needs to be improved, concurrent connectivity has some limitations."
"I am a researcher. For people to be able to research a solution, there should be at least a free trial. Just advertising a product or saying that this product is better doesn't work. I would strongly recommend providing a lot of free trials and trainings. This will also help Microsoft in having more users or customers. Oracle provides some free trials. You can just go for a free trial and use your database online, which is very good."
"Documentation could be improved."
"It's a complicated product."
"I would like my team to be able to build pipelines that integrate with the Azure Data Factory."
"We are very unhappy with technical support. First of all, they send their sales agents or pre-sales agents and most of them who don't know the solution as a properly trained tech would. We have an on-site SAP representative who is supposed to help us with our high priority and production issues, and they're not satisfactory to say the least."
"SAP Business Warehouse could integrate better with other ETL tools."
"More integration with Microsoft Office products (not just Excel) would be helpful."
"A few things which are missing include the visualization of reports. That's where your costs and licensing become heavy. When it comes to this database compared Microsoft Warehouse, it's an expensive solution."
"I would like to see a different end solution in order to read the data and attract internal users."
"The price of the package not expensive and depends on how much it is used."
"Its price could be better. It was a school project, and I got it for free. If I try to pay through my company, it is a little bit more expensive as compared to Oracle."
"When we are not using this solution we can simply shut it down saving us costs, which is a nice advantage."
"It requires a less expensive version because currently, not every customer is able to buy it. If it could have a smaller setup that doesn't require so many resources, it would be helpful, and we would be able to use it in more cases. We are a small country, and most of our customers are quite small businesses."
"The solution is subscription-based. You can also pay to use the product as you go."
"The cost of the licensing depends on the size of the warehouse, where the cost of storage is approximately $130 USD per terabyte."
"We chose the serverless option for the database which has saved us a lot of money. Our costs are approximately £600 per month."
"They are cost aggressive, and it integrates well with other Microsoft tools."
"It's moderately expensive, but definitely has its branding and price value for it."
Azure SQL Data Warehouse is a Fast, flexible, and secure analytics platform for the enterprise. Azure SQL Data Warehouse lets you independently scale compute and storage, while pausing and resuming your data warehouse within minutes through a massively parallel processing architecture designed for the cloud. Seamlessly create your hub for analytics along with native connectivity with data integration and visualization services, all while using your existing SQL and BI skills.
Reporting, analysis and interpretation of business data are crucial to preserve and enhance the competitive edge of companies by optimizing processes and enabling them to react quickly and in line with market needs. SAP Business Warehouse (SAP BW) provides tools and functions that enable companies to attain these goals. In SAP BW, you can integrate, transform, and consolidate relevant business information from productive SAP applications and external data sources. SAP BW provides you with a high-performance infrastructure that helps you evaluate and interpret data. Decision makers can make well-founded decisions and identify target-orientated activities on the basis of the analyzed data.
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 34 reviews while SAP Business Warehouse is ranked 7th in Cloud Data Warehouse with 5 reviews. Microsoft Azure Synapse Analytics is rated 8.0, while SAP Business Warehouse is rated 7.6. The top reviewer of Microsoft Azure Synapse Analytics writes "Scalable, intuitive, facilitates compliance and keeping your data secure". On the other hand, the top reviewer of SAP Business Warehouse writes "Has ready-made connectors where we can extract data from ". Microsoft Azure Synapse Analytics is most compared with Snowflake, Amazon Redshift, SAP BW4HANA and Apache Hadoop, whereas SAP Business Warehouse is most compared with Snowflake, Amazon Redshift and SAP NetWeaver Business Warehouse. See our Microsoft Azure Synapse Analytics vs. SAP Business Warehouse report.
We monitor all Cloud 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.