Gluesync 2.2.10: federated SQL querying with Query Forge, advanced scheduling in Chronos and redesigned Control Plane

Gluesync 2.2.10 is now generally available. This release transforms Gluesync from a pure low-latency replication engine into a unified data integration platform.

Version 2.2.10 introduces federated SQL querying across heterogeneous databases, enterprise-grade workflow orchestration. In addition, it brings automated pipeline creation and role-based access control across key management modules.

Below, you will find a comprehensive overview of the headline capabilities available in Gluesync 2.2.10.

Query Forge: federated SQL querying without data movement

Traditional data integration architectures often force engineering teams to build complex ETL pipelines or stand up dedicated data warehouses just to query distributed datasets. Query Forge turns Gluesync Core Hub into a secure, federated SQL gateway.

With a brand-new dedicated JDBC driver (jdbc:gluesync://), developers and data analysts can connect standard BI tools like DBeaver, DataGrip, or Tableau to Core Hub. As a result, they can run cross-agent SQL JOINs across isolated databases as if they were a single unified system.

Key capabilities of Query Forge include:

• Personal API Token authentication: Gated strictly behind long-lived Personal API Tokens (gsp_…) with zero shared credentials or password-based fallback.
• Fine-grained permission scoping: Access is restricted at the pipeline and agent level. Therefore, users only discover schemas and tables they are authorized to view.
• Zero-copy read-only operations: All federated queries run in read-only mode, guaranteeing source database safety.
• Intelligent workload pushdown: Leverages filter and column projection pushdowns powered by Apache Calcite and Avatica, sending only necessary rows across the network.

Chronos workflow orchestration: chained events, webhooks and security

Chronos, Gluesync’s job scheduling module, undergoes a major architectural upgrade in 2.2.10. Moving beyond simple time-based execution, Chronos now functions as an enterprise orchestration engine capable of managing complex event sequences.

Key enhancements in Chronos include:

• Synchronous and asynchronous event chaining: Execute multi-step operational flows sequentially in synchronous or asynchronous modes. For example, you can complete an initial snapshot before launching real-time CDC.
• Webhook triggers and platform events: External systems can trigger Chronos jobs via secure incoming webhooks. At the same time, Core Hub platform events (such as pipeline status modifications) automatically trigger scheduled workflows without poll-based overhead.
• Performance optimizations: Faster startup times achieved through batch query loading (resolving N+1 query bottlenecks), cached timezone resolution and pre-calculated execution schedules.
• Endpoint security hardening: Every Chronos API endpoint is secured using JWT authentication validated directly against Core Hub, enforced via Role-Based Access Control (RBAC).

Redesigned pipeline creation wizard

To streamline pipeline configuration and eliminate manual configuration errors, version 2.2.10 introduces a completely rebuilt pipeline creation wizard.

Improvements include:

• Step-by-step guided workflow: Navigates users cleanly from source selection to target mapping.
• Automated metadata pre-filling: Automatically retrieves backend agent metadata to populate connection parameters, schemas and table lists.
• Real-time form validation: Powered by react-hook-form and yup, catching syntax and configuration mistakes prior to deployment.

Modernized Control Plane UI: Scheduler, Modules Manager and Role-Based Access Control

Version 2.2.10 extends full User Role integration (SUPER ADMIN, MANAGER, MONITOR and VIEWER) across two newly redesigned operational interfaces:

New Scheduler UI

Features a visual chained-events editor, support for weekly and custom CRON syntax, timezone configuration and on-demand execution.

New Modules Manager UI

Provides a centralized view of all orchestrated agents, modules, and third-party services. Thus, operators can monitor health statuses at a glance (Healthy, Error, Updating, Update Available), filter services by family, and perform lifecycle actions (Start, Restart, Stop, Remove) according to their assigned role.

Additional platform improvements

• Core Hub: Added Personal API Token support for the JDBC gateway, optional SMTP client disabling, local log collection with database export, table reorganization event types and external module user role authorization.
• Conductor (v0.10.0): Integrated token introspection, route-level authorization guards, sensitive data redaction for non-admin accounts and strict read-only modes for VIEWER roles.
• UI & UX: Added primary key uniqueness checks, automatic hiding of empty schemas, clear object browser distinctions between tables, views and members and user-customizable notification retention settings.
• Database Agents: Added pending resource releaser for locked cache files, bulk load support for Vertica, alongside stability improvements for Couchbase and Oracle LogMiner agents.

Deploy Gluesync 2.2.10 today

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

To review full configuration schemas, architecture blueprints and setup guides for Query Forge, consult the official Gluesync Documentation.

Ready to experience federated SQL querying and advanced pipeline orchestration inside your infrastructure? Skip the theoretical reading: request a free 30-day trial today.