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

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

  • SSIS is particularly well suited for jobs that need to be consistent, repeatable, and error managed.
  • Ongoing extract, transform, load [ETL] jobs that are scheduled or manual.
  • One-time ETL with complex datasets.
  • Migrations of large datasets.
SSIS is not well suited for small or simple datasets that can be copied or exported safely to flat files for import. It is possible to do this but would generally take longer to build in SSIS unless there was a good reason to .remove manual handling of the data in transport or the action needed to be testable/repeatable.
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.5
Connect to traditional data sources
Anypoint Platform
SSIS
9.5
Connecto to Big Data and NoSQL
Anypoint Platform
SSIS
7.5

Data Transformations

Anypoint Platform
SSIS
8.9
Simple transformations
Anypoint Platform
SSIS
9.8
Complex transformations
Anypoint Platform
SSIS
7.9

Data Modeling

Anypoint Platform
SSIS
6.9
Data model creation
Anypoint Platform
SSIS
7.1
Metadata management
Anypoint Platform
SSIS
6.3
Business rules and workflow
Anypoint Platform
SSIS
8.0
Collaboration
Anypoint Platform
SSIS
6.1
Testing and debugging
Anypoint Platform
SSIS
7.2

Data Governance

Anypoint Platform
SSIS
7.9
Integration with data quality tools
Anypoint Platform
SSIS
8.3
Integration with MDM tools
Anypoint Platform
SSIS
7.4

Pros

Anypoint Platform

  • Expose APIs for seamless use internally and by customer developers.
  • Improve rapid development processes.
  • Provide end to end monitoring that helps improve overall quality and aid in troubleshooting.
Thomas Green III profile photo

SSIS

  • Ease of use - can be used with no prior experience in a relatively short amount of time.
  • Flexibility - provides multiple means of accomplishing tasks to be able to support virtually any scenario.
  • Performance - performs well with default configurations but allows the user to choose a multitude of options that can enhance performance.
  • Resilient - supports the configuration of error handling to prevent and identify breakages.
  • Complete suite of configurable tools.
No photo available

Cons

Anypoint Platform

  • Redefining API design is cumbersome and painful.
  • Batch transacting is not as intuitive as would be expected.
Thomas Green III profile photo

SSIS

  • SSIS has been a bit neglected by Microsoft and new features are slow in coming.
  • When importing data from flat files and Excel workbooks, changes in the data structure will cause the extracts to fail. Workarounds do exist but are not easily implemented. If your source data structure does not change or rarely changes, this negative is relatively insignificant.
  • While add-on third-party SSIS tools exist, there are only a small number of vendors actively supporting SSIS and license fees for production server use can be significant especially in highly-scaled environments.
No photo available

Likelihood to Renew

Anypoint Platform

No score
No answers yet
No answers on this topic

SSIS

SSIS 8.4
Based on 3 answers
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.
No photo available

Usability

Anypoint Platform

Anypoint Platform 8.0
Based on 1 answer
simple and easy graphics and containers helps developers to write complex flows
Federica Bianco profile photo

SSIS

SSIS 8.6
Based on 8 answers
If you use any of the Microsoft tools, it is easy to get using and understand since it uses Visual Studio and SSMS to work with. There are extensions you can get and some of those can be difficult to work with but usually they slide in nicely. The one thing to understand though is there is some installation and configuration on the SQL Server side that can take some time.
Steven Gockley, MBA, MCSA profile photo

Performance

Anypoint Platform

No score
No answers yet
No answers on this topic

SSIS

SSIS 8.3
Based on 6 answers
Raw performance is great. At times, depending on the machine you are using for development, the IDE can have issues. Deploying projects is very easy and the tool set they give you to monitor jobs out of the box is decent. If you do very much with it you will have to write into your projects performance tracking though.
Steven Gockley, MBA, MCSA profile photo

Support

Anypoint Platform

No score
No answers yet
No answers on this topic

SSIS

SSIS 9.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

Anypoint Platform

No score
No answers yet
No answers on this topic

SSIS

SSIS 10.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

Anypoint Platform

Compared to Dell Boomi the API management suite of Mulesoft is much mature, however if its only about the integration , then i would always go for Dell Boomi, as there is no infrastructure setup that needs to be done from the developer's end.Apigee api management is as good as Anypoint platform if not better, but it doesn't have integration capabilities like that of Mulesoft.IBM App Connect not in the league of matured products like Dell Boomi,Mulesoft or Apigee
Rajarshee Mukhopadhyay profile photo

SSIS

I've used several solutions from just simple ETL processes of stored procedures run manually to using Informatica. SSIS is a good in between solution. It has sufficient maturity to be preferable to scheduled procs in SS agent jobs. But does not have the sophistication and full feature set of Informatica. But significantly cheaper than Informatica. Plus since it's bundled with SS all SS shops already have it.
David Milillo profile photo

Return on Investment

Anypoint Platform

  • 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

SSIS

  • As it is part of the SQL related products, customers are more receptive to the product due to the lower risk. This increased our product offerings in our solutions for projects.
  • The work required to implement an SSIS project is relatively quick compared to other tools and it reduces the amount of time required by staff to configure.
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

Add comparison