Sybase ASE Agent for Gluesync: Features Overview

Index

Core principles

This agent establishes a connection to SAP (Sybase) ASE via a built-in JDBC driver.

Change data capture

To get delta changes feed from Sybase, this Gluesync agent implementes triggers-based auditing structure, which is auto-installing and fully managed by Gluesync.

To read more about this trigger auditing structure we invite you to check out our full deep-dive on it by reading the Source data from SAP (Sybase) ASE chapter.

Supported versions

Gluesync works on SAP (Sybase) ASE starting from version 15.7.

Platform supported features

Feature	Support	Notes
Target role	✅	Writes to SAP (Sybase) ASE via the bundled JDBC driver with TLS and pooling.
Source role	✅	Captures changes via the trigger-based auditing layer auto-managed by Gluesync.
Snapshots	✅	Snapshot jobs seed ASE tables before CDC resumes.
CDC	✅	Trigger auditing streams committed INSERT/UPDATE/DELETE events.
CDC type	Database triggers + CDC table	Triggers write row identifiers and CRUD metadata into the Gluesync-managed tables.
User defined data types	✅	Supports user defined data types.
Bulk load	❌	Not supported.
Source persisted internal cache	❌	Source agent does not implement caching.
Target persisted internal cache	❌	Writes go directly to ASE; no additional cache is needed.
Driver / connector	Built-in JDBC driver	Vendor driver bundled with Gluesync for ASE connectivity.
Chains	N/A	Not yet supported.
Truncate operation support (reading)	❌	Trigger logic does not detect TRUNCATE-like operations.
Truncate operation support (writing)	✅	Honors the Core Hub “TRUNCATE before snapshot” option when enabled.

Feature

Support

Notes

Target role

✅

Writes to SAP (Sybase) ASE via the bundled JDBC driver with TLS and pooling.

Source role

✅

Captures changes via the trigger-based auditing layer auto-managed by Gluesync.

Snapshots

✅

Snapshot jobs seed ASE tables before CDC resumes.

CDC

✅

Trigger auditing streams committed INSERT/UPDATE/DELETE events.

CDC type

Database triggers + CDC table

Triggers write row identifiers and CRUD metadata into the Gluesync-managed tables.

User defined data types

✅

Supports user defined data types.

Bulk load

❌

Not supported.

Source persisted internal cache

❌

Source agent does not implement caching.

Target persisted internal cache

❌

Writes go directly to ASE; no additional cache is needed.

Driver / connector

Built-in JDBC driver

Vendor driver bundled with Gluesync for ASE connectivity.

Chains

N/A

Not yet supported.

Truncate operation support (reading)

❌

Trigger logic does not detect TRUNCATE-like operations.

Truncate operation support (writing)

✅

Honors the Core Hub “TRUNCATE before snapshot” option when enabled.

Q&A

I have got Sybase ASE, is it supported? We do support and tested Sybase ASE (Advanced Server Enterprise) starting from version 15.7, we expect the older version to work too but are currently not yet tested.

I have got Sybase / SAP SQL Anywhere, is it supported? SAP SQL Anywhere should work but has currently not yet been tested. Please, if you would like to help us on that do not hesitate to drop us a line and you’ll get a free year of Gluesync Enterprise!