Try our new research platform with insights from 80,000+ expert users

MuleSoft Anypoint Platform vs SSIS comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

MuleSoft Anypoint Platform
Average Rating
8.0
Number of Reviews
55
Ranking in other categories
Message Queue (MQ) Software (3rd), Business-to-Business Middleware (2nd), Workload Automation (9th), Cloud Data Integration (4th), Integration Platform as a Service (iPaaS) (1st)
SSIS
Average Rating
7.8
Number of Reviews
71
Ranking in other categories
Data Integration (4th)
 

Featured Reviews

KB
Mar 18, 2024
Easy to set it up, good support but we need to use APIs for external integration
When it comes to external systems, we need to use APIs. So, it needs some extra effort. When we are integrating with other applications, readily available connectors make it easy. However, when it comes to external applications, connectivity isn't as straightforward. We need to use RESTful APIs to get and push messages. While it's doable, it's not as simple as using the pre-built connectors. In future releases, Anypoint MQ can increase the message size limit a little bit. We faced issues while working with SAP integrations. SAP can have very large files, and we couldn't handle those within the Anypoint MQ limit.
VS
Dec 22, 2023
Beneficial source data importing, reliable, and quick initial setup
I am using SSIS for a primary database Not much but served as better alternative The most valuable features of SSIS are that it works with the query language and it can import data from different sources.  SSIS can improve by the minimum code requirements in stored procedures and exporting data…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"I have found several things most valuable, including its very quick implementation that you can use a lot of out of the box templates, and lastly that it is a very mature product, especially in hybrid integration."
"The most valuable features of the Mule Anypoint Platform are the Flex Gateway, API management, easy-to-use, and connectors. Additionally, they are coming out with improvements to the solution when required."
"The use of ACK is valuable."
"Good interface, simple to use and stable."
"The initial setup is quite easy because the solution has a good interface through which the configuration, mapping, and so on can be done."
"The platform's cloud integration capabilities are good."
"Mule works very well with Salesforce and CRMs."
"The most valuable feature of Anypoint MQ is it comes with MuleSoft so we don't have to maintain separate components."
"It is easy to set up the product."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"The initial setup was easy."
"SSIS' most valuable feature is its reporting services."
 

Cons

"I would like to see some data integration and automation."
"It has different types of subscriptions. For platinum or lower subscriptions, there are not too many things that can be done. We don't see many features. They should release a basic version that has logging and monitoring features. These features should come with Mule Anypoint Platform for free instead of making customers pay separately for these features. Its dashboard can be improved to have a lot of charts so that it is easy to visualize information. The utilization part can be improved. The dashboard is good currently, but it can be better. Other solutions like Elastic have a good dashboard, and they allow you to administer the product from the UI. Currently, for RTF, there is a different dashboard or utility. It would be good to include the same utility in the cloud solution. It would be good if there is a centralized repository that includes the links to the information about various troubleshooting issues. The documentation is there currently, and it is good, but the troubleshooting information is too scattered. We have to go to different links to find troubleshooting information. This kind of centralized repository would be helpful for new customers who are implementing this solution. It will be helpful to see different kinds of issues that can occur."
"It's extremely expensive to change things in Anypoint MQ. There's also this issue of slow output of messages, and that needs to be improved."
"The platform's data integration tools need improvement on the processing side."
"The solution is very costly. The solution should provide a package with fewer capabilities at a lower price for specific companies that don’t have a big IT budget. Not every customer requires all the capabilities of the software. It will be a good fit in the market, and they will easily sell it more."
"Pricing is one aspect of the solution that is troublesome. It's too expensive for smaller organizations."
"This becomes an expensive solution over time."
"We would like an entire DevOps in place in this particular solution."
"The solution could improve on integrating with other types of data sources."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"It's a legacy tool, that is nearing the end of its useful life."
"It needs more integration tools, so you can connect to different sources."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
 

Pricing and Cost Advice

"I can't give you a straightforward answer because sometimes it depends on the usage. If you're going to have fewer than 5 million messages, it is free of cost. If you're going to have more than 5 million messages, they're going to charge $100 per month"
"The tool is heavily bundle-priced. I rate the solution’s pricing five on a scale of ten, where one is expensive, and ten is cheap."
"The product is still very expensive."
"The product comes complete at one set price including support."
"On a scale of one to ten, where one is cheap, and ten is expensive, I rate the solution's pricing as four or five out of ten."
"The licensing is core-based. My customers tell me that it's very expensive compared to the cost of other integration suites."
"The solution is the priciest in the market which is an issue for some clients."
"Price-wise, it is a good product since it is reasonably priced."
"This solution is included with the MSSQL server package."
"SSIS' licensing is a little high, but it gives good value for money."
"This solution has provided an inexpensive tool, and it is easy to find experienced developers."
"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."
"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."
"It would be beneficial if the solution had a less costly cloud offering."
"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
805,335 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Educational Organization
20%
Computer Software Company
15%
Financial Services Firm
10%
Manufacturing Company
8%
Financial Services Firm
17%
Computer Software Company
13%
Government
8%
Manufacturing Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What advice do you have for others considering Mule Anypoint Platform?
I architected solutions using Oracle SOA/OSB, Spring Boot, MuleSoft Anypoint Platform on cloud / on-premises and hybrid modes; What I see is though if you are an enterprise and have enough money th...
How does TIBCO BusinessWorks compare with Mule Anypoint Platform?
Our organization ran comparison tests to determine whether TIBCO BusinessWorks or Mule Anypoint platform integration and connectivity software was the better fit for us. We decided to go with Mule...
What can Mule Anypoint Platform be used for and what do you use it for most often?
This is a very flexible solution that comes with multiple uses. My organization mostly uses Mule Anypoint Platform for API management, as it lets us build new APIs easily and design new interfaces...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
What do you like most about SSIS?
The product's deployment phase is easy.
 

Also Known As

Data Integrator, Anypoint MQ
SQL Server Integration Services
 

Overview

 

Sample Customers

VMware, Gucci, MasterCard, Target, Time Inc, Hershey's, Tesla, Spotify, Office Depot, Intuit, CBS, Amtrak, Salesforce, Gap, Ralph Lauren
1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
Find out what your peers are saying about MuleSoft Anypoint Platform vs. SSIS and other solutions. Updated: September 2024.
805,335 professionals have used our research since 2012.