What’s New in SymmetricDS 3.6

What’s New in SymmetricDS Pro 3.6

The new release of SymmetricDS 3.6 will help you:

• Improve performance of scripted extensions
• Bulk load data into MySQL and other databases
• Integrate with MongoDB documents and collections
• Synchronize data to Amazon Redshift data warehouse
• Improve performance of file synchronization

Compile On-The-Fly Plug-Ins

Configure routers, transforms, and load filters with Java syntax that is compiled to bytecode on first use and further optimized to native code by the Just-In-Time (JIT) compiler. These plug-in points have both a BeanShell and a Java option now, giving the user a choice between loosely typed, quick scripting and a stricter, compiled language when performance is important. Either way, the ability to extend the behavior of routing, transforming, and filtering of data is a powerful feature.

MySQL Bulk Loader

When loading data to a MySQL database, select the bulk loader option to use a faster path into the database. Bulk loaders can be enabled at the channel level, making it possible to enable bulk loading for specific channels, like the initial load channel, while using the default JDBC loader on other channels. The feature works when MySQL is on another server, but additional performance can be gained by colocating on the same server. This release also improved compatibility and speed of the bulk loaders for SQL Server and PostgreSQL databases.

MongoDB Data Loader

Load relational data into MongoDB documents and collections using a data loader configured for a channel. Use the standard mapping of relational column values into document name/value pairs, or use transformations to select columns and define different names. Extension points are also exposed to wire in Java classes for custom behavior.

Amazon Redshift

Sync data into the Redshift database, the Amazon-managed massively parallel processing data warehouse in the cloud. Benefit from high performance analytic workloads, large datasets, and cost savings over traditional data warehouse solutions.
Bulk load with an initial load feature that uses Amazon Simple Storage Service (S3), then keep changes synchronized continuously in near real time.

More Flexible

File synchronization has improved scalability using concurrent locking to support more clients. Control files are a new feature that can be used to control when file sync will pick up a file by the same name. Dynamic channels were added to support more use cases where multiple reload channels are needed.