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 Data Integrator (ODI) is a data integration software solution that provides a unified infrastructure to streamline data and application integration projects. It uses a powerful design approach to data integration, which separates the declarative rules from the implementation details. The solution is based on a unique ELT (Extract Load Transform) architecture, eliminating the need for a standalone ETL server and proprietary engine.
Oracle Data Integrator Features
ODI has many valuable key features. Some of the most useful ones include:
- Automatic documentation generation
- Visualization of data flows in the interfaces
- Customization of generated code
- Automatic reverse-engineering of existing applications or databases
- Graphical development and maintenance of transformation and integration interfaces
- Robust data integrity control features, assuring the consistency and correctness of data
- Powerful core differentiators
- Heterogeneous ELT, declarative design and knowledge modules
- Flexibility and modularity
- Oracle Data Integrator repository
- Topology navigator
- Operator Navigator
- Security Navigator
- Integrator Console
- ODI domains
Oracle Data Integrator Benefits
There are many benefits to implementing ODI. Some of the biggest advantages the solution offers include:
-
Efficient architecture: Oracle Data Integrator has a simple architecture that utilizes the source and target servers to perform complex transformations, making it an efficient solution.
-
Supports all platforms: ODI gives you platform independence by supporting all platforms, hardware, and OSes with the same software.
-
Cost-effective: Oracle Data Integrator reduces costs associated with initial hardware and software acquisition, and also decreases maintenance costs because it eliminates the need for an ETL Server and an ETL engine.
-
Automatic detection of faulty data: By using ODI, faulty data is recycled before insertion in the target application, providing you with a data quality firewall.
-
Easy development and maintenance: With a low learning curve, Oracle Data Integrator increases developer productivity while facilitating ongoing maintenance.
-
Active integration: ODI includes all styles of data integration: data-based, event-based and service-based.
Reviews from Real Users
Below are some reviews and helpful feedback written by PeerSpot users currently using the Oracle Data Integrator (ODI) solution.
Brian D., Business Process and Strategy Specialist Advisor at NTTData, says, “The Knowledge Module (KM) is my favorite feature of ODI. This is where I learned how to use variables to make jobs dynamic. I took that knowledge and created a KM that would go into iTunes and pull the sales of eBooks. Making something that is reusable, like a KM, is important to not only reduce build time but also maintenance in the future.”
Ashok S., Applications Support Manager at a marketing services firm, mentions, "The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
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."
SmartMD, Cancer Research UK
Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Japan Exchange Group, Daewoo E&C, Herbalife, Starwood Hotels & Resorts, Canon, Turk Telekom