TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Azure Data Factory

    Score8.9 out of 10
    N/AMicrosoft'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

    IBM Cloud Pak for Data

    Score8.5 out of 10
    N/AIBM Cloud Pak for Data (formerly IBM Cloud Private for Data) provides data management, data governance, and automated data discovery and classification.N/A
    Pricing
    Azure Data FactoryIBM Cloud Pak for Data
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Azure Data FactoryIBM Cloud Pak for Data
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    Azure Data FactoryIBM Cloud Pak for Data
    Considered Both Products
    Microsoft
    No answer on this topic
    IBM
    No answer on this topic
    Key User Insights
    Would buy again
    100%
    Would buy again
    7 Answers
    100%
    Would buy again
    9 Answers
    Delivers good value for the price
    100%
    Delivers good value for the price
    7 Answers
    100%
    Delivers good value for the price
    9 Answers
    Happy with the feature set
    86%
    Happy with the feature set
    6 Answers
    100%
    Happy with the feature set
    9 Answers
    Lived up to sales and marketing promises
    86%
    Lived up to sales and marketing promises
    6 Answers
    100%
    Lived up to sales and marketing promises
    6 Answers
    Implementation went as expected
    100%
    Implementation went as expected
    7 Answers
    100%
    Implementation went as expected
    7 Answers
    Features
    Azure Data FactoryIBM Cloud Pak for Data
    Data Source Connection
    Comparison of Data Source Connection features of Azure Data Factory and IBM Cloud Pak for Data
    Feature
    Azure Data Factory
    9.0
    7 Ratings
    7% above category average
    IBM Cloud Pak for Data
    -
    Ratings
    Connect to traditional data sources9.07 Ratings00 Ratings
    Connecto to Big Data and NoSQL9.07 Ratings00 Ratings
    Data Transformations
    Comparison of Data Transformations features of Azure Data Factory and IBM Cloud Pak for Data
    Feature
    Azure Data Factory
    8.5
    7 Ratings
    4% above category average
    IBM Cloud Pak for Data
    -
    Ratings
    Simple transformations9.07 Ratings00 Ratings
    Complex transformations8.07 Ratings00 Ratings
    Data Modeling
    Comparison of Data Modeling features of Azure Data Factory and IBM Cloud Pak for Data
    Feature
    Azure Data Factory
    7.2
    7 Ratings
    10% below category average
    IBM Cloud Pak for Data
    -
    Ratings
    Data model creation8.05 Ratings00 Ratings
    Metadata management7.06 Ratings00 Ratings
    Business rules and workflow7.07 Ratings00 Ratings
    Collaboration6.06 Ratings00 Ratings
    Testing and debugging7.07 Ratings00 Ratings
    Data Governance
    Comparison of Data Governance features of Azure Data Factory and IBM Cloud Pak for Data
    Feature
    Azure Data Factory
    7.5
    7 Ratings
    8% below category average
    IBM Cloud Pak for Data
    -
    Ratings
    Integration with data quality tools7.07 Ratings00 Ratings
    Integration with MDM tools8.07 Ratings00 Ratings
    Best Alternatives
    Azure Data FactoryIBM Cloud Pak for Data
    Small Businesses
    Skyvia
    Score9.9 out of 10
    No answers on this topic
    Medium-sized Companies
    IBM InfoSphere Information Server
    Score8 out of 10
    ER/Studio Data Architect
    Score9.9 out of 10
    Enterprises
    SolarWinds Task Factory
    Score8.2 out of 10
    ER/Studio Data Architect
    Score9.9 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Azure Data FactoryIBM Cloud Pak for Data
    Likelihood to Recommend
    9.0
    (7 ratings)
    9.9
    (13 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    9.1
    (2 ratings)
    Support Rating
    7.0
    (1 ratings)
    -
    (0 ratings)
    User Testimonials
    Azure Data FactoryIBM Cloud Pak for Data
    Likelihood to Recommend
    Microsoft
    Well-suited Scenarios for Azure Data Factory (ADF): When an organization has data sources spread across on-premises databases and cloud storage solutions, I think Azure Data Factory is excellent for integrating these sources. Azure Data Factory's integration with Azure Databricks allows it to handle large-scale data transformations effectively, leveraging the power of distributed processing. For regular ETL or ELT processes that need to run at specific intervals (daily, weekly, etc.), I think Azure Data Factory's scheduling capabilities are very handy. Less Appropriate Scenarios for Azure Data Factory: Real-time Data Streaming - Azure Data Factory is primarily batch-oriented. Simple Data Copy Tasks - For straightforward data copy tasks without the need for transformation or complex workflows, in my opinion, using Azure Data Factory might be overkill; simpler tools or scripts could suffice. Advanced Data Science Workflows: While Azure Data Factory can handle data prep and transformation, in my experience, it's not designed for in-depth data science tasks. I think for advanced analytics, machine learning, or statistical modeling, integration with specialized tools would be necessary.
    Incentivized
    Read full review
    IBM
    IBM Cloud Pak for Data with Netezza is well suited for clients who require fast, economical analytics processing. It is not designed to be used as a transactional processing environment. For example, a large customer is using it during the point of sale process. That makes little sense in that business case. However, to take analysis to market faster, it excels well in that space.
    Incentivized
    Read full review
    Pros
    Microsoft
    • It allows copying data from various types of data sources like on-premise files, Azure Database, Excel, JSON, Azure Synapse, API, etc. to the desired destination.
    • We can use linked service in multiple pipeline/data load.
    • It also allows the running of SSIS & SSMS packages which makes it an easy-to-use ETL & ELT tool.
    Incentivized
    Read full review
    IBM
    • Increases our impact by combining BI skills with advanced analytics and machine learning in an easy to use visual interface.
    • Visualization and reporting.
    • Rapidly provides business -ready data to all users equally.
    • Manage data spread across distributed stores and clouds.
    Incentivized
    Read full review
    Cons
    Microsoft
    • 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.
    Incentivized
    Read full review
    IBM
    • Cannot save changes to some secrets in the internal vault
    • Sign-in issues on environments where IAM is enabled
    • The Enforce quotas option is disabled
    Incentivized
    Read full review
    Usability
    Microsoft
    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.
    Incentivized
    Read full review
    IBM
    No answers on this topic
    Support Rating
    Microsoft
    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
    Incentivized
    Read full review
    IBM
    No answers on this topic
    Alternatives Considered
    Microsoft
    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.
    Incentivized
    Read full review
    IBM
    IBM Cloud Pak for Data takes the IBM Cognos solution and provides this on an enterprise cloud platform that can be extended to support better data integration and data science capabilities.
    Incentivized
    Read full review
    Return on Investment
    Microsoft
    • It is very useful and make things easier
    • Debugging can improve
    • Its better suited than other products with the same objective
    Incentivized
    Read full review
    IBM
    • We have the ability to access all our data much quicker through the unified search option.
    • 30% increase in productivity through the introduction of AI.
    • Improved data security and governance.
    Incentivized
    Read full review
    ScreenShots