Mule Anypoint Platform vs SSIS comparison

Cancel
You must select at least 2 products to compare!
MuleSoft Logo
5,111 views|3,047 comparisons
93% willing to recommend
Microsoft Logo
Read 69 SSIS reviews
19,105 views|15,500 comparisons
79% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Mule Anypoint Platform and SSIS based on real PeerSpot user reviews.

Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Mule Anypoint Platform vs. SSIS Report (Updated: March 2024).
769,599 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The tool is very capable and offers a high performance. The tool supports batch processing and ETL processing.""The product is very user-friendly.""It's easy to develop APIs.""The most valuable features for us are flexibility, all the features related to connectivity with multiple connectors to the business, and the flexibility of on-premises and cloud deployments.""The flexibility has been great overall.""This is the easiest and best tool available.""Mule Anypoint Platform is our preferred platform for integration.""API management."

More Mule Anypoint Platform Pros →

"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud.""With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server.""Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows.""The interface is very user-friendly.""The script component is very powerful, things that you cannot normally do, is feasible through C#.""The most valuable feature of SSIS is its ease of use. It is easier to use than other applications.""It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better.""The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."

More SSIS Pros →

Cons
"Price-wise, it is a good product since it is reasonably priced...Mule Anypoint Platform can get too complex for non-technical people.""It should give better control over account management.""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.""The pricing can be a little bit less.""The solution is very expensive. They need to work on the pricing.""The stability could be better.""Although the solution's proxy design and process are good, it faces connecting issues because it lacks data integration.""What I hear from my customers is that it's very expensive compared to the cost of other integration suites. The cost keeps increasing. MuleSoft should come up with customization factors by using a different way of getting the cost-related stuff to attract customers. That is, they should come up with some cost optimizations."

More Mule Anypoint Platform Cons →

"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion.""SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model.""SSIS is stable, but extensive ETL data processing can have some performance issues.""I would like to see better technical documentation because many times information is missing.""Tuning using this solution requires extensive expertise to improve performance.""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.""Improvement as per customer requirements.""We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."

More SSIS Cons →

Pricing and Cost Advice
  • "Licensing can be complex as is the case with most iPaaS/cloud offerings."
  • "Mule is not the cheapest integration platform out there, but it deserves the price we are paying."
  • "The product comes complete at one set price including support."
  • "The licensing is core-based. My customers tell me that it's very expensive compared to the cost of other integration suites."
  • "Mule Anypoint Platform pricing is slightly higher compared to Dell Boomi."
  • "The solution is the priciest in the market which is an issue for some clients."
  • "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."
  • "The product is still very expensive."
  • More Mule Anypoint Platform Pricing and Cost Advice →

  • "This solution has provided an inexpensive tool, and it is easy to find experienced developers."
  • "My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."
  • "This solution is included with the MSSQL server package."
  • "It would be beneficial if the solution had a less costly cloud offering."
  • "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."
  • "We have an enterprise license for this solution."
  • "It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
  • "All of my clients have this product included as part of their Microsoft license."
  • More SSIS Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
    769,599 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    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 There are many third-party vendors offering ETL solutions, but two of the most popular are PowerCenter Informatica and Microsoft SSIS (SQL Server Integration Services). Each technology has its advantages but there are also similarities on how they carry out the extract-transform-load processes and only differ in terminologies. If you’re in the process of choosing ETL tools and PowerCenter Informatica and Microsoft SSIS made it to your shortlist, here is a short comparative discussion detailing the differences between the two, as well as their benefits. Package Configuration Most enterprise data integration projects would require the capacity to develop a solution in one platform and test and deploy it in a separate environment without having to manually change the established workflow. In order to achieve this seamless movement between two environments, your ETL technology should allow the dynamic update of the project’s properties using the content or a parameter file or configuration. Both Informatica and SSIS support this functionality using different methodologies. In Informatica, every session can have more than one source and one or more destination connections. There are… Read more →
    Questions from the Community
    Top Answer: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 then… more »
    Top Answer: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… more »
    Top Answer: 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… more »
    Top Answer: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… more »
    Top Answer:The product's deployment phase is easy.
    Top Answer: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.
    Ranking
    3rd
    Views
    5,111
    Comparisons
    3,047
    Reviews
    20
    Average Words per Review
    567
    Rating
    8.5
    2nd
    out of 101 in Data Integration
    Views
    19,105
    Comparisons
    15,500
    Reviews
    35
    Average Words per Review
    474
    Rating
    7.8
    Comparisons
    Also Known As
    Data Integrator
    SQL Server Integration Services
    Learn More
    Overview

    Mule Anypoint Platform is a high-ranking solution that creates a communication layer between disparate systems to eliminate integration problems. The product retrieves and stores data streams from any source type, device, or application, both in the cloud and locally. Mule Anypoint Platform solves the most challenging connectivity problems across Software as a Service (SaaS), service-oriented architecture (SOA), and application programming interfaces (APIs) through connectivity, control, and composability. The unified hybrid integration platform achieves this by creating an application network of data, apps, and devices with API-led connectivity.

    The solution consists of a set of out-of-the-box connectors that work on any type of system and offers a configuration with low coding effort while minimizing the cost and constraints of hard point-to-point connections. The use cases of Mule Anypoint Platform include:

    • Utilizing APIs for application delivery: Specialists can use Mule Anypoint Platform to jumpstart application development and take advantage of pre-built assets or utilize APIs built anywhere using their CI/CD pipelines. Companies can build APIs from scratch in diverse protocols and test them with built-in support for Maven and Jenkins.

    • Flexible deployment: Mule Anypoint Platform can be used in any architecture or environment. The product offers its users flexibility and freedom to select between using MuleSoft's fully managed infrastructure or deployment in popular cloud providers like Amazon AWS, Microsoft Azure, and Google Cloud Platform.

    • Data protection: The product offers high levels of security and compliance with various standards and policies. It can be utilized by companies for protecting data, microservices, APIs, and integrations without development overheads.

    • API and service management and monitoring: The product offers an all-in-one platform for users to manage, secure, and scale their APIs as well as troubleshoot and diagnose in real time to detect underlying issues.

    • Custom marketplace building: Mule Anypoint Platform can be used to facilitate the creation of custom marketplaces for customers, partners, and employees. The product offers pre-built APIs, templates, connectors, accelerators, and other integrations for this purpose.

    Mule Anypoint Platform Features

    Mule Anypoint Platform consists of features for APIs and integrations that are separated into three categories: API management, integration, and deployment and monitoring. These features include:

    • Anypoint Flex Gateway: This feature is designed to manage and secure APIs running across any environment.

    • Anypoint API Governance: This feature ensures consistent API security and quality with self-service tools.

    • Anypoint API Designer: API Designer offers a visual or code-based guided process for designing, documenting, and testing APIs in any language.

    • Anypoint Studio: Through this feature, users can accelerate implementation with prebuilt modules for common integration requirements.

    • Anypoint Connectors: This capacity of the solution allows system integration using a web interface or a desktop-integrated development environment (IDE).

    • Anypoint Code Builder: This is a new feature of the product that is made for developers to design, develop, and deploy APIs, integrations, and automations from a single environment, utilizing an innovative IDE.

    • Anypoint Monitoring: Through this feature, users can monitor in real time their integrations, APIs, and microservices all in one place.

    • Anypoint Runtime Fabric: This is a container service that brings cloud benefits to on-premises deployments both in data centers and on a private cloud.

    • CloudHub: This is the Platform as a Service (PaaS) component of Mule Anypoint Platform.

    • Anypoint Security: This feature offers advanced defense for users' APIs and integrations.

    Mule Anypoint Platform Benefits

    Mule Anypoint Platform offers multiple benefits for companies that utilize its services. Some of the biggest advantages of the product include:

    • Mule Anypoint Platform reduces development time to deliver efficient resource management from a single platform.

    • The product improves agility with innovative architecture that adheres to customers' specific needs.

    • The solution utilizes open technologies that provide customers with reusability, modularity, and collaboration opportunities.

    • Mule Anypoint Platform comes with automated security and governance that ensures customers' data is protected at enterprise levels.

    • The product has built-in reliability, visibility, and scalability, which make operations more resilient for users.

    • The solution is constantly updated and ensures a competitive environment for users through flexible services.

    Reviews from Real Users

    Michael S., a senior enterprise architect at a tech services company, gives Mule Anypoint Platform a high rating and states that the product is constantly improving to help connect applications, data, and devices.

    A senior technical architect at a tech services company likes Mule Anypoint Platform for the good stability with an easy setup and good technical support that the product provides.

    SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.

    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
    Top Industries
    REVIEWERS
    Computer Software Company33%
    Healthcare Company11%
    Recruiting/Hr Firm11%
    Media Company6%
    VISITORS READING REVIEWS
    Educational Organization22%
    Computer Software Company14%
    Financial Services Firm9%
    Manufacturing Company8%
    REVIEWERS
    Financial Services Firm23%
    Healthcare Company8%
    Computer Software Company8%
    Manufacturing Company8%
    VISITORS READING REVIEWS
    Financial Services Firm17%
    Computer Software Company12%
    Government7%
    Healthcare Company6%
    Company Size
    REVIEWERS
    Small Business30%
    Midsize Enterprise21%
    Large Enterprise49%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise28%
    Large Enterprise57%
    REVIEWERS
    Small Business27%
    Midsize Enterprise17%
    Large Enterprise56%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    Buyer's Guide
    Mule Anypoint Platform vs. SSIS
    March 2024
    Find out what your peers are saying about Mule Anypoint Platform vs. SSIS and other solutions. Updated: March 2024.
    769,599 professionals have used our research since 2012.

    Mule Anypoint Platform is ranked 3rd in Cloud Data Integration with 40 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Mule Anypoint Platform is rated 8.2, while SSIS is rated 7.6. The top reviewer of Mule Anypoint Platform writes "Robust, reliable, and stable, ensuring high availability for critical integrations". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Mule Anypoint Platform is most compared with MuleSoft Composer, Microsoft Azure Logic Apps, Oracle Integration Cloud Service, SAP Process Orchestration and SAP Cloud Platform, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our Mule Anypoint Platform vs. SSIS report.

    See our list of best Cloud Data Integration vendors.

    We monitor all Cloud Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.