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

JumpMind SymmetricDS vs Oracle GoldenGate 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:
 

Mindshare comparison

Data Replication Market Share Distribution
ProductMarket Share (%)
JumpMind SymmetricDS3.2%
NetApp SnapMirror6.6%
NetApp Snapshot5.6%
Other84.6%
Data Replication
Data Integration Market Share Distribution
ProductMarket Share (%)
Oracle GoldenGate1.7%
SSIS3.7%
Informatica Intelligent Data Management Cloud (IDMC)3.5%
Other91.1%
Data Integration
Data Integration Market Share Distribution
ProductMarket Share (%)
SSIS3.7%
Informatica Intelligent Data Management Cloud (IDMC)3.5%
Informatica PowerCenter3.4%
Other89.4%
Data Integration
 

Featured Reviews

reviewer1625691 - PeerSpot reviewer
CEO at a non-profit with 1-10 employees
Fully-featured, good performance, and easy to use and install
We are using it to back up the software across the network to a remote server It is fully featured. It has allowed me to do everything I wanted to do. It is also very easy to use and install. It is pretty self-explanatory, and their support was also very good. Everything is fine. The user…
EmmanuelCatalano - PeerSpot reviewer
DBA at a tech services company with 5,001-10,000 employees
Real-time data streaming has simplified transformations and kept enterprise databases synchronized
Oracle GoldenGate is good, but I would like to improve it. There is a need for whoever installs and configures Oracle GoldenGate to set the correct parameters for the use cases we need to use. In some cases, we had performance problems related to the streaming because there was a lot of information to stream concurrently. However, you can tune Oracle GoldenGate to use more RAM on the source side or more processes. I think that sometimes what is missing is knowledge about the tool from the person responsible for configuration. At this moment, Oracle GoldenGate is a very good tool, and I do not know in which area we can improve it. Perhaps the debug part of the tool could be improved. In some cases, I use the utility for how Oracle GoldenGate generates messages about the statements that it streams because of bugs, and in some cases, it is not very user-friendly. It may be possible to improve the API or the path related to debugging, but not the tool itself. The tool itself is good. I remember that in some configurations, we had problems with the streaming of DDL, which are changes to Oracle object structures such as tables and procedures. A new feature could be to perform streaming for operational objects such as procedures, functions, packages, or grants. This would synchronize source and target for these aspects, not only for data or the main types of structures, but also for others. I remember that there was some configuration in which you performed the streaming of the entire schema, or if you performed streaming for only tables, then you were unable to stream grants and other Oracle objects. I think it is important to introduce that capability.
Chris Farris - PeerSpot reviewer
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
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

"It is fully featured. It has allowed me to do everything I wanted to do."
"One feature that stands out for me is the data center capability."
"The solution's existing SaaS platform for data integration gives us an edge."
"When we are replicating data between similar databases then it is straightforward."
"The CDC feature is interesting."
"We can replicate data across different data centers and different technologies."
"It allows us to migrate from one system to another, from one server to another, with no downtime, no outage. We can get the data synchronized with multiple databases and then switch the connectivity across to the new servers."
"The platform's most helpful features are its speed and its guarantee of data replication from one database to another."
"The product's microservice architecture is scalable."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The initial setup of this solution is very straightforward."
"The performance and stability are good."
"Overall, it's a good product."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"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."
 

Cons

"The user interface could improve. We are looking at some cloud-based databases, and I don't think they support that."
"Lacks the ability to become a full-scale ETL tool."
"The front-end management isn't very good."
"For Oracle GoldenGate, customers face challenges with patching, the latest updates, and encountering bugs."
"In the future, I would appreciate a more user-friendly monitoring interface for easier management and troubleshooting."
"I would like to see the interface more graphical and easier to use."
"Regarding improvements, the focus should be on addressing data quality issues and minimizing delays, particularly in Oracle databases. The technical support should be improved as well. Additionally, in terms of features, it would be great if the solution could support APIs. The support is not friendly. They don’t respond on time."
"The solution, in general, should be easier to use, with less need to perform workarounds within the system."
"The tool's connections are disconnected at times. The tool needs to integrate other databases."
"The solution could improve by having quicker release updates."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"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."
"We have issues with SSIS connectors while extracting data from Excel sources."
 

Pricing and Cost Advice

Information not available
"It is an expensive product."
"The tool needs to improve its pricing."
"Pricing is based on anual licensing with additional costs for support packages."
"The tool is a bit expensive."
"We have purchased corporate licensing to use Oracle GoldenGate."
"The solution would be costly for a small organization."
"The one feature that I think Oracle could perhaps consider is, at the moment, the Veridata option is an extra cost. Golden Gate is an expensive product. You pay a lot for the best. But not including the Veridata license to prove that everything is working correctly... The big improvement for me would be to have that license built in. That would take it to the next level. That would make it a much better product. You may want to look at buying term licenses if you've just got a single migration to do. In that situation, you might want a term license for perhaps a year to save a lot of money, rather than buying a perpetual license."
"Oracle GoldenGate's cost is high."
"All of my clients have this product included as part of their Microsoft license."
"The solution is available at a lesser price than that of Informatica."
"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."
"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."
"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."
"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."
"We purchased the standard edition of SQL Server and SSIS came with it free of charge."
report
Use our free recommendation engine to learn which Data Replication solutions are best for your needs.
881,821 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
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…
 

Top Industries

By visitors reading reviews
Computer Software Company
12%
Manufacturing Company
10%
Retailer
9%
Healthcare Company
9%
Financial Services Firm
21%
Manufacturing Company
8%
Computer Software Company
7%
Government
6%
Financial Services Firm
16%
Computer Software Company
9%
Government
8%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business22
Midsize Enterprise5
Large Enterprise30
By reviewers
Company SizeCount
Small Business27
Midsize Enterprise19
Large Enterprise57
 

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 se...
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...
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 replicat...
What do you like most about Oracle GoldenGate?
The product is reliable for data integrity.
What is your experience regarding pricing and costs for Oracle GoldenGate?
The pricing of Oracle GoldenGate depends on the discount we receive from Oracle. If the customer orders a larger quan...
What needs improvement with Oracle GoldenGate?
Oracle GoldenGate is good, but I would like to improve it. There is a need for whoever installs and configures Oracle...
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?
Pricing is pretty reasonable, so I would rate it at a 5. However, it could be a bit cheaper.
 

Also Known As

SymmetricDS
GoldenGate
SQL Server Integration Services
 

Overview

 

Sample Customers

SmartMD, Cancer Research UK
Japan Exchange Group, Daewoo E&C, Herbalife, Starwood Hotels & Resorts, Canon, Turk Telekom
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 NetApp, Fivetran, Dell Technologies and others in Data Replication. Updated: January 2026.
881,821 professionals have used our research since 2012.