TrustRadius: an HG Insights company

SQL Server Integration Services vs. Talend Open Studio

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    SSIS

    Score6.5 out of 10
    N/AMicrosoft's SQL Server Integration Services (SSIS) is a data integration solution.N/A

    Talend Open Studio

    Score9 out of 10
    N/ATalend Open Studio is an open source integration software, used to build basic data pipelines or execute simple ETL and data integration tasks, get graphical profiles of data, and manage files from a locally installed, open-source environment.

    $0

    per month

    Pricing
    SSISTalend Open Studio
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    SSISTalend Open Studio
    Free Trial
    NoNo
    Free/Freemium Version
    NoYes
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    SSISTalend Open Studio
    Considered Both Products
    Microsoft
    Chose SSIS
    SSIS is a very basic, developer-oriented ETL tool and while it lacks many of the nice UX features of its competitors it is a powerful tool that comes as a part of SQL Server and, in the hands of experienced developers with domain knowledge, can meet most organizations' ETL …
    Incentivized
    Chose SSIS
    SSIS has these advantages: simple integration with MS technologies including Access, Excel, SQL RDBMS, Job Scheduler, and is included with SQL Server.

    Talend has these advantages: much quicker development time, 800+ built in components which provides off the shelf integration …
    Incentivized
    Qlik
    Chose Talend Open Studio
    SSIS is a great tool in itself and more easier. But, debugging is better done in Talend.
    Incentivized
    Chose Talend Open Studio
    I prefer to use Talend Open Studio over SQL Server Integration Services because of the ease of use and wider connection library opportunities. By leveraging Talend Open Studio we are able to connect to a much wider set of source data as well as rapidly designing and deploying …
    Incentivized
    Chose Talend Open Studio
    In terms of systems integration and ETL I have used SQL Server SSIS, SQL Server (Jobs, BCP, Procs, XP_CmdShell, etc.) and custom code using Microsoft .NET. While certain other technologies do have their place, in this realm Talend is consistently the better tool. It is a much …
    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
    SSISTalend Open Studio
    Data Source Connection
    Comparison of Data Source Connection features of SQL Server Integration Services and Talend Open Studio
    Feature
    SQL Server Integration Services
    7.5
    53 Ratings
    Talend Open Studio
    7.5
    10 Ratings
    Connect to traditional data sources8.853 Ratings7.010 Ratings
    Connecto to Big Data and NoSQL6.240 Ratings7.99 Ratings
    Data Transformations
    Comparison of Data Transformations features of SQL Server Integration Services and Talend Open Studio
    Feature
    SQL Server Integration Services
    8.1
    53 Ratings
    Talend Open Studio
    7.0
    10 Ratings
    Simple transformations8.553 Ratings6.010 Ratings
    Complex transformations7.752 Ratings7.910 Ratings
    Data Modeling
    Comparison of Data Modeling features of SQL Server Integration Services and Talend Open Studio
    Feature
    SQL Server Integration Services
    7.4
    51 Ratings
    Talend Open Studio
    7.5
    10 Ratings
    Data model creation8.627 Ratings6.99 Ratings
    Metadata management7.133 Ratings7.99 Ratings
    Business rules and workflow8.242 Ratings6.98 Ratings
    Collaboration7.338 Ratings7.07 Ratings
    Testing and debugging6.148 Ratings8.910 Ratings
    Data Governance
    Comparison of Data Governance features of SQL Server Integration Services and Talend Open Studio
    Feature
    SQL Server Integration Services
    6.9
    41 Ratings
    Talend Open Studio
    6.5
    7 Ratings
    Integration with data quality tools7.436 Ratings6.06 Ratings
    Integration with MDM tools6.436 Ratings7.07 Ratings
    User Ratings
    SSISTalend Open Studio
    Likelihood to Recommend
    8.0
    (53 ratings)
    7.9
    (11 ratings)
    Likelihood to Renew
    10.0
    (3 ratings)
    10.0
    (1 ratings)
    Usability
    9.3
    (8 ratings)
    3.0
    (1 ratings)
    Performance
    8.8
    (6 ratings)
    4.0
    (1 ratings)
    Support Rating
    8.2
    (7 ratings)
    4.9
    (3 ratings)
    Implementation Rating
    10.0
    (1 ratings)
    -
    (0 ratings)