JumpMind SymmetricDS vs SSIS comparison

The compared JumpMind and Microsoft solutions aren't in the same category. JumpMind is ranked #16 in DR , and holds a 1.5% mindshare in the category. Microsoft is ranked #4 in DI , with an average rating of 8.0, and holds a 8.6% mindshare. Additionally, 100% of JumpMind users are willing to recommend the solution, compared to 80% of Microsoft users who would recommend it.

JumpMind SymmetricDS

Read 2 JumpMind SymmetricDS reviews

213 Views
130 Comparison Views

100% willing to recommend

SSIS

Read 71 SSIS reviews

14,990 Views
12,034 Comparison Views

80% willing to recommend

JumpMind SymmetricDS

SSIS

Comparison Buyer's Guide

Download the report

Executive Summary

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

Find out in this report how the two Data Replication solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed JumpMind SymmetricDS vs. SSIS Report (Updated: October 2024).

Buyer's Guide

JumpMind SymmetricDS vs. SSIS

October 2024

Download the complete report

Helped 816,406 peers since 2012

Categories and Ranking

JumpMind SymmetricDS

Average Rating

9.0

Number of Reviews

Ranking in other categories

Data Replication (16th)

SSIS

Average Rating

7.8

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Integration (4th)

Mindshare comparison

JumpMind SymmetricDS and SSIS aren’t in the same category and serve different purposes. JumpMind SymmetricDS is designed for Data Replication and holds a mindshare of 1.5%, down 2.3% compared to last year.
SSIS, on the other hand, focuses on Data Integration, holds 8.6% mindshare, down 9.6% since last year.

Data Replication

Data Integration

Featured Reviews

it_user186621

Senior Manager of IT at a retailer with 10,001+ employees

Excellent change data capture utility for distributed multi site environment

Customer Service: We have a support contract with Jumpmind. The support resources are readily available and provide expert support to any questions. Technical Support: Jumpmind created and open sourced this solution. All the key players are still actively involved with the technology and provide answers to all our open questions. The consistency we receive from their support is second to none.

Read full review

Sakiru Dosumu

Head, Development Chapter (DevOps) at First Bank of Nigeria Ltd.

Its ability to transform and transport data is extremely valuable

he ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs.

Read full 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."

"The most valuable feature of the solution is performance."

"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."

"It has good data integration and good processes."

"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."

"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."

"It's saved time using visualization descriptions."

"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."

"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."

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."

"Future releases should improve the data lineage, as it currently is not good."

"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."

"I would like to see more features in terms of the integration with Azure Data Factory."

"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."

"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."

"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."

"Improving the login procedure would make our reporting easier on monitoring our ETL processes."

"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."

More SSIS cons

Pricing and Cost Advice

Information not available

"The solution comes free of cost."

"We purchased the standard edition of SQL Server and SSIS came with it free of charge."

"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."

"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."

"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."

"This solution has provided an inexpensive tool, and it is easy to find experienced developers."

"People have to opt for a perpetual-based licensing model."

More SSIS pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Data Replication solutions are best for your needs.

See recommendations

816,406 professionals have used our research since 2012.

Comparison Review

it_user90069

BI Expert at a healthcare company with 1,001-5,000 employees

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…

Read full review

Top Industries

By visitors reading reviews

Computer Software Company

21%

Financial Services Firm

11%

Retailer

10%

Manufacturing Company

Financial Services Firm

17%

Computer Software Company

12%

Government

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

Does JumpMind SymmetricDS support a large array of databases?

Yes, it does. This data replication software works with many popular databases, allowing users to benefit from its services. What's more, it also works with many data warehouses, as well as streami...

See all answers

Is JumpMind SymmetricDS easy to use for beginners?

I didn't start with JumpMind SymmetricDS, I actually started using it at a job when I was a little more introduced to data replication. That made me able to see the good features this software has....

See all answers

Does JumpMind SymmetricDS provide frequent file synchronization?

How often do you need for your data to be synchronized? I'm asking this because different companies use data replication for different purposes. Some use it as simply updating backup, others to giv...

See all answers

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...

See all answers

What do you like most about SSIS?

The product's deployment phase is easy.

See all answers

What is your experience regarding pricing and costs for SSIS?

The solution comes free of cost.

See all answers

Comparisons

Oracle GoldenGate vs JumpMind SymmetricDS

Compared 39% of the time

AWS Database Migration Service vs JumpMind SymmetricDS

Compared 10% of the time

Confluent vs JumpMind SymmetricDS

Compared 8% of the time

Oracle GoldenGate Cloud Service vs JumpMind SymmetricDS

Compared 8% of the time

Qlik Replicate vs JumpMind SymmetricDS

Compared 7% of the time

More JumpMind SymmetricDS Competitors

Informatica PowerCenter vs SSIS

Compared 24% of the time

Talend Open Studio vs SSIS

Compared 13% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 7% of the time

AWS Glue vs SSIS

Compared 5% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

Data Replication

November 2024

Download JumpMind SymmetricDS product report

Buyer's Guide

SSIS

October 2024

Download SSIS product report

Also Known As

SymmetricDS

SQL Server Integration Services

Learn More

JumpMind

Microsoft

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.

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

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

Buyer's Guide

JumpMind SymmetricDS vs. SSIS

October 2024

Free Report: JumpMind SymmetricDS vs. SSIS

Find out what your peers are saying about JumpMind SymmetricDS vs. SSIS and other solutions. Updated: October 2024.

DOWNLOAD NOW

816,406 professionals have used our research since 2012.

See our JumpMind SymmetricDS vs. SSIS report.

We monitor all Data Replication 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.