TrustRadius: an HG Insights company

dbt vs. SQL Server Integration Services

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    dbt

    Score9 out of 10
    N/Adbt is an SQL development environment, developed by Fishtown Analytics, now known as dbt Labs. The vendor states that with dbt, analysts take ownership of the entire analytics engineering workflow, from writing data transformation code to deployment and documentation. dbt Core is distributed under the Apache 2.0 license, and paid Teams and Enterprise editions are available.

    $0

    per month per seat

    SSIS

    Score6.5 out of 10
    N/AMicrosoft's SQL Server Integration Services (SSIS) is a data integration solution.N/A
    Pricing
    dbtSSIS
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    dbtSSIS
    Free Trial
    YesNo
    Free/Freemium Version
    YesNo
    Premium Consulting/Integration Services
    YesNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    dbtSSIS
    Considered Both Products
    dbt Labs
    Chose dbt
    dbt fits much better in our stack, where we're using specialized tools to support our ELT approach.
    Incentivized
    Microsoft
    No answer on this topic
    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
    dbtSSIS
    Data Transformations
    Comparison of Data Transformations features of dbt and SQL Server Integration Services
    Feature
    dbt
    9.5
    7 Ratings
    SQL Server Integration Services
    8.1
    53 Ratings
    Simple transformations10.07 Ratings8.553 Ratings
    Complex transformations9.07 Ratings7.752 Ratings
    Data Modeling
    Comparison of Data Modeling features of dbt and SQL Server Integration Services
    Feature
    dbt
    9.0
    7 Ratings
    SQL Server Integration Services
    7.4
    51 Ratings
    Data model creation9.57 Ratings8.627 Ratings
    Metadata management8.57 Ratings7.133 Ratings
    Business rules and workflow9.07 Ratings8.242 Ratings
    Collaboration10.05 Ratings7.338 Ratings
    Testing and debugging8.07 Ratings6.148 Ratings
    Data Source Connection
    Comparison of Data Source Connection features of dbt and SQL Server Integration Services
    Feature
    dbt
    -
    Ratings
    SQL Server Integration Services
    7.5
    53 Ratings
    Connect to traditional data sources00 Ratings8.853 Ratings
    Connecto to Big Data and NoSQL00 Ratings6.240 Ratings
    Data Governance
    Comparison of Data Governance features of dbt and SQL Server Integration Services
    Feature
    dbt
    -
    Ratings
    SQL Server Integration Services
    6.9
    41 Ratings
    Integration with data quality tools00 Ratings7.436 Ratings
    Integration with MDM tools00 Ratings6.436 Ratings
    User Ratings
    dbtSSIS
    Likelihood to Recommend
    10.0
    (9 ratings)
    8.0
    (53 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    10.0
    (3 ratings)
    Usability
    9.5
    (2 ratings)
    9.3
    (8 ratings)
    Performance
    -
    (0 ratings)
    8.8
    (6 ratings)
    Support Rating
    -
    (0 ratings)
    8.2
    (7 ratings)
    Implementation Rating
    -
    (0 ratings)
    10.0
    (1 ratings)