Gluesync 2.2.5: high-speed snapshots, SAP HANA support and Oracle trigger-based CDC enhancements

The latest Gluesync 2.2.5 release is now live. Building on the connection pooling and IBM i native API advancements we introduced in version 2.2.4, this version introduces significant performance optimizations for RDBMS snapshots, the arrival of SAP HANA as a target and a refined transaction flow for Oracle trigger-based environments.

Massive snapshot performance improvements

To reduce time-to-value during initial data loads, we’ve re-engineered the snapshot engine for all RDBMS source agents. These updates focus on maximizing throughput while minimizing database round-trips:

• expanded query pre-fetch: we increased the default pre-fetch size tenfold, from 1,000 to 10,000 rows, significantly reducing network overhead during massive data ingestion.
• configurable parallelism: we enabled query parallelism by default (set to 4), and you can fully adjust it via the agent configuration to match your source database’s capabilities.
• reduced round-trips: optimized operational flows ensure faster execution of snapshot queries.

New target: SAP HANA

We are expanding our ecosystem with the introduction of the SAP HANA target agent. This allows Gluesync to stream real-time data directly into SAP HANA environments, enabling high-performance analytics and integration within SAP landscapes. We are currently developing support for SAP HANA as a source and will include it in an upcoming release.

Enhancements for Oracle and trigger-based agents

Our source agents relying on trigger-based auditing are receiving a significant update, starting with the Oracle Triggers agent:

• optimized transaction flow: improved transaction confirmation logic lowers the overall network footprint.
• enhanced indexing: better index management ensures that auditing tables remain performant even under heavy write workloads.
• LogMiner improvements: the Oracle LogMiner agent has also been refined to handle larger transactions in parallel with improved error handling.

Core Hub & UI refinements

We updated the Gluesync Core Hub and UI to improve stability and resource management:

• UDF performance: significant stability and performance improvements for User Defined Functions (UDFs), achieving up to 3x faster processing in typical workloads.
• UI workflow: added logic to open new tabs for the notification hub and fixed UI state issues when reloading agent configurations.

Maintenance & fixes

This release consolidates several incremental updates from the 2.2.4 branch, including fixes for Parquet file writing (GSSD-778), Chronicle Queue metadata access on Windows (GSSD-800) and improved backpressure handling for cloud storage agents (Azure Data Lake, AWS S3 and GCS).

Get started with Gluesync 2.2.5

You can access Gluesync 2.2.5 today. For a complete list of changes, improvements and bug fixes, please visit our official documentation.

Want to see Gluesync in action? Contact us for a demo.