JumpMind SymmetricDS vs Oracle GoldenGate vs SSIS comparison

Cancel
You must select at least 2 products to compare!
JumpMind Logo
288 views|178 comparisons
100% willing to recommend
Oracle Logo
10,169 views|7,322 comparisons
96% 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 JumpMind SymmetricDS, Oracle GoldenGate, and SSIS based on real PeerSpot user reviews.

Find out what your peers are saying about NetApp, Fivetran, Dell Technologies and others in Data Replication.
To learn more, read our detailed Data Replication Report (Updated: April 2024).
769,630 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 →

"You can put data together from a few databases into one database or the other way, from one database into several. It transforms data in real-time.""The solution's existing SaaS platform for data integration gives us an edge.""GoldenGate can connect and collect data from multiple sources, such as SQL Server.""We use the tool to pull on-prem data.""What I like most about Oracle GoldenGate is that it supports cross-platform migrations. For example, Oracle GoldenGate could pump data from one type of system to another such as the data from Oracle DB to SQL Db2.""The product's initial setup phase was very simple.""CDC is the most valuable feature.""Since the world is going towards open source, the solution's heterogeneous data migration feature is very useful."

More Oracle GoldenGate Pros →

"The performance and stability are good.""Like most Microsoft products, SSIS is user-friendly and easy to use.""SSIS integrates well with SQL servers and Microsoft products.""The performance is good.""The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT.""It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world.""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.""The most valuable features of SSIS are that it works with the query language and it can import data from different sources."

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 →

"What needs improvement in Oracle GoldenGate is the support. Another feature that needs to be improved in the solution is its GUI. It would be useful for programmers or users to be able to work from the GUI, not just from the command line. Simplifying how Oracle GoldenGate is used would also make the solution better.""In the future, I would appreciate a more user-friendly monitoring interface for easier management and troubleshooting.""The solution's licensing price is very expensive and could be made more competitive.""Lacks the ability to become a full-scale ETL tool.""It's stable but you have to know how to maintain it. That's why it's not 10 out of 10 for me. There are some bugs, there are some issues here and there. All of a sudden your process is not working and you have to figure out why, and sometimes it's not so clear.""There are a lot of bugs in the solution.""The main problem of Oracle GoldenGate is that sometimes, the processes get abended. Data consistency is also challenging.""Microservices Architecture is not user-friendly."

More Oracle GoldenGate Cons →

"Improving the login procedure would make our reporting easier on monitoring our ETL processes.""The creation of the measure in the DAC's model could be improved.""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.""In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade.""I would like to see more standard components out of the box, such as SFTP, and Data Compression components.""It's a legacy tool, that is nearing the end of its useful life.""I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process.""We would like the solution to be expanded so that it is available for other platforms than just Microsoft."

More SSIS Cons →

Pricing and Cost Advice
Information Not Available
  • "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."
  • "The licensing model should be improved to be more cost-effective for the end users."
  • "We do like the price of this solution."
  • "Pricing is based on anual licensing with additional costs for support packages."
  • "The price of this solution is good."
  • "We have an enterprise license for it. It might be for three years or so. I'm not aware of any additional costs to the standard licensing fee."
  • "Its price can be better. It is a bit crazy, and its licensing is very difficult to understand. I would rate it one out of five in terms of pricing. There don't seem to be any additional costs."
  • "We have purchased corporate licensing to use Oracle GoldenGate."
  • More Oracle GoldenGate 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 Data Replication solutions are best for your needs.
    769,630 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:The product is reliable for data integrity.
    Top Answer:It's a middleware. The price depends on the customers and the number of licenses they buy.
    Top Answer:Microservices Architecture is not user-friendly. It would have been great if the product would have stayed with the… 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
    288
    Comparisons
    178
    Reviews
    0
    Average Words per Review
    0
    Rating
    N/A
    6th
    out of 101 in Data Integration
    Views
    10,169
    Comparisons
    7,322
    Reviews
    26
    Average Words per Review
    388
    Rating
    8.2
    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
    SymmetricDS
    GoldenGate
    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.

    Oracle GoldenGate is a real-time data integration and database replication solution. It can detect data events and route them across networks at very low latencies and integrates well with 100s of combinations of non-Oracle databases, data stores, and clouds.

    Oracle GoldenGate Features

    Oracle GoldenGate has many valuable key features, including:

    • Simple to use web interface
    • Fast and easy installation or provisioning
    • Command line access via AdminClient that can run anywhere
    • RESTful APIs for DevOps
    • Offers built-in monitoring but also can be easily adapted to roll your own monitoring
    • APIs are protected by Cross Site Request Forgery (CSRF) authentication.

    Oracle GoldenGate Benefits

    Some of the benefits of using Oracle GoldenGate include:

    • Oracle GoldenGate is deeply integrated with the Oracle Database (logging, redo, backup and recovery layer, security, administration, data guard, data vault, autonomous database etc.).

    • It is the most stable, performant, and reliable CDC / replication solution for Oracle.

    • High performance: Oracle GoldenGate is capable of sub-second latency for data movement. featuring low impact capture, routing, transformation, and delivery of transactional data.

    • GoldenGate is the only CDC / replication tool that keeps pace with new and emerging innovations (security, features, data types, etc) in the core Oracle Database.

    • The solution supports a wide range of use cases, from conventional OLTP data replication and high availability to data lake ingestion or multi-cloud ingestion, SaaS application replication, and messaging replication.
    • GoldenGate is the only CDC / replication technology certified for Exadata, Exadata Cloud Service, and Exadata Cloud at Customer.

    • For fault-tolerance, GoldenGate has its own mechanism to keep track of how much work is completed and how much is pending. This mechanism is independent of any database and ensures, with the help of automatic gap-resolution, that no data loss occurs.

    • GoldenGate uses its own proprietary format files for keeping the committed data coming from the source database, making it independently functional irrespective of the database in use.

    • To maintain the performance and consistency, only committed data is sent. Uncommitted data is captured by GoldenGate, but is discarded after receiving a Rollback.

    • With GoldenGate, data sending is in “near real time,” which reduces the possibility of latency.

    Reviews from Real Users

    Below are some reviews and helpful feedback written by Oracle GoldenGate users.

    PeerSpot user Steve-J., Cloud Migration Software Consultant - UK & EMEA at 1PLACE, says, "What I have found the most valuable about GoldenGate is that it does real-time and no-downtime migrations. Its migrations are fast. There are not many tools like it on the marketplace."

    Pinak S., Senior Manager of System and Database at ESL, mentions, “We like how in GoldenGate the heterogeneous database is supported. Sometimes the client actually needs a schedule and needs to ensure the state of databases for reporting purposes. With that in mind, we have been able to configure GoldenGate for certain schema. The solution is quite stable. They've recently improved the ease of implementation.”

    A Database Administrator at a manufacturing company explains, "It moves the data as you set it up, and it works. I am also very impressed with its stability and scalability. It is not super feature-rich, but the new releases have more functionality. It recently had more native integrations with Oracle Database. If you are using it against an Oracle database, it has a lot more functionality."

    An Oracle ERP DBA Consultant - Oracle Super Cluster T5-8 Admin at a government comments, "GoldenGate can connect and collect data from multiple sources, such as SQL Server."






    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
    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
    Top Industries
    VISITORS READING REVIEWS
    Computer Software Company20%
    Retailer11%
    Financial Services Firm10%
    Manufacturing Company8%
    REVIEWERS
    Computer Software Company19%
    Financial Services Firm19%
    Healthcare Company12%
    Comms Service Provider8%
    VISITORS READING REVIEWS
    Financial Services Firm22%
    Computer Software Company13%
    Manufacturing Company8%
    Government7%
    REVIEWERS
    Financial Services Firm23%
    Healthcare Company8%
    Computer Software Company8%
    Manufacturing Company8%
    VISITORS READING REVIEWS
    Financial Services Firm18%
    Computer Software Company12%
    Government7%
    Healthcare Company6%
    Company Size
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise18%
    Large Enterprise64%
    REVIEWERS
    Small Business42%
    Midsize Enterprise8%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise11%
    Large Enterprise73%
    REVIEWERS
    Small Business27%
    Midsize Enterprise17%
    Large Enterprise56%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    Buyer's Guide
    Data Replication
    April 2024
    Find out what your peers are saying about NetApp, Fivetran, Dell Technologies and others in Data Replication. Updated: April 2024.
    769,630 professionals have used our research since 2012.