Azure Data Factory vs SAP BW/4HANA

Likelihood to Recommend

Suitable for virtually any scenario that involves working with linked Service, so that it is possible to connect Azure Data Factory to storage services for SQL data in the cloud, and that it is possible to access them at any time. Serves to make the information much cleaner and have the desired formats and structures in case of working with time tracking or general employee work tracking applications, so it is easy to create accurate and aesthetically acceptable analysis for general tracking software. It is extremely useful if you do not have any data server service, as Azure Data Factory has the ability to maintain almost 90 different data connectors without the need to use a server.

Read full review

Murray Clear

Independent Contractor Hearing Examiner

LAWYERBESLegal Services, 201-500 employees

View all 8 answers on this topic

Some scenarios where SAP BW/4HANA is well suited are retail industry, supply chain, finance, warehouse, stocking processes, BI, [and] some finance analytics reporting. Some scenarios where SAP BW/4HANA is less appropriate [is when] relational queries are needed [and] in some small business with infrastructure limitations. Another scenario that is less appropriate is for ABAP processes requirements.

Read full review

Mirian Pitti

Engineer

PersonalsoftTelecommunications, 11-50 employees

View all 8 answers on this topic

Feature Rating Comparison

Azure Data Factory

SAP BW/4HANA

Connect to traditional data sources

Connecto to Big Data and NoSQL

Azure Data Factory

SAP BW/4HANA

Simple transformations

Complex transformations

Azure Data Factory

SAP BW/4HANA

Data model creation

Metadata management

Business rules and workflow

Collaboration

Testing and debugging

feature 1

Azure Data Factory

SAP BW/4HANA

Integration with data quality tools

Integration with MDM tools

Pros

Easy to create ETL workflows
Pre-defined templates to design the pipelines
Easy to create schedules to run the pipelines
Fast and reliable
Interactive user interface with drag/drop and multiple useful options on the dashboard
Easy integration with other Azure services

Read full review

Panav Beri

Project Engineer

Wipro LimitedInformation Technology & Services, 10,001+ employees

View all 8 answers on this topic

High speed data warehouse regardless of data volumes.
Excellent integration with SAP systems and Data sets.
Simplified data modelling due to columnar data base.

Read full review

Verified User

Director in Information Technology

Telecommunications Company, 10,001+ employees

View all 8 answers on this topic

Cons

Limited source/sink (target) connectors depending on which area of Azure Data Factory you are using.
Does not yet have parity with SSIS as far as the transforms available.

Read full review

Verified User

Professional in Information Technology

Architecture & Planning Company, 1001-5000 employees

View all 8 answers on this topic

Enterprise license pricing is very expensive and run-time license limits the usefulness of the tool.
Integration with SAP Analytics cloud for write-back to BW/4HANA. Live connection is only read from SAC.
Make run-time licenses more useful.

Read full review

Robert Harper

Product Owner - Management Reporting SAP S4 / HANA

HP IncInformation Technology and Services, 10,001+ employees

View all 8 answers on this topic

Usability

No score

No answers yet

No answers on this topic

SAP BW/4HANA 9.0

Based on 1 answer

SAP BW/4HANA requires specialized skillsets around data warehouse modeling and the access to data, however the modeling capabilities are intuitive and have now become accessible to both SAP and non-SAP data warehouse specialists. This new model allows for Interchangeable skillsets and access to a broader pool of experts throughout the industry, as well as easier access to data.

Read full review

Verified User

Director in Information Technology

Telecommunications Company, 10,001+ employees

View all 1 answers on this topic

Support Rating

Azure Data Factory 7.0

Based on 2 answers

We have not had need to engage with Microsoft much on Azure Data Factory, but they have been responsive and helpful when needed. This being said, we have not had a major emergency or outage requiring their intervention. The score of seven is a representation that they have done well for now, but have not proved out their support for a significant issue

Read full review

Verified User

Professional in Information Technology

Architecture & Planning Company, 1001-5000 employees

View all 2 answers on this topic

SAP BW/4HANA 9.3

Based on 9 answers

SAP Max Attention and general support for SAP BW/4HANA is broadly available. Truth to be told, MaxAttention has a premium cost but brings great engineers. So this being an enterprise capability and extremely critical, we did not consider cost as the main factor since support works well. Just keep that in mind when making your selection.

Read full review

Verified User

Executive in Information Technology

Consumer Goods Company, 10,001+ employees

View all 9 answers on this topic

Alternatives Considered

SSIS was used for on-premise SQL work, Azure data factory is required to unlock the full potential of Azure connected databases. The ease of configuration and the ability to schedule workflows solved so many data integration issues at speed. Without investing in ADF we would not have achieved the level of data integration we have.

Read full review

Verified User

Professional in Information Technology

Hospital & Health Care Company, 1001-5000 employees

View all 8 answers on this topic

SAP Analytics Cloud is complemented by SAP BW/4 HANA through connectors that work in real-time and allow the display of indicator information in interactive and user-friendly visualizations.SAP Data Services integrates with BW/4 HANA allowing to automate the loading of information in the system taking as a data source a wide variety of platforms.

Read full review

Martin Lopez

Gerente de Consultoría

SEIDOR AnalyticsInformation Technology and Services, 201-500 employees

View all 8 answers on this topic

Return on Investment

Facilitate better decision-making and improve business processes.
Optimize business process outcomes by increasing internal efficiency and operational effectiveness.
Boosts revenue growth while improving business process agility.

Read full review

Niloofar Keshvari Nia

IT Operations and Support Specialist

AZEREX LLC.Information Technology & Services, 1-10 employees

View all 8 answers on this topic

Faster turn-around to enhancements
End users can query structures that are not limited to multi-dimensional models.
Performance improvements means that business user can do more in the same time compared to traditional BW

Read full review

Mark Villazon

Senior Technical Specialist

Rio TintoMining & Metals, 10,001+ employees

View all 8 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

Yes

Entry-level set up fee?

Optional

Rating Summary

Azure Data Factory

SAP BW/4HANA

Azure Data Factory

SAP BW/4HANA

Azure Data Factory

SAP BW/4HANA

Likelihood to Recommend