JumpMind SymmetricDS vs Mule Anypoint Platform vs SSIS comparison

Cancel
You must select at least 2 products to compare!
JumpMind Logo
289 views|181 comparisons
100% willing to recommend
MuleSoft Logo
5,228 views|3,103 comparisons
93% willing to recommend
Microsoft Logo
Read 69 SSIS reviews
19,568 views|15,878 comparisons
79% willing to recommend
Comparison Buyer's Guide
Executive Summary

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

Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration.
To learn more, read our detailed Cloud Data Integration Report (Updated: March 2024).
768,578 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
"It is fully featured. It has allowed me to do everything I wanted to do."

More JumpMind SymmetricDS Pros →

"It is very easy to use for building connectors. It comes with a lot of connectors. For example, it has different adapters for NetSuite, which are very easy to use. It also has Salesforce connectors. The object store feature is also really easy to use. Mule Anypoint Platform is also good in terms of performance and how it is managed behind the scenes.""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.""MuleSoft offers with the Anypoint Platform a unified platform for API management and an integration Platform as a Service (iPaaS) as well as an on-premise Enterprise Service Bus pattern.""The exchange and API management features are the best in the market.""Mule Anypoint Platform's valuable features are its flexibility in terms of deployment and its SaaS capabilities.""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 tool is very capable and offers a high performance. The tool supports batch processing and ETL processing.""Overall, it is a pretty good product. It is also very scalable."

More Mule Anypoint Platform Pros →

"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server.""It has good data integration and good processes.""The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle.""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.""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.""The most valuable features of SSIS are that it works with the query language and it can import data from different sources.""I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import.""The most valuable feature of SSIS is that it can handle real complex transformations."

More SSIS Pros →

Cons
"The user interface could improve. We are looking at some cloud-based databases, and I don't think they support that."

More JumpMind SymmetricDS Cons →

"Adding connectors for new upcoming applications would add extra value to this product.""Mule should have better B2B integration.""The solution's licensing methodologies could be improved.""This becomes an expensive solution over time.""The pricing can be a little bit less.""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.""Code quality, Code Security, SaaS, and DaaS security, can all be improved.""Better documentation, in particular with respect to the initial setup, would be helpful."

More Mule Anypoint Platform Cons →

"The solution could improve by having quicker release updates.""Video training would be a helpful addition.""We've had issues in terms of the amount of data that is transferred when we are scheduling.""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.""The creation of the measure in the DAC's model could be improved.""A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened.""Improving the login procedure would make our reporting easier on monitoring our ETL processes.""I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."

More SSIS Cons →

Pricing and Cost Advice
Information Not Available
  • "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.
    768,578 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:Yes, it does. This data replication software works with many popular databases, allowing users to benefit from its… more »
    Top Answer:I didn't start with JumpMind SymmetricDS, I actually started using it at a job when I was a little more introduced to… more »
    Top Answer:How often do you need for your data to be synchronized? I'm asking this because different companies use data replication… more »
    Top Answer:I architected solutions using Oracle SOA/OSB, Spring Boot, MuleSoft Anypoint Platform on cloud / on-premises and hybrid… more »
    Top Answer:Our organization ran comparison tests to determine whether TIBCO BusinessWorks or Mule Anypoint platform integration and… more »
    Top Answer: This is a very flexible solution that comes with multiple uses. My organization mostly uses Mule Anypoint Platform for… more »
    Top Answer:SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called… 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… more »
    Ranking
    13th
    out of 31 in Data Replication
    Views
    289
    Comparisons
    181
    Reviews
    0
    Average Words per Review
    0
    Rating
    N/A
    3rd
    Views
    5,228
    Comparisons
    3,103
    Reviews
    21
    Average Words per Review
    547
    Rating
    8.5
    2nd
    out of 100 in Data Integration
    Views
    19,568
    Comparisons
    15,878
    Reviews
    35
    Average Words per Review
    471
    Rating
    7.7
    Comparisons
    Also Known As
    SymmetricDS
    Data Integrator
    SQL Server Integration Services
    Learn More
    Overview

    JumpMind SymmetricDS is a powerful data replication software that provides synchronization software solutions for both databases and filesystems. This software is platform-independent and web-enabled as well as database agnostic. JumpMind SymmetricDS creates prompt bi-directional data replication while scaling to a large amount of nodes and working in close to real time across both WAN and LAN networks. This allows companies to integrate data using the feature for continuous change data capture.

    This data replication software allows companies with limited network bandwidth or bad connectivity to benefit from excellent cloud conditions. The greatest benefit of JumpMind SymmetricDS is its vast integration across databases, streaming platforms, and data warehouses. Some of the relational databases where this data replication software can be used include Oracle, PostgreSQL, MySQL, Sybase, Informix, Ingres, Tiber, and VoltDB. NoSQL databases like MongoDB, Apache Cassandra, and Azure Cosmos are also compatible with the JumpMind SymmetricDS data replication software. The data warehouses that are compatible with this software include Teradata, SAP HANA, Azure-SQL server by Microsoft, BigQuery, Amazon Redshift, Pivotal Greenplum, and Snowflake data warehouse. Providing coverage of so many databases and warehouses allows broad outreach of the JumpMind SymmetricDS across many different companies and users.

    JumpMind SymmetricDS Features

    JumpMind SymmetricDS offers many valuable features, including:

    • Easy setup and configuration processes: JumpMind SymmetricDS’s web interface allows even beginners to grasp its basic functions. There is an option for a configuration tour, which provides an explanation of how changes can be applied. This feature helps experienced specialists to operate faster while also providing guidance on usage for complete beginners.

    • Flexible data replication: Users can synchronize data across remote networks' nodes with low bandwidth usage, allowing their configuration as well as that of groups.

    • Monitoring and troubleshooting: JumpMind SymmetricDS users can access graphically visualized data replication through the main dashboard, allowing them to identify any errors and resolve them in a timely manner.

    • File synchronization: Users can run continuous or periodic synchronization of the copying their files between multiple nodes. The synchronization can wait during periods of downtime and resume once the network is available.

    • Performance and scaling: JumpMind SymmetricDS quickly synchronizes data with a large number of databases.

    Other features include tools for conflict detection and resolution, embedding and extending, filtering, subsetting, and transforming.

    JumpMind SymmetricDS Benefits

    The benefits of using JumpMind SymmetricDS include:

    • Ability to replicate thousands of databases and file systems in near real time
    • Support of a wide range of database platforms, data warehouses, and operating systems
    • Many value-added features

    Reviews from Real Users

    According to the CEO at a non-profit, JumpMind SymmetricsDS is fully featured and is also very easy to use and install. He finds it to be self-explanatory to use and says that their support is very good.

    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
    SmartMD, Cancer Research UK
    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
    VISITORS READING REVIEWS
    Computer Software Company20%
    Retailer11%
    Financial Services Firm10%
    Manufacturing Company8%
    REVIEWERS
    Computer Software Company33%
    Healthcare Company11%
    Recruiting/Hr Firm11%
    Comms Service Provider6%
    VISITORS READING REVIEWS
    Educational Organization21%
    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
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise18%
    Large Enterprise64%
    REVIEWERS
    Small Business30%
    Midsize Enterprise21%
    Large Enterprise49%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise28%
    Large Enterprise57%
    REVIEWERS
    Small Business27%
    Midsize Enterprise18%
    Large Enterprise55%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    Buyer's Guide
    Cloud Data Integration
    March 2024
    Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration. Updated: March 2024.
    768,578 professionals have used our research since 2012.