SAP HANA Agent for Gluesync: Features Overview

Index

Core principles

This agent establishes a connection to SAP HANA via the official SAP HANA JDBC driver (ngdbc).

Change data capture

Gluesync consumes changes from SAP HANA by implementing the CDC (Change Data Capture) technique using shadow audit tables. The agent creates and manages shadow tables that capture all DML operations (INSERT, UPDATE, DELETE) on source tables with columns OPERATION, COMMIT_ID, and COMMIT_TIME.

Supported version

With this agent, you can target SAP HANA 2.0 SPS04 and above, including SAP HANA Cloud.

Platform supported features

Feature	Support	Notes
Target role	✅	Writes to SAP HANA through the bundled SAP HANA JDBC driver (ngdbc) with TLS support.
Source role	✅	Reads changes via shadow table CDC using automatically managed auditing tables.
Snapshots	✅	Supports full-table snapshots for initial syncs or periodic reseeding.
CDC	✅	Captures changes using shadow tables with automatic cleanup of processed events.
CDC type	Shadow tables with change tracking	Uses shadow audit tables with OPERATION, COMMIT_ID, and COMMIT_TIME columns to track changes.
User defined data types	✅	Supports SAP HANA user defined types and complex data types.
Bulk load	✅	Uses MERGE statements for high-performance batch UPSERT operations.
Source persisted internal cache	✅	Configurable change retention period (default 5 days) for CDC tracking tables.
Target persisted internal cache	N/A	Writes go directly to SAP HANA without intermediate file buffers.
Driver / connector	SAP HANA JDBC driver (ngdbc)	Gluesync packages the official SAP HANA JDBC driver for secure connectivity.
Chains	N/A	Not supported.
Truncate operation support (reading)	✅	Source agent can capture and forward TRUNCATE operations to the target.
Truncate operation support (writing)	✅	Supports Core Hub’s "TRUNCATE before snapshot" option when acting as a target.

Feature

Support

Notes

Target role

✅

Writes to SAP HANA through the bundled SAP HANA JDBC driver (ngdbc) with TLS support.

Source role

✅

Reads changes via shadow table CDC using automatically managed auditing tables.

Snapshots

✅

Supports full-table snapshots for initial syncs or periodic reseeding.

CDC

✅

Captures changes using shadow tables with automatic cleanup of processed events.

CDC type

Shadow tables with change tracking

Uses shadow audit tables with OPERATION, COMMIT_ID, and COMMIT_TIME columns to track changes.

User defined data types

✅

Supports SAP HANA user defined types and complex data types.

Bulk load

✅

Uses MERGE statements for high-performance batch UPSERT operations.

Source persisted internal cache

✅

Configurable change retention period (default 5 days) for CDC tracking tables.

Target persisted internal cache

N/A

Writes go directly to SAP HANA without intermediate file buffers.

Driver / connector

SAP HANA JDBC driver (ngdbc)

Gluesync packages the official SAP HANA JDBC driver for secure connectivity.

Chains

N/A

Not supported.

Truncate operation support (reading)

✅

Source agent can capture and forward TRUNCATE operations to the target.

Truncate operation support (writing)

✅

Supports Core Hub’s "TRUNCATE before snapshot" option when acting as a target.

Change data capture

Works with SAP HANA 2.0 SPS04 and above, including SAP HANA Cloud.

Architecture notes

Shadow table CDC: The agent creates shadow audit tables that track changes with OPERATION (I/U/D), COMMIT_ID, and COMMIT_TIME columns. Gluesync polls these tables to capture changes.
Configurable retention: Source change retention period is configurable (default 5 days) to manage shadow table size.
MERGE for UPSERT: Target operations use SAP HANA’s MERGE statement for efficient INSERT/UPDATE batch operations.
Schema flexibility: Supports both row store and column store tables.