Azure Data Factory vs IBM Db2 Warehouse comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
8,287 views|6,470 comparisons
91% willing to recommend
IBM Logo
973 views|521 comparisons
71% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Azure Data Factory and IBM Db2 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. IBM Db2 Warehouse Report (Updated: March 2024).
768,886 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"Powerful but easy-to-use and intuitive.""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.""This solution has provided us with an easier, and more efficient way to carry out data migration tasks.""The trigger scheduling options are decently robust.""I am one hundred percent happy with the stability.""The best part of this product is the extraction, transformation, and load.""It makes it easy to collect data from different sources.""I like the basic features like the data-based pipelines."

More Azure Data Factory Pros →

"The analytics engine is not bad at forecasting predictions.""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.""The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data.""Some of the best features are stored procedures, parallelism, and different indexing strategies.""Provides good security and reliability.""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."

More IBM Db2 Warehouse Pros →

Cons
"Azure Data Factory could benefit from improvements in its monitoring capabilities to provide a more robust feature set. Enhancing the ease of deployment to higher environments within Azure DevOps would be beneficial, as the current process often requires extensive scripting and pipeline development. It is also known for the flexibility of the data flow feature, particularly in supporting more dynamic data-driven architectures. These enhancements would contribute to a more seamless and efficient workflow within GitLab.""The solution needs to be more connectable to its own services.""The support and the documentation can be improved.""The tool’s workflow is not user-friendly. It should also improve its orchestration monitoring.""The product's technical support has certain shortcomings, making it an area where improvements are required.""Azure Data Factory can improve by having support in the drivers for change data capture.""Sometimes I need to do some coding, and I'd like to avoid that. I'd like no-code integrations.""The solution should offer better integration with Azure machine learning. We should be able to embed the cognitive services from Microsoft, for example as a web API. It should allow us to embed Azure machine learning in a more user-friendly way."

More Azure Data Factory Cons →

"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.""IBM Db2 Warehouse needs to improve its interface.""Lacks sufficient documentation and particularly in Spanish.""The biggest challenge anyone could have with Db2 Warehouse is their references or online resources and documentation. They are very, very, very limited on the web.""There should be more material available for training and training should be free.""The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."

More IBM Db2 Warehouse Cons →

Pricing and Cost Advice
  • "In terms of licensing costs, we pay somewhere around S14,000 USD per month. There are some additional costs. For example, we would have to subscribe to some additional computing and for elasticity, but they are minimal."
  • "This is a cost-effective solution."
  • "The price you pay is determined by how much you use it."
  • "Understanding the pricing model for Data Factory is quite complex."
  • "I would not say that this product is overly expensive."
  • "The licensing is a pay-as-you-go model, where you pay for what you consume."
  • "Our licensing fees are approximately 15,000 ($150 USD) per month."
  • "The licensing cost is included in the Synapse."
  • More Azure Data Factory Pricing and Cost Advice →

  • "In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."
  • More IBM Db2 Warehouse Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    768,886 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:AWS Glue and Azure Data factory for ELT best performance cloud services.
    Top Answer: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 and… more »
    Top Answer: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… more »
    Top Answer:The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data.
    Top Answer:Db2 is a very expensive database. In comparison to Oracle, for example, where the cost depends on the size of the implementation. For an enterprise database, the cost is mid-range.
    Top Answer:IBM Db2 Warehouse needs to improve its interface.
    Ranking
    3rd
    Views
    8,287
    Comparisons
    6,470
    Reviews
    46
    Average Words per Review
    489
    Rating
    8.0
    14th
    out of 34 in Data Warehouse
    Views
    973
    Comparisons
    521
    Reviews
    3
    Average Words per Review
    363
    Rating
    7.3
    Comparisons
    Also Known As
    InfoSphere Warehouse, IBM InfoSphere Warehouse
    Learn More
    IBM
    Video Not Available
    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.

    InfoSphere Warehouse is a suite of products that combines the strength of DB2 with a data warehousing infrastructure from IBM. You can use InfoSphere Warehouse to build a complete data warehousing solution that includes a highly scalable relational database, data access capabilities, and front-end analysis tools.
    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
    Top Industries
    REVIEWERS
    Computer Software Company34%
    Insurance Company11%
    Manufacturing Company8%
    Financial Services Firm8%
    VISITORS READING REVIEWS
    Computer Software Company13%
    Financial Services Firm13%
    Manufacturing Company8%
    Healthcare Company7%
    VISITORS READING REVIEWS
    Educational Organization52%
    Financial Services Firm9%
    Computer Software Company7%
    Insurance Company4%
    Company Size
    REVIEWERS
    Small Business29%
    Midsize Enterprise19%
    Large Enterprise52%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise70%
    REVIEWERS
    Small Business44%
    Midsize Enterprise11%
    Large Enterprise44%
    VISITORS READING REVIEWS
    Small Business9%
    Midsize Enterprise54%
    Large Enterprise37%
    Buyer's Guide
    Azure Data Factory vs. IBM Db2 Warehouse
    March 2024
    Find out what your peers are saying about Azure Data Factory vs. IBM Db2 Warehouse and other solutions. Updated: March 2024.
    768,886 professionals have used our research since 2012.

    Azure Data Factory is ranked 3rd in Cloud Data Warehouse with 81 reviews while IBM Db2 Warehouse is ranked 14th in Data Warehouse with 8 reviews. Azure Data Factory is rated 8.0, while IBM Db2 Warehouse is rated 7.6. 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 IBM Db2 Warehouse writes "Useful for ETL process and has good documentation ". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and Microsoft Azure Synapse Analytics, whereas IBM Db2 Warehouse is most compared with Oracle Exadata, Snowflake, Amazon Redshift, Apache Hadoop and IBM Netezza Performance Server. See our Azure Data Factory vs. IBM Db2 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.