Set up a source endpoint for SAP Application (DB)

Before you can configure the SAP Application (DB) endpoint, you first need to configure one of the following backend source endpoints, according to your SAP Package type:

• Oracle

  Information note

  When using Oracle as the backend database, any tables you want to capture must be defined with ALL COLUMN SUPPLEMENTAL LOGGING.

  See also: Using Oracle as a source

• Microsoft SQL Server

  Information note

  When using Microsoft SQL Server as the backend database, transparent table fields defined as STRING or BINARY STRING are not supported.

  See also: Using Microsoft SQL Server as a source

• IBM DB2 for LUW

  See also: Using IBM DB2 for LUW as a source

• IBM DB2 for z/OS

  See also: Using IBM DB2 for z/OS as a source

• SAP HANA

  Information note

  When using SAP HANA as the backend database, change capture is supported using Log-based CDC only, and with the following limitations:

  • Replicate creates a hana__row_id column on the target as a Unique Index and changes the original Primary Key/Unique Index to a standard column.
  • Table DDLs are not supported and will be ignored
  • Replication of transparent tables only is supported

  • The Apply Conflicts error-handling policy for No record found for applying DELETE and No record found for applying an UPDATE must be st to Ignore record.

  See also: Using SAP HANA as a source

For information about general limitations when using the SAP Application (DB) endpoint, see Limitations and considerations.

Backend Source Endpoint Permissions

The user specified in the underlying source endpoint settings must have SELECT permission on the following objects:

• DD02L

• DD03L

• DD02T

• DD03T

• T000

• /HTG/GC_HEAD

• /HTG/GC_TABLES1

• /HTG/GC4R_BUSGRP

• /HTG/GC4R_TABLES