What users are saying about

SSIS

155 Ratings

Anypoint Platform

32 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.8 out of 101

SSIS

155 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.9 out of 101

Add comparison

Likelihood to Recommend

Anypoint Platform

I'm using Mulesoft platform as pure ESB and not for back end features and is more flexible than other platforms. It enables the company to develop very complex integration architecture in few months, being able to modify or scale it in few steps, with not-so-expert developers and not-so-detailed technical documentation.
Federica Bianco profile photo

SSIS

If you need to move data around or direct the workflow of a process, SSIS can do it. It is a very capable piece of software that I use heavily every day. You do need to be careful because you can over-utilize it for simple things. If you just need to run a piece of SQL every hour to update some values, just use the Agent Scheduler, it's easier. But if you need to automate things in a repeatable and consistent manner, SSIS is a very good product.
Greg Goss profile photo

Feature Rating Comparison

Data Source Connection

Anypoint Platform
SSIS
8.2
Connect to traditional data sources
Anypoint Platform
SSIS
9.1
Connecto to Big Data and NoSQL
Anypoint Platform
SSIS
7.3

Data Transformations

Anypoint Platform
SSIS
8.8
Simple transformations
Anypoint Platform
SSIS
9.4
Complex transformations
Anypoint Platform
SSIS
8.1

Data Modeling

Anypoint Platform
SSIS
7.4
Data model creation
Anypoint Platform
SSIS
7.1
Metadata management
Anypoint Platform
SSIS
6.6
Business rules and workflow
Anypoint Platform
SSIS
8.4
Collaboration
Anypoint Platform
SSIS
6.9
Testing and debugging
Anypoint Platform
SSIS
7.8

Data Governance

Anypoint Platform
SSIS
7.7
Integration with data quality tools
Anypoint Platform
SSIS
7.7
Integration with MDM tools
Anypoint Platform
SSIS
7.7

Pros

  • It enables developer to write complex orchestration flows through a drag & drop dashboard.
  • It enables to interact with other platform via web and/or REST services.
  • It enables you to deploy application on cloud in an easy and smart way.
Federica Bianco profile photo
  • Logging, this is essential when you do ETL. With SSIS you can run the package and see step by step the progress, how many tuples complied with the filters, like how many went left and how many were correct, or excluded.
  • Using regular expressions with C# direct code by adding Script Components it's easier with SSIS
  • https://sqldusty.com/2011/11/06/data-cleansing-with-regular-expressions-in-ssis/
  • https://www.linkedin.com/pulse/using-regular-expression-file-filter-ssis-sean-werick/
  • Performance, it is difficult to demand good SQL code to every member of the BI team not everyone is specialized in T-SQL.
  • SSIS standardizes a bit more the code and allows users not completely familiar with SQL or even C# to achieve what they needed, the package still needs to go through a code review but it is quite easier to understand.
Jose Pla profile photo

Cons

  • In dataweave mapping you have to be sure to map fields inserting right names. There is not provided a control mechanism for verifying it
  • It is not easy to structure a process hierarchy because you have to develop flows and sub flows in the same xml configuration files.
  • I would like to interact with Mulesoft support directly from the design environment.
Federica Bianco profile photo
  • Be careful when you edit a package, if the version is above the SSMS you are using then it will not be compatible. You have to compile or edit the SSIS package in the same version of SSMS you are using.
  • To explain it a bit better if you have SQL 2014 in your laptop, pull a package for the DB server which is running SQL 2012, after you edit the package it will not be allowed in the SQL server.
  • Python, Perl scripts are still a high competition for SSIS, mostly because they are very easy to manipulate, if you need a change you can do it directly with notepad.
  • Plus Python now has an add-on called Pandas which is great for manipulating data.
Jose Pla profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
SSIS6.0
Based on 2 answers
A bit outdated compared to competitors, esp in the open source community
No photo available

Usability

Anypoint Platform8.0
Based on 1 answer
simple and easy graphics and containers helps developers to write complex flows
Federica Bianco profile photo
SSIS8.0
Based on 2 answers
Easy to use, however there are functionality limits
No photo available

Support

No score
No answers yet
No answers on this topic
SSIS9.0
Based on 3 answers
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.
Chris Morgan profile photo

Implementation

No score
No answers yet
No answers on this topic
SSIS10.0
Based on 1 answer
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
Luca Campanelli profile photo

Alternatives Considered

It enables customers to expose their APIs in a very simple and fast way. It can be used by non-expert developers. It is compliant with all major connection and data representation world standard.
Federica Bianco profile photo
Look for where you are going to load the data and from where are you extracting it. A lot of those who sell you the DB already have tools for ETL. I have heard good things at an enterprise level from great colleagues about Informatica, but honestly, I prefer SSIS.Although I did like TIBCO Jaspersoft and it can be mixed with TIBCO Spotfire for data analysis. If your ERP is SAP, then you must keep in mind using SAP BusinessObjects. As for free tools, and if you have a great and constant team of scripting (Perl, Python) engineers, then you can think about going open source.
Jose Pla profile photo

Return on Investment

  • So far using MuleSoft Anypoint Platform will give you more profits in terms of compressing the timeline and project resources.
Keiven Adrian Busita profile photo
  • SSIS has been a huge time savings where previously manual data scrubbing and/or import tasks have been automated.
  • It has allowed us to schedule jobs that previously required human involvement. Now everything runs seamlessly through SQL jobs.
  • It provides us with a wider customer base as we are pigeon-holed into working with a small number of data source options. We can work with an infinite amount of data sources due to our utilization of SSIS.
No photo available

Pricing Details

Anypoint Platform

General
Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

SSIS

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details