how-to

  • Capture all change events into an event table

    In addition to replicating data changes from source to target you may also wish to populate a table on the target to monitor all events.  In this blog I will show you how to create a simple load filter that will record all changes captured by SymmetricDS into a simple audit table.  

  • Easier Data Transformation with SymmetricDS 2.0

    SymmetricDS has always provided hooks for data transformation, but in 2.x we have made it far easier to add custom data transformations with just a bit of XML configuration and simple transformation scripts.

  • Publishing Messages from Data Synchronization

    More and more JumpMind is enhancing SymmetricDS with new data integration features that leverage SymmetricDS’s Change Data Capture capabilities for replication, synchronization, and transformation of data from one system to another. In this article, we will cover how to use the data replication server to map data into a JMS message destination, which could be part of an enterprise strategy for SOA Data Integration and Messaging.

  • Resolving Conflicts with SymmetricDS Pro 3.0

    Detecting and resolving data conflicts is easy with SymmetricDS Pro 3.0. I'll show you how to detect and fix conflicts manually, then we'll setup a resolver so the newest update wins automatically. The web console with SymmetricDS Pro makes all of this easy to accomplish.

  • SymmetricDS 2.4 Data Transformation Overview and Examples

    SymmetricDS has for years been a robust, reliable solution for synchronizing data between multiple databases and multiple database platforms. With SymmetricDS 2.4, SymmetricDS has expanded to also prove data transformation capabilities while synchronizing. The data transformation is performed via configuration settings in new SymmetricDS configuration tables, in a manner consistent with and familiar to existing SymmetricDS users.

  • Sync Relational Databases to NoSQL like MongoDB

    Here we will walk through the steps to send data from a relational database to MongoDB using SymmetricDS. Since SymmetricDS is trigger based and there are not triggers in MongoDB data can only synchronized to a MongoDB instance.

  • Synchronizing Android Applications - Part 1

    SymmetricDS now has its web-enabled, fault-tolerant, database synchronization software available on the Android mobile computing platform. The Android client follows all of the same concepts and brings to Android all of the same core SymmetricDS features as the full-featured, Java-based SymmetricDS client. The client is designed to be referenced as a library to run in-process with an Android application requiring synchronization for its SQLite database.

  • Synchronizing Android Applications - Part 2

    This is the second part of a series on synchronizing Android SQLite databases using SymmetricDS. The last article talked about how to embed the SymmetricDS Android client into an Android application. This article will provide an overview of the central server and how it can be configured to synchronize the sample Notepad database.

  • Synchronizing uniCenta oPOS

    SymmetricDS is flexible enough to be used in a variety of situations, one of which being retail. UniCenta is an open-sourced POS system that is used all across the globe. Synchronization of uniCenta oPOS and SymmetricDS is not only fully supported, but it is also quite simple.

  • Using Wildcards to Sync Database Tables

    Quickly select and dynamically add tables to database synchronization using wildcard characters. This powerful feature can save time during configuration and even eliminate the need to make changes to configuration in the future. Since data capture triggers can be created from a schedule or on-demand programmatically, wildcard characters open up the possibility of new applications, such as using SymmetricDS database replication in Platform As A Service (PaaS) where new tables created by a client are automatically replicated between high availability servers. This article will demonstrate using wildcard characters to sync some tables while ignoring others.