Most Helpful Review
Find out what your peers are saying about Microsoft Azure SQL Data Warehouse vs. SAP Business Warehouse and other solutions. Updated: January 2020.
390,510 professionals have used our research since 2012.
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
The most valuable feature of the solution is the analytics and that it can connect with Power BI.
The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis.
Azure elasticity allows us to scale as much as we want, and it is pay-as-you-go, so we can scale up as we need to.
The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs.
The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range.
The most valuable feature is the scalability.
The MPP (Massively Parallel Processing) architecture helps to make things a lot faster.
The initial setup was really easy and straightforward.
The warehouse is the solution's most valuable feature.
The most valuable feature of this solution is the advanced structuring of data capabilities. You can get different structures of data to suit your needs.
The key element in this solution is its rapid response. If you have a question about prices, buyers, customers, providers, or services, you need the answer in a minute or two. That's the key benefit for us that a solution like BW gives us.
We are currently in a basic stage of analytics and the first goal we have is to make sure the numbers are correct. BW has some features that help you to build factors and ETL in such a way that it's easy to get to correct responses. That's the number one condition that you have to have in an analytic solution.
I would like my team to be able to build pipelines that integrate with the Azure Data Factory.
I would like to see version control implemented into the data warehouse.
The configuration for things like high-availability could be more user-friendly for non-technical users.
I'm not entirely happy with the billing model. I'm not entirely happy with how the enterprise services are pretty expensive, but that's about it.
With respect to what needs to be improved, concurrent connectivity has some limitations.
It's pay as you go, so you never know what your bill is going to be beforehand, and that's scary for customers. If you have someone who makes a mistake and the program's a loop that is running all night, you could receive a very expensive bill.
This is a young product in transition to the cloud and it needs more work before it is both settled as a product and competitive in the market.
It would be of interest to improve things like the web service integration and availability in terms of being easy to create internal web services in the database.
The solution could offer better connectivity with other databases.
The advanced structuring can be complicated and the interface is not very intuitive.
One of our requirements is the ability to easily get answers regarding trends and exceptions. In BW, it is not that easy to get such information. I expect better trend and exception detection, better pattern detection.
You can start quickly but, when you have to get a little more detailed, when you have to change something, when you have to solve problems, it's not that easy. It's easy to start but evolving is not that easy.
Pricing and Cost Advice
The licensing fees for this solution are on a pay-per-use basis, and not very expensive.
When we are not using this solution we can simply shut it down saving us costs, which is a nice advantage.
This solution starts at €1000.00 a month for just the basics and can go up to €300,000.00 per month for the fastest version.
The pricing is okay. You can pay as you go.
The price of this solution could be improved.
Information Not Available
out of 8 in Cloud Data Warehouse
Average Words per Review
out of 8 in Cloud Data Warehouse
Average Words per Review
Compared 46% of the time.
Compared 9% of the time.
Compared 8% of the time.
Compared 59% of the time.
Compared 25% of the time.
Compared 13% of the time.
Also Known As
|Microsoft Azure SQL DW, Azure SQL Data Warehouse|
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.
Learn more about Microsoft Azure SQL Data Warehouse
Learn more about SAP Business Warehouse
|Toshiba, Carnival, LG Electronics, Jet.com, Adobe,||Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone|
Software R&D Company41%
Financial Services Firm11%
Comms Service Provider7%
No Data Available