We performed a comparison between Azure Data Factory and SAP Business Warehouse based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."This solution will allow the organisation to improve its existing data offerings over time by adding predictive analytics, data sharing via APIs and other enhancements readily."
"It's cloud-based, allowing multiple users to easily access the solution from the office or remote locations. I like that we can set up the security protocols for IP addresses, like allow lists. It's a pretty user-friendly product as well. The interface and build environment where you create pipelines are easy to use. It's straightforward to manage the digital transformation pipelines we build."
"I like how you can create your own pipeline in your space and reuse those creations. You can collaborate with other people who want to use your code."
"We have found the bulk load feature very valuable."
"The data mapping and the ability to systematically derive data are nice features. It worked really well for the solution we had. It is visual, and it did the transformation as we wanted."
"Data Factory's best feature is the ease of setting up pipelines for data and cloud integrations."
"I can do everything I want with SSIS and Azure Data Factory."
"We haven't had any issues connecting it to other products."
"The most valuable feature of SAP Business Warehouse is transformation, where I extract data from different sources, particularly the raw data. Then I do some transformations and store that in a format that allows me to do reporting easily."
"Having the back-end data set with the right information is the best qualification for this solution."
"SAP Business Warehouse is a scalable solution."
"What I like most about SAP Business Warehouse is its ability to feed data into new, multiple systems in various formats. It can open its data to any system over gateway services or a portal or application that needs to consume and analyze data."
"The warehouse is the solution's most valuable feature."
"Now, because of the HANA integration, the hard disk and RAM are together, and because of that, the output is very quick and very fast actually."
"Predominantly, our company uses SAP Business Warehouse for reporting purposes across various departments, especially for managers to gain a quick understanding of their current standing and make informed decisions."
"The most useful feature has been he ability to feed data into multiple systems in various formats."
"The Microsoft documentation is too complicated."
"User-friendliness and user effectiveness are unquestionably important, and it may be a good option here to improve the user experience. However, I believe that more and more sophisticated monitoring would be beneficial."
"The pricing model should be more transparent and available online."
"The one element of the solution that we have used and could be improved is the user interface."
"There is always room to improve. There should be good examples of use that, of course, customers aren't always willing to share. It is Catch-22. It would help the user base if everybody had really good examples of deployments that worked, but when you ask people to put out their good deployments, which also includes me, you usually got, "No, I'm not going to do that." They don't have enough good examples. Microsoft probably just needs to pay one of their partners to build 20 or 30 examples of functional Data Factories and then share them as a user base."
"I would like to be informed about the changes ahead of time, so we are aware of what's coming."
"The setup and configuration process could be simplified."
"Currently, our company requires a monitoring tool, and that isn't available in Azure Data Factory."
"More integration with Microsoft Office products (not just Excel) would be helpful."
"There is room for improvement from a technical perspective."
"SAP Business Warehouse could integrate better with other ETL tools."
"The problem with BW, and the factor that differentiated it from the original BW, is that you only get limited functionality with your runtime license. So, you have to pay extra for extracting data."
"I get all the information quickly, but it is one day old."
"What I'd like to improve in SAP Business Warehouse is its data structure, that's a little bit rigid. It could be a bit more flexible, so you can design your data structure and improve performance when creating a solution. Currently, the way data is stored in SAP Business Warehouse is rigid."
"Areas for improvement in SAP Business Warehouse include enhancing scheduling and monitoring tools, as well as improving communication about hidden features to make them more accessible to users."
"I'm not sure if our issue is related to BW or the Analysis Office. However, we're having performance issues in terms of time. It takes a long time to generate the report."
Azure Data Factory is ranked 3rd in Cloud Data Warehouse with 81 reviews while SAP Business Warehouse is ranked 9th in Cloud Data Warehouse with 25 reviews. Azure Data Factory is rated 8.0, while SAP Business Warehouse is rated 7.8. The top reviewer of Azure Data Factory writes "The data factory agent is quite good but pricing needs to be more transparent". On the other hand, the top reviewer of SAP Business Warehouse writes "Offers powerful analytics and integration capabilities but requires improved upgrade processes". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and IBM InfoSphere DataStage, whereas SAP Business Warehouse is most compared with Microsoft Azure Synapse Analytics, Snowflake, BigQuery, SAP BW4HANA and SAP NetWeaver Business Warehouse. See our Azure Data Factory vs. SAP Business Warehouse report.
See our list of best Cloud Data Warehouse vendors.
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.