Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange CDC Introduction
  3. Part 2: PowerExchange CDC Components
  4. Part 3: PowerExchange CDC Data Sources
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Manually Creating the Log Tables

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 in 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 (INSERT_SEQ bigint primary key GENERATED BY DEFAULT AS IDENTITY,CHANGE_TS timestamp, SCHEMA_NAME nvarchar(256), CHANGE_TYPE varchar(1), PK1 nvarchar(256), PK2 nvarchar(256), PK3 nvarchar(256), PK4 nvarchar(256), PK5 nvarchar(256), PK6 nvarchar(256), PK7 nvarchar(256), PK8 nvarchar(256), PK9 nvarchar(256), PK10 nvarchar(256), PK11 nvarchar(256), PK12 nvarchar(256), PK13 nvarchar(256), PK14 nvarchar(256), PK15 nvarchar(256), PK16 nvarchar(256), TRANSACTIONID bigint, TRANSACTION_SEQ integer, TABLE_NAME nvarchar(256), HAS_SHADOW_TABLE boolean, PROCESSED_SEQ bigint,APPLICATION_USER nvarchar(256)); CREATE COLUMN TABLE PROCESSED (MAXIMUM_PROCESSED_SEQ bigint); INSERT INTO PROCESSED(MAXIMUM_PROCESSED_SEQ) values(0); COMMIT;

0 COMMENTS

We’d like to hear from you!