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. Most SAP HANA datatypes are supported.

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. Each registered SAP HANA source table must have a primary key.

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.

To prepare SAP HANA source for CDC, perform the following tasks:

To configure PowerExchange for SAP HANA sources, specify the new HANA CAPI_CONNECTION statement in the dbmover.cfg configuration file. Also, create capture registrations and extraction maps for the source tables by using either the PowerExchange Navigator or DTLUCBRG utility. Both interfaces have been enhanced to support SAP HANA sources.

Also, PowerExchange requires an ODBC driver and a JDBC driver for SAP HANA to retrieve source metadata from the SAP HANA database server.

For more information, see the

PowerExchange CDC Guide for Linux, UNIX, and Windows

, the

PowerExchange Navigator User Guide

, and

PowerExchange Utilities Guide

.