CDC Guide for Linux, UNIX, and Windows

10.5.2
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

SAP HANA Data Sources

PowerExchange CDC for SAP HANA captures inserts, updates, and deletes from SAP HANA tables on Windows or Linux. Because SAP HANA does not provide direct access to its log files, the capture process uses triggers on source tables to determine when to capture change data

The PowerExchange Navigator can optionally create scripts for the PKLOG and PROCESSED log tables and trigger DDL when you create capture registrations for the source tables. If you do not use the Navigator to create the tables, PowerExchange creates the log tables and triggers when the extraction process runs.

The triggers write insert, update, and delete changes to the PKLOG transaction log table. These changes are read in table order and are then available for extraction to PowerCenter CDC sessions or PowerExchange CDC Publisher. PowerExchange provides only after-image records for SAP HANA CDC.

Each source table must have a primary key.

PowerExchange CDC Data Sources

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal