What users are saying about
159 Ratings
39 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.1 out of 101
159 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

Add comparison

Likelihood to Recommend

Anypoint Platform

Pros:
  • Basically, it is used to solve business problems where integration needs to be done between a legacy system and Salesforce.
  • Its capable of handling the integration between a variety of connectors.
  • The transformation is just so simple. We can use XML, JSON, and Java for it.
Cons:
  • The functions used in the transformation connector should be prompted automatically.
  • RAML should be designed and compiled within the Anypoint studio.
Vaibhav Khanna ☁⚡ profile photo

SSIS

Microsoft SQL Server Integration Services is suited for development by those who are NOT very experienced developers. End-users with some database experience may find the development environment easy to use allowing development of basic ETL. Experienced developers will likely feel restricted by the "Microsoft-only" interface. Additionally, many larger organizations that have made a significant investment in databases other than SQL Servers will be unable to use SSIS against those database servers.
No photo available

Feature Rating Comparison

Cloud Data Integration

Anypoint Platform
9.5
SSIS
Pre-built connectors
Anypoint Platform
8.0
SSIS
Connector modification
Anypoint Platform
9.0
SSIS
Support for real-time and batch integration
Anypoint Platform
10.0
SSIS
Data quality services
Anypoint Platform
10.0
SSIS
Data security features
Anypoint Platform
10.0
SSIS
Monitoring console
Anypoint Platform
10.0
SSIS

Data Source Connection

Anypoint Platform
SSIS
8.0
Connect to traditional data sources
Anypoint Platform
SSIS
9.1
Connecto to Big Data and NoSQL
Anypoint Platform
SSIS
6.8

Data Transformations

Anypoint Platform
SSIS
8.7
Simple transformations
Anypoint Platform
SSIS
9.6
Complex transformations
Anypoint Platform
SSIS
7.9

Data Modeling

Anypoint Platform
SSIS
7.2
Data model creation
Anypoint Platform
SSIS
7.5
Metadata management
Anypoint Platform
SSIS
6.8
Business rules and workflow
Anypoint Platform
SSIS
8.4
Collaboration
Anypoint Platform
SSIS
6.0
Testing and debugging
Anypoint Platform
SSIS
7.3

Data Governance

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

Pros

  • Supports wide range of systems for the integrations
  • Support API development and web service implementations to integrate homegrown systems too.
  • Cloud deployment and monitoring make it easy to handle post production
  • Pricing is a plus point while comparing it to others in market
Ankit Goyal profile photo
  • There are many good workflow tools and ways to control the order in which things happen. In a short amount of time, you can quickly create a package that will move data from point A to point B and have it scheduled to run 4 times a day. Or if you need error handling or other business logic, you can spend more time and completely automate repetitive tasks. Robust? Check!
  • SSIS can consume multiple sources of data. From flat files, to Excel, to Oracle, or DB2...I've been able to access multiple data types and move them in and out of SQL databases with SSIS. We had one linux system that ran a Basis database system and there was a need to have something done, but no one could figure out how to make it work. I was able to use SSIS to import files and execute code on a server that had nothing to do with SQL server. So flexible? Check!
  • We already use SQL server almost exclusively for our enterprise database needs. The fact that we already have access to this tool at no additional cost to the business is a bonus. The fact that it is powerful, even better. Value? Check!
Greg Goss profile photo

Cons

  • Redefining API design is cumbersome and painful.
  • Batch transacting is not as intuitive as would be expected.
Thomas Green III 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
SSIS7.0
Based on 3 answers
Easy to use, however there are functionality limits
No photo available

Performance

No score
No answers yet
No answers on this topic
SSIS6.0
Based on 1 answer
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.
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

API led architecture focus with a decent API ecosystem for developer collaboration, policy management and declarative implementation. Batch processing, visualization, Anypoint MQ and ObjectStore leave a lot to be explored. Multiple deployment models make it worth considering.
No photo available
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

  • We noticed a new way for integrating REST services interacting with mobile application (IOS/Android based).
  • Our customer appreciated our work.
  • Our customer appreciated having a very solid production environment while not needing to spend money to maintain it.
Federica Bianco profile photo
  • It comes with SQL server, so if you are already using that for the DB, we had no charge for using SSIS for the same solution. That is one big advantage of Microsoft, they provide the whole combo for BI at once.
  • ROI is a time measure, if you bought SQL just for the DB, but then you want to use SSIS, most probably it is already there.
  • If you try even an open source solution, you will have to install it and get trained on it, for SSIS the learning curve is very short.
  • Be careful, SSIS is for ETL, not for middleware at an enterprise level. In the begining it might work but it is not the purpose of the tool, for middleware solutions where the business depends on, don't get confused and if you are still looking for Microsoft go for BizTalk.
Jose Pla profile photo

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