What’s New in SymmetricDS 3.11

The new release of SymmetricDS Pro 3.11 will help you:

• Replicate changes from Oracle using logs or triggers
• Enhance routing performance
• Deploy to SAP HANA database with data loads and changes
• Setup nodes for load and extract only with no runtime footprint
• Troubleshoot network problems between nodes

Log-based Replication for Oracle

Flexible database replication lets you choose between log-based or trigger-based change data capture for Oracle databases. Log-based data replication is now an option when requirements include minimal overhead in the database and high throughput of data replication. The node wizard sets up log replication and guides you through database permissions needed for log mining. The same powerful configurations are available for either option, including selecting tables, columns, data subsets, conflict management, and data transformation.

Routing Enhancements

Routing performance is improved with enhanced sub-setting of data and background processing of initial loads. Common batches are now used exclusively to package and send change data for multiple nodes, which reduces the number of data events generated. Previously, a change being routed to 1000 nodes might generate 1000 batches and 1000 data events — now, only 1 data event is generated for a common batch. Any subset of nodes returned from a router can receive a common batch. Initial loads are now processed from a separate job in the background, which leaves the routing job available to process change data.

SAP HANA Support

Replicate data to and from SAP HANA database, a business data platform for on-premise or cloud that processes transactions and analytics at the same time. Use initial loads, partial loads, and change data capture with HANA to integrate data across different database platforms. Securely replicate data across hybrid and multi-cloud environments to leverage fast data processing, OLAP, and OLTP with a consolidated data platform. Leverage a rich feature set, including guaranteed data delivery, filtered synchronization, data transformation, and offline mode.

Load Only, Extract Only

When change data capture from your database isn’t supported or it’s not needed, you can use the load-only or extract-only options during node setup. Instead of using your database to store runtime information, an internal database is used to keep track of state, progress, and statistics, so the web console retains all its usual functionality for monitoring and troubleshooting. The load wizard lets you send or receive full or partial data loads with other nodes. Use custom jobs to schedule full data loads or use filtering criteria to extract changes by date range.

Network Diagnostics

The nodes panel can now test the network connection between two nodes to help troubleshoot networking and deployment problems. It uses the same transport configured between the nodes, either a push or pull, to establish a connection for diagnostics. The connection is tested for valid hostname, URL, port number, TLS certificate, HTTP options, and bandwidth.