Article

Gluesync 2.2.9: Query Studio, Universal File Store Agent, Filed Functions and more

2026-06-30 · /gluesync/gluesync-2-2-9/

Gluesync 2.2.9 is now generally available: the latest release of our cloud-native, real-time data replication and hybrid integration platform is here.

This milestone update delivers major enhancements across several strategic areas designed to simplify developer workflows, modernize the Control Plane experience, expand connectivity options and provide greater visibility into data replication operations.

Here is a comprehensive overview of the headline capabilities available in Gluesync 2.2.9.

Query studio: your SQL workbench, embedded

Data platform engineers and DBAs have long faced operational friction when validating real-time streaming results, often switching between external SQL clients and multiple tools.

query studio

Query Studio is a full-featured, web-based SQL workbench embedded directly inside the Control Plane, running within Gluesync’s Core Hub.

  • Secure remote queries: safely query remote databases in private subnets without requiring direct client connectivity.
  • Developer tooling: multi-tab editor, dialect-aware autocomplete and lazy-loaded schema browser.
  • Advanced analysis: real-time query progress via WebSocket, explain plan visualization (text or tree), client-side query statistics and export capabilities.
  • Enterprise safety: read-only mode by default, optional write mode for authorized roles (SUPER ADMIN / MANAGER), saved queries and 90-day query auditing.

All-new Dashboard UI and pipeline “warm up” status

Version 2.2.9 introduces a redesigned Control Plane UI focused on usability, performance and improved navigation across complex environments.

dashboard UI

The new interface streamlines pipeline and entity management, reduces unnecessary scrolling, improves loading performance and preserves user preferences for collapsed or expanded entity groups across sessions. The entity details page has also been redesigned with clearer status indicators and smoother visual feedback.

Version 2.2.9 also introduces a new Warm Up pipeline status. When a pipeline starts or resumes, the UI now explicitly indicates that agents are initializing connections, providing greater visibility during startup operations.

Universal file store agent

Version 2.2.9 introduces the Universal File Store Agent, enabling real-time replication to a broad range of file storage systems through seven supported transport mechanisms:

  • FTP
  • FTPS
  • SFTP
  • WebDAV
  • WebDAVS
  • SMB/CIFS
  • Local NFS mounts

The agent writes data in Apache Parquet (default), line-delimited JSON, or CSV formats. Sidecar JSON metadata files accompany generated files to preserve schema information and support auditing, making the agent suitable for analytics platforms, file-based integrations and data lake architectures.

Native DB2 LUW support via transaction logs

Gluesync expands its Change Data Capture (CDC) capabilities with a new IBM Db2 LUW agent based on transaction log parsing, providing an alternative to the existing trigger-based approach.

  • Log-based cdc: captures changes directly from transaction logs outside the SQL execution path.
  • Architecture: uses a custom native C library (libdb2.so) together with the GS_SP_LOGMINER stored procedure to decode transaction logs.
  • Rich change metadata: captures transaction identifiers, timestamps, operation types and session user information.
  • Broad compatibility: supports IBM Db2 for LUW 11.5 and later (including Community Edition), in both single-instance and partitioned database environments.

Field Functions: no code data transformations

Gluesync 2.2.9 introduces Field Functions, a library of built-in transformations that engineers can apply directly within the visual Fields Editor without writing custom Java code.

Teams can perform type conversions, string manipulation, date and time formatting, timezone handling, numeric casting, byte encoding, metadata injection and data masking through a simple configuration interface, making it easier to adapt data while it flows through replication pipelines.

Gluesync mobile

Extending operational control beyond the desktop, version 2.2.9 marks the official release of Gluesync Mobile, the companion application for monitoring replication environments from mobile devices.

Gluesync mobile

Using existing Gluesync credentials, users can securely monitor pipeline status, inspect entity health and review synchronization information from both iOS and Android devices without requiring a desktop workstation.

Security hardening

Version 2.2.9 also strengthens the platform’s security posture by:

  • migrating the base operating system layer to Fedora;
  • replacing the legacy Logback Logstash dependency with a custom implementation that removes a critical CVE;
  • updating third-party dependencies to address additional security vulnerabilities.

Deploy Gluesync 2.2.9 today

Gluesync 2.2.9 is fully production-ready and available for deployment across cloud, virtualized or containerized Kubernetes and OpenShift infrastructures.

Review full configuration schemas, architecture blueprints and changelogs on our Gluesync Documentation Hub.

Ready to test these new capabilities inside your infrastructure? Skip the theoretical reading: request a free 30-day trial today.

Back to blog