Required permissions

This section lists which permissions are required for Replicate to be able to capture changes from SAP HANA.

When using trigger-based CDC

Grant SELECT and TRIGGER on the SAP schema containing the selected source tables to the user specified in the SAP HANA source endpoint.
If the attrep_cdc_changes table is created in a schema owned by the user specified in the SAP HANA source endpoint settings (the default), no further permissions are required.
If the attrep_cdc_changes table is created in a schema not owned by the user specified in the endpoint settings, grant SELECT, INSERT, UPDATE and DELETE on the attrep_cdc_changes table to the specified user.

Grant SELECT permission on the selected source tables
Grant the CATALOG_READ permission
Encrypted logs - To be able to read encrypted logs, Replicate should be able to access root key backups or the Replicate user should be granted the ENCRYPTION ROOT KEY ADMIN permission.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!