TrustRadius: an HG Insights company

Azure Data Factory vs. Azure Synapse Analytics

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

    Azure Synapse Analytics

    Score6.9 out of 10
    N/AAzure Synapse Analytics is described as the former Azure SQL Data Warehouse, evolved, and as a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives users the freedom to query data using either serverless or provisioned resources, at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.

    $4,700

    per month 5000 Synapse Commit Units (SCUs)

    Pricing
    Azure Data FactoryAzure Synapse Analytics
    Editions & Modules
    No answers on this topic
    Tier 1
    $4,700
    per month 5,000 Synapse Commit Units (SCUs)
    Tier 2
    $9,200
    per month 10,000 Synapse Commit Units (SCUs)
    Tier 3
    $21,360
    per month 24,000 Synapse Commit Units (SCUs)
    Tier 4
    $50,400
    per month 60,000 Synapse Commit Units (SCUs)
    Tier 5
    $117,000
    per month 150,000 Synapse Commit Units (SCUs)
    Tier 6
    $259,200
    per month 360,000 Synapse Commit Units (SCUs)
    Offerings
    Pricing Offerings
    Azure Data FactoryAzure Synapse Analytics
    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 FactoryAzure Synapse Analytics
    Considered Both Products
    Microsoft
    Chose Azure Data Factory
    Easier UI, Pipelines & Dataflows with various different sources.
    Incentivized
    Microsoft
    Chose Azure Synapse Analytics
    They're all part of the Microsoft Azure family, so they are not exactly competitors. They overlap in functionality, but they're targeted at different levels of customers.
    Azure Data Factory is an excellent stand-alone PaaS (included in Synapse Analytics) for writing, scheduling, …
    Incentivized
    Chose Azure Synapse Analytics
    When client is already having or using Azure then it’s wise to go with Synapse rather than using Snowflake. We got a lot of help from Microsoft consultants and Microsoft partners while implementing our EDW via Synapse and support is easily available via Microsoft resources and …
    Incentivized
    Chose Azure Synapse Analytics
    Synapse, in comparison has its ups and downs against the competitors. However, where it excels, and builds it's markets is the cheaper costs (compared to Redshift), low code platforms and an in house solution that does not need you to leave the Synapse workspace for end to end …
    Incentivized
    Key User Insights
    Would buy again
    No answers on this topic
    No answers on this topic
    Delivers good value for the price
    No answers on this topic
    No answers on this topic
    Happy with the feature set
    No answers on this topic
    No answers on this topic
    Lived up to sales and marketing promises
    No answers on this topic
    No answers on this topic
    Implementation went as expected
    No answers on this topic
    No answers on this topic
    Features
    Azure Data FactoryAzure Synapse Analytics
    Data Source Connection
    Comparison of Data Source Connection features of Azure Data Factory and Azure Synapse Analytics
    Feature
    Azure Data Factory
    9.0
    7 Ratings
    Azure Synapse Analytics
    -
    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 Azure Synapse Analytics
    Feature
    Azure Data Factory
    8.5
    7 Ratings
    Azure Synapse Analytics
    -
    Ratings
    Simple transformations9.07 Ratings00 Ratings
    Complex transformations8.07 Ratings00 Ratings
    Data Modeling
    Comparison of Data Modeling features of Azure Data Factory and Azure Synapse Analytics
    Feature
    Azure Data Factory
    7.2
    7 Ratings
    Azure Synapse Analytics
    -
    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 Azure Synapse Analytics
    Feature
    Azure Data Factory
    7.5
    7 Ratings
    Azure Synapse Analytics
    -
    Ratings
    Integration with data quality tools7.07 Ratings00 Ratings
    Integration with MDM tools8.07 Ratings00 Ratings
    User Ratings
    Azure Data FactoryAzure Synapse Analytics
    Likelihood to Recommend
    9.0
    (7 ratings)
    8.1
    (9 ratings)
    Usability
    -
    (0 ratings)
    9.6
    (2 ratings)
    Support Rating
    7.0
    (1 ratings)
    9.6
    (2 ratings)
    Contract Terms and Pricing Model
    -
    (0 ratings)
    10.0
    (1 ratings)