What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
256 Ratings

SSIS

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
256 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100
61 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.4 out of 100

Feature Set Ratings

  • Talend Data Integration ranks higher in 4 feature sets: Data Source Connection, Data Transformations, Data Modeling, Data Governance

Data Source Connection

7.6

SSIS

76%
8.2

Talend Data Integration

82%
Talend Data Integration ranks higher in 2/2 features

Connect to traditional data sources

8.8
88%
56 Ratings
8.9
89%
9 Ratings

Connecto to Big Data and NoSQL

6.3
63%
43 Ratings
7.6
76%
8 Ratings

Data Transformations

8.3

SSIS

83%
8.9

Talend Data Integration

89%
Talend Data Integration ranks higher in 2/2 features

Simple transformations

8.8
88%
56 Ratings
8.9
89%
9 Ratings

Complex transformations

7.7
77%
55 Ratings
8.9
89%
9 Ratings

Data Modeling

7.7

SSIS

77%
7.8

Talend Data Integration

78%
Talend Data Integration ranks higher in 4/6 features

Data model creation

8.6
86%
30 Ratings
7.1
71%
8 Ratings

Metadata management

7.6
76%
36 Ratings
8.0
80%
8 Ratings

Business rules and workflow

7.8
78%
45 Ratings
8.9
89%
7 Ratings

Collaboration

7.5
75%
41 Ratings
5.2
52%
8 Ratings

Testing and debugging

6.7
67%
51 Ratings
8.8
88%
9 Ratings

feature 1

8.0
80%
5 Ratings
8.9
89%
2 Ratings

Data Governance

7.4

SSIS

74%
7.8

Talend Data Integration

78%
SQL Server Integration Services ranks higher in 1/2 features

Integration with data quality tools

7.8
78%
39 Ratings
7.5
75%
8 Ratings

Integration with MDM tools

6.9
69%
39 Ratings
8.0
80%
8 Ratings

Attribute Ratings

  • SQL Server Integration Services is rated higher in 2 areas: Usability, Support Rating
  • Talend Data Integration is rated higher in 1 area: Likelihood to Recommend

Likelihood to Recommend

8.2

SSIS

82%
56 Ratings
8.9

Talend Data Integration

89%
9 Ratings

Likelihood to Renew

10.0

SSIS

100%
3 Ratings

Talend Data Integration

N/A
0 Ratings

Usability

9.3

SSIS

93%
8 Ratings
9.0

Talend Data Integration

90%
1 Rating

Performance

8.8

SSIS

88%
12 Ratings

Talend Data Integration

N/A
0 Ratings

Support Rating

8.2

SSIS

82%
14 Ratings
5.5

Talend Data Integration

55%
6 Ratings

Implementation Rating

10.0

SSIS

100%
2 Ratings

Talend Data Integration

N/A
0 Ratings

Likelihood to Recommend

Microsoft

I highly recommend this product. It has streamlined most business processes by providing useful tools that make work easier. The well-featured dashboard provides graphical integration services that have enhanced faster task and project implementation since it does not require coding. It has transformed data that could lead to poor performance into useful insights for generating new ideas for boosting business performance.
Read full review

Talend

The same way you design data integration job can be used to design services. It is easy to enhance by custom components and can adapt to all requirements. Talend Data Integration connects to [a] multitude of data sources and streaming service. Very easy interface to design complex applications without spending much time on coding. Easy to learn and master. Talend constantly strives to better itself by adding more features and functionalities.
Read full review

Pros

Microsoft

  • Server Integration Services for SQL Server With the right planning of dataflows, we may aggregate information from many different sources.
  • The solution's package structure allows us to isolate individual functions while reusing the same set of settings everywhere else.
  • The capacity to test solutions in a variety of settings with varying inputs is a potent resource that facilitates the development of solutions that can be reused.
Read full review

Talend

  • The speed of migration is very good for a Free ETL tool.
  • The amount of components or connectors we have is impressive.
Read full review

Cons

Microsoft

  • API connections are not a native functionality. We use Zappysys extensions but they work only in certain cases.
  • Dependency executions - no simple way to create a hierarchy/chain of executions. Ex: Define if the execution of the child process should be stopped if a parent fails or a certain condition is triggered in the parent process and then redirect to a different part of the chain (think like a flowchart for executions).
Read full review

Talend

  • Syncing with Git should be made easier
  • Can face issues with certain big data spaces
  • Support find it difficult to resolve complex issues
Read full review

Pricing Details

SSIS

Starting Price

Editions & Modules

SSIS editions and modules pricing
EditionModules

Footnotes

    Offerings

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services

    Entry-level set up fee?

    No setup fee

    Additional Details

    Talend Data Integration

    Starting Price

    Editions & Modules

    Talend Data Integration editions and modules pricing
    EditionModules

    Footnotes

      Offerings

      Free Trial
      Free/Freemium Version
      Premium Consulting/Integration Services

      Entry-level set up fee?

      No setup fee

      Additional Details

      Likelihood to Renew

      Microsoft

      SSIS is responsible for running core business processed managing core business data. It can be managed, improved and expanded using minimal internal resources. It is also able to support all of our current data infrastructure. Replacing SSIS would be time consuming and costly with no apparent ROI.
      Read full review

      Talend

      No answers on this topic

      Usability

      Microsoft

      SSIS is a great tool for most ETL needs. It has the 90% (or more) use cases covered and even in many of the use cases where it is not ideal SSIS can be extended via a .NET language to do the job well in a supportable way for almost any performance workload.
      Read full review

      Talend

      We use Talend Data Integration day in and day out. It is the best and easiest tool to jump on to and use. We can build a basic integration super-fast. We could build basic integrations as fast as within the hour. It is also easy to build transformations and use Java to perform some operations.
      Read full review

      Performance

      Microsoft

      SQL Server Integration Services performance is dependent directly upon the resources provided to the system. In our environment, we allocated 6 nodes of 4 CPUs, 64GB each, running in parallel. Unfortunately, we had to ramp-up to such a robust environment to get the performance to where we needed it. Most of the reports are completed in a reasonable timeframe. However, in the case of slow running reports, it is often difficult if not impossible to cancel the report without killing the report instance or stopping the service.
      Read full review

      Talend

      No answers on this topic

      Support Rating

      Microsoft

      The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.
      Read full review

      Talend

      Good support, specially when it relates to PROD environment. The support team has access to the product development team. Things are internally escalated to development team if there is a bug encountered. This helps the customer to get quick fix or patch designed for problem exceptions. I have also seen support showing their willingness to help develop custom connector for a newly available cloud based big data solution
      Read full review

      Implementation Rating

      Microsoft

      The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools
      Read full review

      Talend

      No answers on this topic

      Alternatives Considered

      Microsoft

      I had nothing to do with the choice or install. I assume it was made because it's easy to integrate with our SQL Server environment and free. I'm not sure of any other enterprise level solution that would solve this problem, but I would likely have approached it with traditional scripting. Comparably free, but my own familiarity with trad scripts would be my final deciding factor. Perhaps with some further training on SSIS I would have a different answer.
      Read full review

      Talend

      Talend is much versatile in assimilating various different business use cases. It covers more functionality and is packed with tons of features to explore. It has the ability to fine tune to each project, and not be a one-fits all solution. Problems with Excel, is that it is not suited for large projects, collaboration work. Alteryx is a very costly alternative.
      Read full review

      Return on Investment

      Microsoft

      • Data integrity across various products allows unify certain processes inside the organization and save funds by reducing human labour factor.
      • Automated data unification allows us plan our inputs better and reduce over-warehousing by overbuying
      • The employee number, responsible for data management was reduced from 4 to 1 person
      Read full review

      Talend

      • Easy to build complex data transformations.
      • Licensing model isn't that flexible.
      • Memory mangement for huge volumes of information. You have to modify ETL designs to handle it properly.
      Read full review

      Add comparison