Azure Data Factory vs. SAP Datasphere

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Azure Data Factory
Score 9.0 out of 10
N/A
Microsoft's Azure Data Factory is a service built for all data integration needs and skill levels. It is designed to allow the user to easily construct ETL and ELT processes code-free within the intuitive visual environment, or write one's own code. Visually integrate data sources using more than 80 natively built and maintenance-free connectors at no added cost. Focus on data—the serverless integration service does the rest.N/A
SAP Datasphere
Score 8.3 out of 10
N/A
SAP Datasphere, the next generation of SAP Data Warehouse Cloud, is a comprehensive data service that enables data professionals to deliver seamless and scalable access to mission-critical business data. It provides a unified experience for data integration, data cataloging, semantic modeling, data warehousing, data federation, and data virtualization. SAP Datasphere enables users to distribute mission-critical business data — with business context and logic preserved — across the data…N/A
Pricing
Azure Data FactorySAP Datasphere
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Azure Data FactorySAP Datasphere
Free Trial
NoYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional DetailsSAP Datasphere is available as a subscription or consumption-based model. The SAP Datasphere capacity unit (CU) offers an adaptable approach to pricing that enables any workload on any hyperscaler. The number of CUs required is determined by the unique workload, with the ability to tailor the combination of required services within SAP Datasphere utilizing a flexible tenant configuration. The services that contribute to CU consumption are the core application (compute and storage), data lake, BW bridge, data integration, and data catalog (crawling and storage).
More Pricing Information
Community Pulse
Azure Data FactorySAP Datasphere
Considered Both Products
Azure Data Factory
Chose Azure Data Factory
Azure Data Factory fits well into our overall systems architecture where we already utilize largely Azure services and also Microsoft based products in the on-premises environment. I think cost structure is also very competitive with Azure Data Factory. Most services provide a …
Chose Azure Data Factory
Azure Data Factory helps us automate to schedule jobs as per customer demands to make ETL triggers when the need arises. Anyone can define the workflow with the Azure Data Factory UI designer tool and easily test the systems. It helped us automate the same workflow with …
Chose Azure Data Factory
The easy integration with other Microsoft software as well as high processing speed, very flexible cost, and high level of security of Microsoft Azure products and services stack up against other similar products.
Chose Azure Data Factory
I'd chose data factory because its very easy to use, its UI is beautiful, it's library for .net is very useful and it lives within the microsoft ecosystem.
Chose Azure Data Factory
Azure Data Factory is a relatively new player in the space, and its feature set marks it as such. It does not have the full features of a more mature product set such as any of the above. However, it does allow for the creation of ETL/ELT flows/pipelines with minimal initial …
SAP Datasphere
Chose SAP Datasphere
SAP Data Intelligence, SAP Analytics Cloud, SAP BW/4HANA, SAP HANA Cloud, SAP Business Technology Platform and SAP Data Services
Chose SAP Datasphere
some features are better, other for e.g. big data analysis or ai cases not
Chose SAP Datasphere
Each of these listed software has its own unique strength and capacity that scales well. SAP Datasphere on its end up against them with more suitability for large establishments with complex data ecosystems with scalability support. Also, it avails a pay-as-you-go pricing for …
Chose SAP Datasphere
Three main advantages:
1. cost effectiveness
2. Robust and data friendly environments from all sources
Chose SAP Datasphere
I am only going to talk about the visualizing and analytics part of SAP Datasphere because if I start listing what the whole SAP ecosystem provides, then it would not even be a comparison. In a summary, Google Analytics is high-level. Of course, the introduction of the new GA4 …
Chose SAP Datasphere
SAP Datasphere has robust backend integration tools that makes it easy to integrate non-SAP unlike alternatives such as Snowflake.
Chose SAP Datasphere
Cloud based is the future and will enable significant reduction in maintenance from SAP BW on prem solutions.
Chose SAP Datasphere
Scalability and effectiveness to handle large volumes of data while maintaining consistency with the applications. Excellent with data integrity by eliminating duplications. Magnificent with a collection of data from different sources to get trusted data for making decisions.
Chose SAP Datasphere
The Friendly interface that SAP offered was second to none. The Tracking and tracebility that was Integrated helped in configuring locations quite easily and while shifting of cargo it was never an issue. Distribution wise SKU segregation was never a problem and report …
Chose SAP Datasphere
DWC really allows no code model development and also integrates with a lot of data sources without additional tools as ETL
Chose SAP Datasphere
Compared to the SAP Business Warehouse, the DWC can be operated with the SAC in a cloud environment on the Business Technology Platform. Thus, a single point of entry or single point of truth is given in the DWC, and reporting in the SAC is possible. The complete corporate …
Chose SAP Datasphere
It is very easy and quick to develop.it has good and excellent self-service. The use of state art data platform is very easy and simple. It has a high-performance and scalable data warehouse. It accelerates time to value real-time. It gives data a new level of consumption.
Chose SAP Datasphere
It is user-friendly and has self-service tools. It has built-in capabilities such as a data lake. It backed integration capabilities. It gives data on a new level of consumption. It is easy and very quick to develop. It has a high-performance and scalable data warehouse.
Chose SAP Datasphere
Both tools are fairly the same, but we mainly focused on SAP Data Warehouse Cloud since we had a lot of SAP services that were simple to integrate with each other.
Features
Azure Data FactorySAP Datasphere
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Azure Data Factory
9.0
Ratings
7% above category average
SAP Datasphere
-
Ratings
Connect to traditional data sources9.00 Ratings00 Ratings
Connecto to Big Data and NoSQL9.00 Ratings00 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Azure Data Factory
8.5
Ratings
4% above category average
SAP Datasphere
-
Ratings
Simple transformations9.00 Ratings00 Ratings
Complex transformations8.00 Ratings00 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Azure Data Factory
7.2
Ratings
10% below category average
SAP Datasphere
-
Ratings
Data model creation8.00 Ratings00 Ratings
Metadata management7.00 Ratings00 Ratings
Business rules and workflow7.00 Ratings00 Ratings
Collaboration6.00 Ratings00 Ratings
Testing and debugging7.00 Ratings00 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Azure Data Factory
7.5
Ratings
8% below category average
SAP Datasphere
-
Ratings
Integration with data quality tools7.00 Ratings00 Ratings
Integration with MDM tools8.00 Ratings00 Ratings
Best Alternatives
Azure Data FactorySAP Datasphere
Small Businesses
Skyvia
Skyvia
Score 9.9 out of 10
Google BigQuery
Google BigQuery
Score 8.5 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Snowflake
Snowflake
Score 8.9 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Snowflake
Snowflake
Score 8.9 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Azure Data FactorySAP Datasphere
Likelihood to Recommend
9.0
(0 ratings)
8.5
(0 ratings)
Usability
-
(0 ratings)
7.7
(0 ratings)
Support Rating
7.0
(0 ratings)
9.0
(0 ratings)
User Testimonials
Azure Data FactorySAP Datasphere
Likelihood to Recommend
In a data pipeline, you will be able to add different kinds of activities for example connect from your on-premise SFTP and move CSV files to storage accounts. As well data factory has its own data flow if you are an ETL developer who experimented with maybe you have worked with SSIS, thus, you will start quickly with this new feature of the data factory.
Read full review
SAP is best suited for large global corporations. It is a very complex software and is difficult to come by individuals who have sufficient enough knowledge to master the product. Globally our company only has 1 person to support us in IT for SAP. It is great if you use a more complex web host such as SFCC as you can make connections to SAP for returns, inventory, price updates, etc.
Read full review
Pros
  • Creating ETL and ELT workflows as well as orchestrating and monitoring pipelines without writing any code.
  • Hybrid data integration is easily and agilely possible through this software.
  • It has lot of various useful components
Read full review
  • SAP Data Warehouse Cloud offers free trial for 90 days with free 128 GB of storage and 64 GB memory.
  • Availability of self-service data modeling and analytics on SAP Data Warehouse Cloud enables users to access and analyze data without getting support from the IT team.
  • Without zero coding while collecting, connecting, analyzing and modeling data, it saves us time and operational costs of partnering with external IT support experts.
Read full review
Cons
  • Learning curve for pipeline creation interface.
  • Alerting isn't necessarily built in. Had to work around this to meet team needs.
  • With GIT enabled, some features can only be done via git, while some need to be done via the portal.
Read full review
  • SAP Data Warehouse Cloud is quite complex, therefore, some extra orientation or training might be essential, more so on cloud.
  • Secondly, SAP Data installation fee, and the monthly subscription amounts is slightly demanding, and the developer should refocus on changing them.
  • Nonetheless, SAP Data rectified other challenges like flexibility and customization, making us happy clients.
Read full review
Usability
So far product has performed as expected. We were noticing some performance issues, but they were largely Synapse related. This has led to a shift from Synapse to Databricks. Overall this has delayed our analytic platform. Once databricks becomes fully operational, Azure Data Factory will be critical to our environment and future success.
Read full review
It is one of the best tools and a boon to Logistics teams across the globe. One tends to actually process warehousing data so smoothly and the way demonstration is made while in programs it makes it user friendly. The Inventory touch points that one identify is simply awesome and is best part.
Read full review
Support Rating
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
I would greatly acknowledge the services of Sap Data [warehouse Cloud] because we were struggling before its arrival where we used to get manual data connections and this used to consume a lot of time but after its use, we now are able to connect data easily saving a lot of time and finances.
Read full review
Alternatives Considered
Azure Data Factory fits well into our overall systems architecture where we already utilize largely Azure services and also Microsoft based products in the on-premises environment. I think cost structure is also very competitive with Azure Data Factory. Most services provide a visual interface for designing ETL workflows, but our team found Azure Data Factory's interface more intuitive.
Read full review
Each of these listed software has its own unique strength and capacity that scales well. SAP Datasphere on its end up against them with more suitability for large establishments with complex data ecosystems with scalability support. Also, it avails a pay-as-you-go pricing for users, and it is widely up for data quality, data governance, and data discovery.
Read full review
Return on Investment
  • Limiting the amount of data moving up and down from the cloud for cloud-native applications.
  • Overall simple to use interface which is actually easier for a first time ETL developer than SSIS.
Read full review
  • Enhanced our report generation process due to presence of holistic data.
  • Centralized data from all our platforms. This has helped us visualize and analyze all data much more efficiently.
  • It is more on the expensive side from both cost and training perspective.
Read full review
ScreenShots