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."
"API management."
"The most valuable feature of Anypoint MQ is it comes with MuleSoft so we don't have to maintain separate components."
"The solution is scalable, and its performance is quite good."
"Messaging and queueing solution that has good stability and scalability. It can be used for a variety of messaging types."
"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."
"Mule Anypoint Platform is our preferred platform for integration."
"It's easy to develop APIs."
"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."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"Overall, it's a good product."
"The UI is very user-friendly."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"SSIS integrates well with SQL servers and Microsoft products."
"The scalability of SSIS is good."
"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."
"Stability is rated at 10."
 

Cons

"Informatica Enterprise Data Lake's setup process was complex since it doesn't support a lot of real-time systems."
"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."
"An on-premise setup requires special skills and you need a lot of professional services."
"Price-wise, it is a good product since it is reasonably priced...Mule Anypoint Platform can get too complex for non-technical people."
"Lacks intelligent management data and intelligent mappings."
"Better documentation, in particular with respect to the initial setup, would be helpful."
"The solution's pricing model is very strange, and it will be really expensive if you use APIs a lot."
"MuleSoft is considered one of the more expensive products in the market."
"Adding connectors for new upcoming applications would add extra value to this product."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"It's a legacy tool, that is nearing the end of its useful life."
"This solution needs full support for real-time processing."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
 

Pricing and Cost Advice

"The licenses attached to the solution are highly priced."
"The product's price seems to be competent in comparison to other products in the market."
"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."
"The solution's pricing, as per the old approach, is expensive."
"Making changes in Anypoint MQ is expensive."
"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."
"Regarding pricing, I believe there could be room for improvement to align with user expectations."
"The product is still very expensive."
"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."
"SSIS is a cheaper option compared to the cost of other ETL tools."
"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."
"We have an enterprise license for this solution."
"The solution comes free of cost."
"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."
"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."
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.