What’s New in SymmetricDS 3.2

What’s New in SymmetricDS Pro 3.2

The new release of SymmetricDS 3.2 will help you:

• Sync data with the SQLite database
• Integrate with enterprise and remote systems
• Handle new types of synchronization scenarios
• Track historical changes for auditing
• Configure and troubleshoot more productively

Sync Data with SQLite

With the addition of support for the SQLite database, SymmetricDS Pro can now synchronize data between 13 database platforms! Sync data with SQLite on both Android mobile and desktop systems. SQLite is a compact, serverless database that runs cross-platform and “just works.” Especially suited for low-memory, low-overhead environments, the combination of SymmetricDS Pro and SQLite provide a powerful application synchronization solution. Leverage all the features of SymmetricDS, including guaranteed data delivery, filtered synchronization, data transformation, and offline mode.

Send Change Data Over S/FTP

Capture change data and send it to remote systems over File Transfer Protocol (FTP) or Secure FTP (SFTP). Integrate changes made on local databases to a Software as a Service (SaaS) provider. Change data is written to comma-separated value (CSV) files and transferred over S/FTP to the remote server using the same guaranteed delivery mechanism used for batches.

Synthetic Keys

Sync tables with a synthetic key instead of using the primary key. Configure a synthetic key to specify which columns to use in statements that update or delete rows. While the primary key identifies the unique row in the database, there may be additional unique constraints on the table that further limit how data is populated. The source and target databases may be designed with different primary keys, which presents a challenge when syncing data. To sync data between these systems, the synthetic key can be configured to include all columns that make rows unique across both systems.

LDAP Authentication

Integrate the SymmetricDS Pro web console login with a lightweight directory access protocol (LDAP) server for single sign-on. Users maintain their credentials in the LDAP server so they have only one login to remember. Authorization to use the console is granted by an administrator of SymmetricDS. Users are assigned a role that gives them read-only or write access to screens.

Geometry Data Types

Support for new data types to sync geometric data on SQL-Server and MySQL. Geometric data types represent two-dimensional spatial objects, such as points, lines, segments, boxes, circles, and polygons. By using the well-known text (WKT) format, SymmetricDS can capture and sync geometric data between SQL-Server, MySQL, Oracle, PostgreSQL, and Greenplum.

Audit Tables

Leverage the change data capture system to record the history of changes in audit tables. An audit table is named after the original table with a suffix of “_AUDIT” and contains the original columns with additional columns to track the sequence, time, and change type. To audit a table, the user configures a trigger and audit router. The audit table and triggers are automatically created and maintained.

Support Tool

Take a snapshot of the system in a single file that can be sent to support for assistance and troubleshooting. A new screen lets the user create a snapshot file and keep a list of past snapshots. Each snapshot is a ZIP archive containing configuration, system properties, runtime information, and log files that can be sent as a single compressed attachment to support services.

Updated GUI

Navigate through screens more easily to view information and make configuration changes. Screens that previously displayed multiple panels together have been broken apart to simplify appearance and reduce scrolling. Users are presented with a summary listing from which they can drill into edit and detail screens.