Azure Data Factory vs Oracle Autonomous Data Warehouse comparison

Microsoft and Oracle are both solutions in the Cloud Data Warehouse category. Microsoft is ranked #3 with an average rating of 8.0, while Oracle is ranked #9 with an average rating of 8.4. Microsoft holds a 12.9% mindshare in CDW, compared to Oracle’s 6.1% mindshare. Additionally, 92% of Microsoft users are willing to recommend the solution, compared to 100% of Oracle users who would recommend it.

Azure Data Factory

Read 86 Azure Data Factory reviews

5,937 Views
4,775 Comparison Views

92% willing to recommend

Oracle Autonomous Data Ware...

Read 18 Oracle Autonomous Data Warehouse reviews

2,621 Views
1,752 Comparison Views

100% willing to recommend

Azure Data Factory

Oracle Autonomous Data Ware...

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Azure Data Factory and Oracle Autonomous Data 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.

To learn more, read our detailed Azure Data Factory vs. Oracle Autonomous Data Warehouse Report (Updated: October 2024).

Buyer's Guide

Azure Data Factory vs. Oracle Autonomous Data Warehouse

October 2024

Download the complete report

Helped 816,406 peers since 2012

Categories and Ranking

Azure Data Factory

Ranking in Cloud Data Warehouse

3rd

Average Rating

8.0

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

Data Integration (1st)

Oracle Autonomous Data Ware...

Ranking in Cloud Data Warehouse

9th

Average Rating

8.6

Reviews Sentiment

7.5

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of November 2024, in the Cloud Data Warehouse category, the mindshare of Azure Data Factory is 12.9%, down from 13.4% compared to the previous year. The mindshare of Oracle Autonomous Data Warehouse is 6.1%, up from 4.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Cloud Data Warehouse

Featured Reviews

Thulani David Mngadi

Data architect at Old Mutual

Data flow feature is valuable for data transformation tasks

The workflow automation features in GitLab, particularly its low code/no code approach, are highly beneficial for accelerating development speed. This feature allows for quick creation of pipelines and offers customization options for integration needs, making it versatile for various use cases. GitLab supports a wide range of connectors, catering to a majority of integration needs. Azure Data Factory's virtual enterprise and monitoring capabilities, the visual interface of GitLab makes it user-friendly and easy to teach, facilitating adoption within teams. While the monitoring capabilities are sufficient out of the box, they may not be as comprehensive as dedicated enterprise monitoring tools. GitLab's monitoring features are manageable for production use, with the option to integrate log analytics or create custom dashboards if needed. The data flow feature in Azure Data Factory within GitLab is valuable for data transformation tasks, especially for those who may not have expertise in writing complex code. It simplifies the process of data manipulation and is particularly useful for individuals unfamiliar with Spark coding. While there could be improvements for more flexibility, overall, the data flow feature effectively accomplishes its purpose within GitLab's ecosystem.

Read full review

Kwajah Mohiuddin

Global Head of Architecture at a financial services firm with 1,001-5,000 employees

Provides self-repair features, but the setup is complex

We use the product for online applications. We use it in the financial industry The product has self-repair features. The tool tunes itself. It separates compute from storage. We can scale storage and compute separately. The setup is complex. Oracle is a complex tool. I have been using Oracle…

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"The tool's most valuable features are its connectors. It has many out-of-the-box connectors. We use ADF for ETL processes. Our main use case involves integrating data from various databases, processing it, and loading it into the target database. ADF plays a crucial role in orchestrating these ETL workflows."

"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."

"The function of the solution is great."

"When it comes to our business requirements, this solution has worked well for us. However, we have not stretched it to the limit."

"It makes it easy to collect data from different sources."

"Data Factory's best features are connectivity with different tools and focusing data ingestion using pipeline copy data."

"The solution includes a feature that increases the number of processors used which makes it very powerful and adds to the scalability."

"The best part of this product is the extraction, transformation, and load."

More Azure Data Factory pros

"The performance and scalability are awesome."

"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."

"It is a stable and scalable solution."

"One advantage is that if you already have an Oracle Database, it easily integrates with that."

"The product is easy to use."

"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."

"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."

"A very good integration feature that restricts access to unauthorized people."

More Oracle Autonomous Data Warehouse pros

Cons

"There is room for improvement primarily in its streaming capabilities. For structured streaming and machine learning model implementation within an ETL process, it lags behind tools like Informatica."

"A room for improvement in Azure Data Factory is its speed. Parallelization also needs improvement."

"It's a good idea to take a Microsoft course. Because they are really helpful when you start from your journey with Data Factory."

"Data Factory would be improved if it were a little more configuration-oriented and not so code-oriented and if it had more automated features."

"My only problem is the seamless connectivity with various other databases, for example, SAP."

"For some of the data, there were some issues with data mapping. Some of the error messages were a little bit foggy. There could be more of a quick start guide or some inline examples. The documentation could be better."

"The product integration with advanced coding options could cater to users needing more customization."

"There should be a way that it can do switches, so if at any point in time I want to do some hybrid mode of making any data collections or ingestions, I can just click on a button."

More Azure Data Factory cons

"Oracle Autonomous Data Warehouse is not available as an on-premises solution."

"I would like to see an on-premise solution in the future."

"The initial setup was pretty complex. It was not easy."

"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."

"The solution lacks visibility options."

"A lot of the tools that were previously there have now been taken away."

"An improvement for us would be the inclusion of support for an internal IP, so we could use it directly with the VCN in Oracle Cloud."

"There is a need for more storage to be allocated, but over a period of time, it becomes impossible to reduce it after using it."

More Oracle Autonomous Data Warehouse cons

Pricing and Cost Advice

"While I can't specify the actual cost, I believe it is reasonably priced and comparable to similar products."

"Understanding the pricing model for Data Factory is quite complex."

"Azure Data Factory gives better value for the price than other solutions such as Informatica."

"Pricing is comparable, it's somewhere in the middle."

"I would rate Data Factory's pricing nine out of ten."

"The licensing cost is included in the Synapse."

"There's no licensing for Azure Data Factory, they have a consumption payment model. How often you are running the service and how long that service takes to run. The price can be approximately $500 to $1,000 per month but depends on the scaling."

"The pricing is a bit on the higher end."

More Azure Data Factory pricing and cost advice

"You pay as you go, and you don't pay for services that you don't use."

"ROI is high."

"Oracle Autonomous Data Warehouse's pricing is fair and reasonable compared to the other cloud vendors."

"In terms of architecture and pricing structure, I feel it is a little bit costly compared to Azure. It's fine compared to RedShift, but compared to Azure, it's a bit pricey when you calculate for one TB storage plus around five hours of reporting with the frequency of 1TB data. The cost adds up, making Oracle a bit expensive."

"The solution is expensive."

"The price depends on the configuration we choose."

"The cost is perfect with Oracle Universal credit."

"The solution's cost is reasonable."

More Oracle Autonomous Data Warehouse pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.

See recommendations

816,406 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

13%

Computer Software Company

12%

Manufacturing Company

Healthcare Company

Educational Organization

49%

Financial Services Firm

Computer Software Company

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

How do you select the right cloud ETL tool?

AWS Glue and Azure Data factory for ELT best performance cloud services.

See all answers

How does Azure Data Factory compare with Informatica PowerCenter?

Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up an...

See all answers

How does Azure Data Factory compare with Informatica Cloud Data Integration?

Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Q...

See all answers

What do you like most about Oracle Autonomous Data Warehouse?

With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main...

See all answers

What is your experience regarding pricing and costs for Oracle Autonomous Data Warehouse?

The solution is expensive. I rate the price an eight out of ten.

See all answers

What needs improvement with Oracle Autonomous Data Warehouse?

The setup is complex. Oracle is a complex tool.

See all answers

Comparisons

Informatica PowerCenter vs Azure Data Factory

Compared 14% of the time

Snowflake vs Azure Data Factory

Compared 11% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs Azure Data Factory

Compared 8% of the time

Alteryx Designer vs Azure Data Factory

Compared 7% of the time

IBM InfoSphere DataStage vs Azure Data Factory

Compared 4% of the time

More Azure Data Factory Competitors

Snowflake vs Oracle Autonomous Data Warehouse

Compared 32% of the time

Oracle Exadata vs Oracle Autonomous Data Warehouse

Compared 21% of the time

Microsoft Azure Synapse Analytics vs Oracle Autonomous Data Warehouse

Compared 19% of the time

BigQuery vs Oracle Autonomous Data Warehouse

Compared 16% of the time

Dremio vs Oracle Autonomous Data Warehouse

Compared 2% of the time

More Oracle Autonomous Data Warehouse Competitors

Product Reports

Buyer's Guide

Azure Data Factory

November 2024

Download Azure Data Factory product report

Buyer's Guide

Oracle Autonomous Data Warehouse

November 2024

Download Oracle Autonomous Data Warehouse product report

Learn More

Microsoft

Oracle

Overview

Azure Data Factory efficiently manages and integrates data from various sources, enabling seamless movement and transformation across platforms. Its valuable features include seamless integration with Azure services, handling large data volumes, flexible transformation, user-friendly interface, extensive connectors, and scalability. Users have experienced improved team performance, workflow simplification, enhanced collaboration, streamlined processes, and boosted productivity.

Oracle Autonomous Data Warehouse is the world’s first and only autonomous database optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can rapidly, easily, and cost-effectively discover business insights using data of any size and type. Built for the cloud and optimized using Oracle Exadata, Autonomous Data Warehouse benefits from faster performance and, according to an IDC report (PDF), lowers operational costs by an average of 63%.

Autonomous Database provides the foundation for a data lakehouse—a modern, open architecture that enables you to store, analyze, and understand all your data. The data lakehouse combines the power and richness of data warehouses with the breadth, flexibility, and low cost of popular open source data lake technologies. Access your data lakehouse through Autonomous Database using the world's most powerful and open SQL processing engine.

Sample Customers

1. Adobe 2. BMW 3. Coca-Cola 4. General Electric 5. Johnson & Johnson 6. LinkedIn 7. Mastercard 8. Nestle 9. Pfizer 10. Samsung 11. Siemens 12. Toyota 13. Unilever 14. Verizon 15. Walmart 16. Accenture 17. American Express 18. AT&T 19. Bank of America 20. Cisco 21. Deloitte 22. ExxonMobil 23. Ford 24. General Motors 25. IBM 26. JPMorgan Chase 27. Microsoft (Azure Data Factory is developed by Microsoft) 28. Oracle 29. Procter & Gamble 30. Salesforce 31. Shell 32. Visa

Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank

Buyer's Guide

Azure Data Factory vs. Oracle Autonomous Data Warehouse

October 2024

Free Report: Azure Data Factory vs. Oracle Autonomous Data Warehouse

Find out what your peers are saying about Azure Data Factory vs. Oracle Autonomous Data Warehouse and other solutions. Updated: October 2024.

DOWNLOAD NOW

816,406 professionals have used our research since 2012.

See our Azure Data Factory vs. Oracle Autonomous Data 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.