SAP HANA agent for Gluesync: real-time CDC for SAP environments

SAP HANA is a cornerstone of modern enterprise architectures, powering critical business applications and high-performance analytics. Enabling real-time data movement in and out of SAP HANA is essential for organizations looking to feed downstream data lakes, cloud data warehouses or synchronize data across hybrid environments.

Following the introduction of SAP HANA as a target destination in version 2.2.5, MOLO17 a is proud to announce that the SAP HANA agent for Gluesync is now fully complete. With the latest release, we are introducing real-time Change Data Capture (CDC) source capabilities, making SAP HANA a fully supported Source and Target agent within the Gluesync ecosystem.

Shadow table CDC for SAP HANA

When acting as a source, the SAP HANA agent implements the Change Data Capture (CDC) technique using shadow audit tables. The agent creates and manages shadow tables that capture all DML operations (INSERT, UPDATE, DELETE).

By tracking specific columns (OPERATION, COMMIT_ID and COMMIT_TIME), Gluesync polls these tables to capture changes. The source change retention period is configurable (defaulting to 5 days) to manage shadow table size.

Key features of the SAP HANA agent

As a target, the SAP HANA agent integrates seamlessly into the Gluesync Control Plane and includes several core technical features:

• Official JDBC connectivity: the agent establishes a secure connection using the bundled, official SAP HANA JDBC driver (ngdbc) with full TLS support.
• Comprehensive CDC and Snapshots: supports both full-table snapshots for initial data seeding and continuous CDC for real-time synchronization.
• Configurable retention: the internal cache retention period for CDC tracking tables is fully configurable (defaulting to 5 days), allowing administrators to optimize database storage.
• Advanced data type support: fully supports SAP HANA user-defined types (UDTs) and complex data structures.
• TRUNCATE operation support: the agent can capture and forward TRUNCATE operations to target destinations, ensuring perfect schema alignment.

Seamless integration within Gluesync pipelines

Once configured, the SAP HANA agent acts as a native source or target within the Gluesync ecosystem.

Whether you are migrating workloads or building real-time analytics dashboards, the SAP HANA agent provides a scalable and production-ready approach to unlock your SAP data.

To explore configuration details and prerequisites, refer to the official documentation for the SAP HANA agent.