Preface
Part 1: PowerExchange CDC Introduction
- Change Data Capture Introduction
Part 2: PowerExchange CDC Components
- PowerExchange Listener
- PowerExchange Logger for Linux, UNIX, and Windows
Part 3: PowerExchange CDC Data Sources
Part 4: Change Data Extraction
Part 5: Monitoring and Tuning
- Monitoring CDC Sessions
- Tuning CDC Sessions
Appendix A: DTL__CAPXTIMESTAMP Time Stamps
- Time Stamps That Are Reported in the DTL__CAPXTIMESTAMP Field by Data Source

CDC Guide for Linux, UNIX, and Windows

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

Back Next

Manually Creating the Log Tables

When PowerExchange for SAP HANA CDC starts, it uses the SAP HANA CDC user ID to connect to the source database and checks for the PKLOG and PROCESSED tables. If these tables do not exist, PowerExchange creates them using the SAP HANA user's schema.

If you prefer, you can connect to the database with the SAP HANA CDC user ID and create the tables manually, with the following commands:

CREATE COLUMN TABLE PKLOG (…);
CREATE COLUMN TABLE PROCESSED (…);

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Manually Creating the Log Tables

Manually Creating the Log Tables