JumpMind logo

SymmetricDS Database Replication and Integration

Data Synchronization

Multiple database replication is fast and easy with SymmetricDS

Multiple Platforms

Multiple database platforms supported by SymmetricDS

Data Transformation

Duplicate, merge, and modify data during synchronization with SymmetricDS

Download SymmetricDS Pro

Easy and reliable database replication with proven success in production. Download the free trial software!


SymmetricDS is the leading open source software for Data Replication, Change Data Capture, and Data Transformation in a heterogeneous enterprise environment. Performance and scalability allow it to replicate thousands of databases asynchronously in near real time. With flexible configuration and powerful scripting and programming interfaces, SymmetricDS can be extended to meet a range of data synchronization requirements.


Key Features

DATABASE

  • Support for most major database vendors and open source databases.
  • Trigger-based Change Data Capture (CDC) system replicates data in near real time with low system overhead.
  • Transaction awareness groups row changes to be committed together.

DATA REPLICATION

  • Flexible configuration enables one-way, bi-directional, 2-tier, and n-tier data synchronization using periodic (pull) or immediate (push) delivery.
  • Horizontal and vertical data filtering allows a subset of a table to be synchronized.
  • Built-in transformation and filtering allows translation of values, addition of new values, filtering of sensitive data and mapping of columns.
  • Compressed and optionally encrypted streaming data format.
  • Initial data load prepares the remote database for synchronizing changes.

USER

  • Scripting support for easy data transformation.
  • Plug-in Java programming interface allows customizations and extensions.
  • Multiple deployment options include a standalone server, web application server, and embedded application.
  • Web-based management and monitoring console.

Business Benefits

  • Guarantee data replication without requiring special drivers or modifications to database applications.
  • Combine, consolidate, and / or backup heterogeneous data across the enterprise.
  • Improve accessibility of critical business data by providing a highly available environment..
  • Protect sensitive data by filtering it from operational data and routing it to authorized recipients.
  • Improve data integration performance and make efficient use of network bandwidth.
  • Massage, cleanse, and enhance data in real time to make better business decisions sooner.

Flexible Replication

All of the features and performance of SymmetricDS are available with data replication between databases from different vendors. Individual tables can be selected for data replication in one direction or both. Configuration allows table or column names in one database to be different from the other, and extra or missing columns can be configured with a default or calculated value. Replicate an entire table or choose a subset of data to synchronize, either specifying rows (horizontal) or columns (vertical). For even more control, configure a script or use the Java API to filter and transform data.




Professional Support

A production environment demands dependable, expert resources to provide technical assistance, troubleshoot problems, and fix defects. A Support Subscription from JumpMind provides access to highly skilled support engineers with guaranteed response times.

Multiple Platforms Supported

Databases Supported

  • Oracle
  • IBM DB2
  • MS SQL Server
  • MySQL
  • Informix
  • Interbase
  • PostgreSQL
  • Firebird
  • Apache Derby
  • HSQLDB
  • H2
  • Greenplum
  • SQLite


System Requirements

  • Windows, Linux, Solaris, or Mac OS X
  • Java Runtime Environment

Production Support Options

Basic Support

Resolve from 5 to 15 technical issues per year with 2-day initial response. Available for smaller installations only.


Standard Support

Resolve unlimited issues with 6-hour high priority initial response during business hours.


Enterprise Support

Resolve unlimited issues with enhanced 2-hour Priority 1 initial response around the clock.



Follow us on: Facebook Twitter LinkedIn

Stay Up To Date & Subscribe: Contact RSS