What’s New in SymmetricDS 3.15

The new release of SymmetricDS Pro 3.15 data replication software enhances change data capture, uses algorithmic recommendations for optimization, and includes data validation with compare and repair.  This release will help you:

• Compare and repair data between two or more databases
• Optimize and enhance the system with insights
• Replicate data from MariaDB and DB2 for i using log mining
• Capture data from and load data to Progress OpenEdge database
• Secure access to web console users with new permissions and login capabilities

Compare and Repair

Compare and repair data between a source database and one or more target databases.  Select which tables to compare, the level of inspection, a schedule to run, and a report level with the option to repair data.  Comparison uses checksums at a table or chunk level to minimize use of the network before matching at the row level.  The number of parallel threads are selected per request and per server to help improve comparison performance.  A report of matching, different, missing, and extra rows is produced, including a SQL file of changes that are viewable or applied automatically to the target database.

Insights

Optimize and enhance data replication performance using proactive recommendations that can take action on behalf of the user when approved.  The user can choose to approve actions, schedule reminders for a later time, or dismiss them.  Insights are collected across all nodes in the system and use pattern matching and rules collected from support cases.

Log Mining from MariaDB and DB2 for i

Flexible database replication lets you choose between log-based or trigger-based change data capture for MariaDB and DB2 for i (AS/400, iSeries) databases. Log mining uses the binary log from MariaDB and journals from DB2 for i.  Log-based data replication is now an option when minimal overhead and high throughput are required.  The node wizard sets up log-based replication and guides you through required database permissions.  The same powerful configurations are available for either option, including selection of tables, columns, data subsets, conflict management, and data transformation.

Progress OpenEdge Change Data Capture

Replicate changes from Progress OpenEdge database or load data from multiple data sources into it. OpenEdge is a relational database management system with a 4GL programming language for building business applications. Integrate OpenEdge into your enterprise data strategy with data replication and streaming ETL functionality. This dialect has bi-directional support that includes change data capture, sub-setting, transformations, and initial loads.

Security Improvements

Secure access to web console users with new permissions for creating users and logging in.  Users can be put into a hierarchy of roles, giving them permission to create or modify users at or below their current role, giving a department responsibility for its own users.  To safeguard and audit production access, a “break glass” user can be created that requires another user to break the glass for a temporary, time-limited password.  Users can now login with single sign-on (SSO) using the SAML security standard with a third party identity provider.