The way we innovate with data is constantly evolving. Since SAP HANA Cloud QRC 04/2024, SAP HANA Cloud has supported read-only access to external Delta Sharing with a dedicated deltasharing adapter, as I introduced in my previous blog. This capability has been instrumental in enabling real-time analytics without physically moving data, unlocking efficiency and delivering faster insights. But what if your business cases demand not just seamless access but also replication of critical datasets into SAP HANA Cloud for deeper analysis, faster queries, or advanced integration?
That’s where Delta table-to-HANA replication comes in. Starting with SAP HANA Cloud QRC 04/2025, I’m glad to introduce this new capability, which provides more flexibility to replicate your Delta table directly into the SAP HANA database in SAP HANA Cloud, empowering your analytics with greater speed, reliability, and robust data management.
In a nutshell, the new Delta table-to-HANA replication has the following capabilities and characteristics:
Remote subscription-based initial load and Change Data Capture (CDC) for both file adapter and deltasharing adapter.Support for either chunk-based, user-driven initial load or streamlined, one-step initial load.Support for either user-driven CDC or system-scheduled CDC using the replication job scheduler.Offer both column-wise and row-wise sub-table replication while enabling source-side schema changes (adding columns only).In addition to normal load behavior, UPSERT load behavior with three additional metadata columns: type, last-processed time, and Delta table version.Simplified replication with virtual table toggling and Data Replication UI for the deltasharing adapter in addition to the remote subscription-based replication.
The way we innovate with data is constantly evolving. Since SAP HANA Cloud QRC 04/2024, SAP HANA Cloud has supported read-only access to external Delta Sharing with a dedicated deltasharing adapter, as I introduced in my previous blog. This capability has been instrumental in enabling real-time analytics without physically moving data, unlocking efficiency and delivering faster insights. But what if your business cases demand not just seamless access but also replication of critical datasets into SAP HANA Cloud for deeper analysis, faster queries, or advanced integration?That’s where Delta table-to-HANA replication comes in. Starting with SAP HANA Cloud QRC 04/2025, I’m glad to introduce this new capability, which provides more flexibility to replicate your Delta table directly into the SAP HANA database in SAP HANA Cloud, empowering your analytics with greater speed, reliability, and robust data management.In a nutshell, the new Delta table-to-HANA replication has the following capabilities and characteristics:Remote subscription-based initial load and Change Data Capture (CDC) for both file adapter and deltasharing adapter.Support for either chunk-based, user-driven initial load or streamlined, one-step initial load.Support for either user-driven CDC or system-scheduled CDC using the replication job scheduler.Offer both column-wise and row-wise sub-table replication while enabling source-side schema changes (adding columns only).In addition to normal load behavior, UPSERT load behavior with three additional metadata columns: type, last-processed time, and Delta table version.Simplified replication with virtual table toggling and Data Replication UI for the deltasharing adapter in addition to the remote subscription-based replication. Read More Technology Blog Posts by SAP articles
#SAP
#SAPTechnologyblog
