Try our new research platform with insights from 80,000+ expert users

Azure Data Factory vs IBM Db2 Warehouse comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Categories and Ranking

Azure Data Factory
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
90
Ranking in other categories
Data Integration (1st), Cloud Data Warehouse (3rd)
IBM Db2 Warehouse
Average Rating
7.8
Reviews Sentiment
6.6
Number of Reviews
11
Ranking in other categories
Data Warehouse (12th)
 

Featured Reviews

Joy Maitra - PeerSpot reviewer
Facilitates seamless data pipeline creation with good analytics and and thorough monitoring
Azure Data Factory is a low code, no code platform, which is helpful. It provides many prebuilt functionalities that assist in building data pipelines. Also, it facilitates easy transformation with all required functionalities for analytics. Furthermore, it connects to different sources out-of-the-box, making integration much easier. The monitoring is very thorough, though a more readable version would be appreciable.
Ismail Aboulezz - PeerSpot reviewer
Enhancements in data analysis and decision-making elevate overall performance
The most valuable features of IBM Db2 Warehouse ( /products/ibm-db2-warehouse-reviews ) include its availability, easy integration, ability to deal with a large size of data, excellent performance with no delays, powerful security mechanisms, and effective support. The response time is very quick, and the technical manuals and support from IBM are of high quality. Additionally, it is easy to install, troubleshoot, operate, and secure the environment.

Quotes from Members

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

Pros

"The function of the solution is great."
"The most valuable features of the solution are its ease of use and the readily available adapters for connecting with various sources."
"It is beneficial that the solution is written with Spark as the back end."
"UI is easy to navigate and I can retrieve VTL code without knowing in-depth coding languages."
"The scalability of the product is impressive."
"I am one hundred percent happy with the stability."
"The interface of Azure Data Factory is very usable with a more interactive visual experience, making it easier for people who are not as experienced in coding to work with."
"The two most valuable features of Azure Data Factory are that it's very scalable and that it's also highly reliable."
"It can scale effectively as long as resources are available."
"The analytics engine is not bad at forecasting predictions."
"It can be mounted on the cloud, which is a huge plus. If the client, for example, starts small with on-premise deployment and then it rapidly needs to grow, we can transfer this to the cloud easily."
"The most valuable features of IBM Db2 Warehouse include its availability, easy integration, ability to deal with a large size of data, excellent performance with no delays, powerful security mechanisms, and effective support."
"The solution is stable."
"I think it scales really well and as long as you take enough time to learn a little bit about it, it works really well."
"Provides good security and reliability."
"Some of the best features are stored procedures, parallelism, and different indexing strategies."
 

Cons

"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 Microsoft documentation is too complicated."
"The pricing scheme is very complex and difficult to understand."
"It does not appear to be as rich as other ETL tools. It has very limited capabilities."
"The product could provide more ways to import and export data."
"Currently, our company requires a monitoring tool, and that isn't available in Azure Data Factory."
"Customer service is not satisfactory. Third-party personnel handle support and rely on a knowledge repository."
"The initial setup is not very straightforward."
"Lacks sufficient documentation and particularly in Spanish."
"In terms of improvement, IBM Db2 Warehouse should be more scalable."
"The biggest problems we have is when the backup solution is failing or slow and we run out of log space, which has happened probably a couple of times in the last four years."
"It takes a long time to have a new version or release, similar to Oracle."
"There were some initial challenges with IBM Db2 Warehouse about eight months ago when I worked in this environment. When I coordinated with IBM support, they mentioned that the memory was insufficient for our needs. Our business environment required significantly more memory than the previous cluster could provide. Consequently, we have worked closely with on-site IBM technical personnel to address this issue."
"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."
"There should be more material available for training and training should be free."
"IBM Db2 Warehouse needs to improve its interface."
 

Pricing and Cost Advice

"For our use case, it is not expensive. We take into the picture everything: resources, learning curve, and maintenance."
"The solution's fees are based on a pay-per-minute use plus the amount of data required to process."
"While I can't specify the actual cost, I believe it is reasonably priced and comparable to similar products."
"I don't see a cost; it appears to be included in general support."
"Pricing appears to be reasonable in my opinion."
"Azure Data Factory gives better value for the price than other solutions such as Informatica."
"The cost is based on the amount of data sets that we are ingesting."
"ADF is cheaper compared to AWS."
"In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
846,617 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
14%
Computer Software Company
12%
Manufacturing Company
9%
Healthcare Company
6%
Educational Organization
58%
Financial Services Firm
10%
Computer Software Company
5%
Government
5%
 

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.
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...
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...
What do you like most about IBM Db2 Warehouse?
The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data.
What is your experience regarding pricing and costs for IBM Db2 Warehouse?
Db2 Warehouse or IBM products are pretty expensive. There are cheaper tools on the market. However, if the client is satisfied with paying for the Db2 Warehouse license, especially for cloud-based ...
What needs improvement with IBM Db2 Warehouse?
Responding to support tickets takes a lot of time. It can range from two to four days, even for critical issues. The technical support quality is good, but the response time needs improvement.
 

Also Known As

No data available
InfoSphere Warehouse, IBM InfoSphere Warehouse
 

Overview

 

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
Alameda County Social Services Agency, Sui Southern Gas Company Limited
Find out what your peers are saying about Azure Data Factory vs. IBM Db2 Warehouse and other solutions. Updated: March 2025.
846,617 professionals have used our research since 2012.