SymmetricDS is the leading open source solution for Data Replication, Change Data Capture, and Data Transformation in a heterogeneous enterprise environment. Database changes are captured in one or more databases and streamed across the network to update other databases with similar schemas.
SymmetricDS was designed for environments which may incur network outages and has the performance and scalability needed to replicate to thousands of databases. With flexible configuration and powerful scripting and programming interfaces, SymmetricDS can be extended to meet a wide range of business requirements.
A business that depends on data from multiple databases needs a data integration solution that is designed to work across platforms. SymmetricDS works with major database systems as well as with databases geared towards smaller and embedded systems. For example, it might be deployed on Oracle in the central office and MySQL in the remote office.
SymmetricDS can run on any system with a Java Runtime Environment. It is adaptable and can run on small memory systems and can scale to support large central installations.
Tables are assigned to logical channels that allow replication to continue on most channels when another channel has an error. All incoming and outgoing data is assigned a batch number that is acknowledged for tracking and guarantees replication. Channels in error are retried while not blocking other channels, thereby allowing replication to continue whenever possible. If a system operates offline for days or weeks, once reconnected SymmetricDS recovers and sends all saved data replications.
Nearly every feature of SymmetricDS is available when replicating between databases from different vendors. Individual tables can be selected for 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, either specifying rows (horizontal) or columns (vertical). For even more control, configure a script or use the Java API to filter and transform data.
SymmetricDS has proven successful in business situations that require fast and reliable database replication across local and wide area networks. It is used in the following solutions:
|Data from multiple databases across the enterprise are synchronized and combined, working across low- bandwidth connections and withstanding periods of network outage. Thousands of databases can be connected to a central one using one or more tiers of synchronization.|
|The operational database is replicated to a data warehouse or a reporting database. The main application continues to use the operational database, while the reporting database is used for and analytical and reporting purposes. The replication may be a subset of the operational data, if desired.|
|Data is transformed during replication between different databases. Secure web transport protocols are used to replicate from a protected database to a front-end database.|
|Critical database applications are protected by continuously replicating to a standby database. Changes are sent to the standby, which may be on a local or wide area network. In an emergency, the application is reconnected to the standby database. Once the production database is available again, SymmetricDS will replicate changes to it from the standby. The switch-over can also be used to perform planned maintenance and system upgrades. Since SymmetricDS is flexible enough to replicate between different databases and table layouts, some tables of the upgraded database may have new columns in old tables|
A production environment demands dependable, expert resources to provide technical assistance and troubleshoot problems. A Support Subscription from JumpMind provides access to highly skilled support engineers with guaranteed response times.