(Glue-2202) Q: We are trying to extract data from ERP. The full load works, but the delta load using database triggers as change data capture method does not collect any data on SAP HANA. What is wrong?

Owned by SNP
Feb 04, 2022
1 min read

Some tables such as MSEG do not exist on S/4HANA any more. They are replaced by HANA views, pointing to other tables (e.g. use table MATDOC instead of MSEG). In order to replicate such tables from SAP to Hadoop (or other storage types such as relational databases), you have these options:

  1. Perform regular full loads. This will work for small SAP tables only
  2. Use a delta load based on a field or timestamp
  3. Use the new base tables, e.g. MATDOC instead of MSEG, or ACDOC instead of BSEG (recommended)


For option #3 (recommended), delta types such as database triggers on SAP HANA will work.