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

Informatica Enterprise Data Lake vs MuleSoft Anypoint Platform vs SSIS comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Featured Reviews

SB
Have built an enterprise-level cloud data pipeline with reliable governance and integration
People use Informatica Enterprise Data Lake because we can create the whole journey from data migration projects from the legacy system to AWS and to the Lake architecture, covering the entire journey from the source to the landing zone, then to the curated zone, and finally consumed by both downstream and upstream applications. The main benefit of Informatica Enterprise Data Lake is that it allows you to use different types of data types, including blobs and storage; all types of data—structured, unstructured, and semi-structured—can exist in the Data Lake architecture, making it robust for retrieving data based on your filtration needs. Its value is actually governed by the client, who combined with our company and AWS, so we all work together to use the workspace and all these things for Informatica Enterprise Data Lake.
Mohan BS - PeerSpot reviewer
A useful tool to integrate applications and for data transformations that need to improve in the area of price and support
The main area where improvements are required in the product revolves around budgeting. The cost of the product is an area of concern where improvements are required, especially when compared to other tools, like Dell Boomi or Oracle. Mule Anypoint Platform is made available with many components, and whether users use them or not depends on their choices. For example, though there is a tool called Anypoint MQ, our organization prefers to pay and use Kafka, as we don't want to use MuleSoft Anypoint MQ. In Mule Anypoint Platform, there needs to be proper segregation to help users identify what they need and don't need, making it an area where users need to be careful when opting for MuleSoft. Mule Anypoint Platform is an integration tool and not an ETL solution. When a user has to deal with a huge number of data, then Mule Anypoint Platform should not be a preferred choice since it can only be used for lightweight purposes revolving around APIs. There is a need to have a clear architectural decision made before opting for Mule Anypoint Platform. When there is a requirement for heavy data transformation, then users need to decide whether to go with Mule Anypoint Platform or any other platform available in the market. Though the tool comes with many useful components, it depends on whether the user plans to use all of its features. Recently, the product has come up with a new feature that is similar to an API catalog. MuleSoft had come up with the UAPIM feature almost eight months to a year ago, which had some concerns in the area of budgeting. Whether you build APIs using Javacore or any other tools, they can be cataloged using MuleSoft's UAPIM feature, for which users need to pay an extra amount, making it an area of concern for users. It would be great if MuleSoft's support team could provide help with the area of Kubernetes.
Chris Farris - PeerSpot reviewer
User-friendly interface facilitates efficient data migration and reduces operational overhead
Its usability and ease of use are standout features. It is really easy to use - almost too easy at times. Users don't have to be experts to use their tool set and utilize the clicking mechanisms, drop down boxes, and other features to build a package and run it. The configuration is very easy and the system is very stable. I would rate it at a 10 as it is highly reliable; we have never had any problems with it. Very little maintenance is required on my side. While you need to keep the product up to date, the maintenance requirements are minimal. SSIS integrates with all Microsoft tools seamlessly. We have used it against Oracle, DB2 and SQL. It integrates and can move data around from any data platforms, making it very diverse in that standpoint. It is a very robust tool that can work with many data sources, and its main strength is that it is extremely easy to use.

Quotes from Members

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

Pros

"The process of using the tool's scalability option is well documented."
"The tool helps with order management and automates the enterprise's orchestration, invoice creation, product maintenance, and product life cycle. The API manager feature helps us configure, secure, and call APIs."
"The most valuable feature is the full lifecycle management, including Anypoint Designer and Exchange, as well as Discofolio API."
"The tool's visual features are attractive."
"Initially, we faced challenges managing numerous scheduled jobs and duplicate entries in our SAP system. To address this, we developed a reusable component in Mule that all applications could use to interact with SAP."
"The integration potential is excellent."
"MuleSoft's integration with Salesforce products makes it a preferred choice for those setups."
"It's easy to use and comes as a bundle package with the Anypoint Platform, removing the need for any complex setup."
"It is a stable product...The initial setup was simple."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The performance and stability are good."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"The most important features are it works well and provides self-service BI."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"The initial setup was easy."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
 

Cons

"Informatica Enterprise Data Lake's setup process was complex since it doesn't support a lot of real-time systems."
"There are so many solutions like this, but this is not as mature as those products. The other MQ products have the capability of reprocessing and maintaining the persistence of the data. They can handle large volumes and large messages, but Anypoint MQ doesn't have those capabilities."
"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."
"MuleSoft's release calendar is rather conventional with two major, two minor releases and hotfixes in between. The competition sometimes offer more rapid release cycles and provides improved and new functionality with a faster time-to-market."
"One area we'd like to see improvement in is the error logging and troubleshooting process."
"Mule Anypoint Platform should improve its pricing. In my experience, a customer using the sandbox version couldn't upgrade to the final version because it exceeded their budget. Another area for improvement is the login mechanism. We need to integrate with third-party products for strong authentication, but it would be better if MuleSoft had its own robust login mechanism."
"Anypoint MQ could improve the user interface."
"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."
"Technical support needs to be improved, especially when you need help with more technical aspects of the solution."
"It's a legacy tool, that is nearing the end of its useful life."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"It needs more integration tools, so you can connect to different sources."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"I would like to see better integration with Power BI."
 

Pricing and Cost Advice

"The licenses attached to the solution are highly priced."
"The product is still very expensive."
"MuleSoft Anypoint Platform really needs to work on its pricing model because it's very complicated."
"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."
"Price-wise, it is a good product since it is reasonably priced."
"Licensing can be complex as is the case with most iPaaS/cloud offerings."
"The pricing of our solution is highly competitive. While it may not be categorized as exceptionally low, it is certainly more affordable compared to IBM."
"Mule Anypoint Platform is an expensive solution."
"Mule Anypoint Platform is affordable."
"SSIS is fairly well-priced - I would rate it at four out of five."
"SSIS' licensing is a little high, but it gives good value for money."
"It would be beneficial if the solution had a less costly cloud offering."
"All of my clients have this product included as part of their Microsoft license."
"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."
"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
"Our license with SSIS is annual."
"The solution is available at a lesser price than that of Informatica."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
868,288 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
No data available
Financial Services Firm
13%
Computer Software Company
13%
Manufacturing Company
10%
Government
7%
Financial Services Firm
18%
Computer Software Company
10%
Government
8%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business21
Midsize Enterprise12
Large Enterprise29
By reviewers
Company SizeCount
Small Business26
Midsize Enterprise19
Large Enterprise57
 

Questions from the Community

What do you like most about Informatica Enterprise Data Lake?
The process of using the tool's scalability option is well documented.
What is your experience regarding pricing and costs for Informatica Enterprise Data Lake?
The licenses attached to the solution are highly priced. Informatica has licensing models for every product and for e...
What needs improvement with Informatica Enterprise Data Lake?
Governance, data dictionary, and data cataloging are not available in Informatica Enterprise Data Lake. A lot of busi...
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 hybr...
How does TIBCO BusinessWorks compare with Mule Anypoint Platform?
Our organization ran comparison tests to determine whether TIBCO BusinessWorks or Mule Anypoint platform integration ...
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 f...
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 ...
What do you like most about SSIS?
The product's deployment phase is easy.
What is your experience regarding pricing and costs for SSIS?
It was included in our licensing for SQL server, and our licensing for SQL server was extremely cheap, making it a ve...
 

Also Known As

Informatica Intelligent Data Lake, Intelligent Data Lake
Data Integrator, Anypoint MQ
SQL Server Integration Services
 

Overview

 

Sample Customers

Information Not Available
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 Amazon Web Services (AWS), Informatica, Salesforce and others in Cloud Data Integration. Updated: September 2025.
868,288 professionals have used our research since 2012.