Gluesync 2.1.1 released: custom code execution with User Defined Functions

Gluesync 2.1.1 has arrived, bringing powerful new capabilities to this real-time data integration platform. This update introduces User Defined Functions (UDFs) for custom code execution during replication and adds comprehensive TRUNCATE operations support. Following the initial 2.1 release that introduced Groups and Chains, this version delivers on the promised phased rollout with key features that provide unprecedented control over data transformations.

What’s new in 2.1.1

User Defined Functions (UDFs): transform your data with custom code

The flagship enhancement in Gluesync 2.1.1 is User Defined Functions (UDFs), enabling developers to write custom code scripts that execute during data replication. These scripts are verified and compiled by the platform, allowing for implementation of sophisticated business logic on data as it flows through the system.

UDFs hook into three critical events during replication:

• insert operations: process and transform new records as they’re created
• update operations: apply business rules when existing records are modified
• delete operations: implement custom logic when records are removed

This event-based model provides precise control over data transformation workflows before data reaches its destination. Gluesync 2.1.1 supports Java for UDF development, with Kotlin, JavaScript and Python support coming soon.

Learn more about User Defined Functions.

Allowed Operations: control which database actions synchronize

The new “Allowed Operations” feature delivers granular control over which database operations synchronize between source and target systems. This enhancement replaces the previous “Skip Deletions” feature with a more comprehensive approach.

Administrators can now selectively enable or disable specific operations:

• INSERT: control creation of new records
• UPDATE: manage modification of existing records
• DELETE: control removal of records
• TRUNCATE: manage table truncation operations

This flexibility enables specialized configurations for various use cases:

• History tables: disable DELETE and TRUNCATE to maintain complete audit trails
• Data archiving: enable only INSERT to accumulate historical data
• Read-only replicas: enable INSERT and UPDATE while preventing deletions

Learn more about Allowed Operations

TRUNCATE operations support enhances data management

TRUNCATE operations are now fully supported in Gluesync for compatible database agents, offering two key capabilities:

• TRUNCATE before Snapshot: clear target tables before snapshot execution, configurable per task
• TRUNCATE command forwarding: automatically propagate TRUNCATE operations from source to target databases (with agent-level disable option)

Additional performance improvements and enhancements

• Chronos scheduler now supports Snapshot mode in both INSERT and UPSERT modes
• Improved data type mapping with family-based handling (Numbers, Dates, Strings) allowing more flexible column mapping within the same type family
• Redesigned Objects Browser’s Fields editor (phase 1) for improved usability

Comprehensive data integration with Groups and Chains

These new features complement the Groups and Chains capabilities introduced in Gluesync 2.1, creating a more robust platform for enterprise data integration. While Groups organize related entities for simplified management and Chains define execution order for maintaining referential integrity, the new UDFs and Allowed Operations features deliver deeper control over data transformation processes.

Together, these capabilities address the most challenging aspects of complex data integration scenarios:

• data organization: simplified with logical Groups
• dependency management: streamlined through ordered Chains
• custom transformations: enabled by flexible UDFs
• operation control: fine-tuned with Allowed Operations settings

Enterprise-ready data integration platform

Gluesync 2.1.1 represents a significant advancement in data integration technology. By addressing both organizational challenges and transformation requirements, this release helps enterprises manage data pipelines with greater efficiency and precision.

The introduction of User Defined Functions enables sophisticated business logic implementation during replication, while the new Allowed Operations feature provides granular control over synchronized database operations.

Upgrading to Gluesync 2.1.1

Existing Gluesync users can upgrade to version 2.1.1 through their customer portal. New users can sign up for a 30-day trial to experience Gluesync’s enterprise data integration capabilities.

For complete details on all features, improvements and fixes in this release, review the Gluesync 2.1.1 release notes.