cancel
Showing results for 
Search instead for 
Did you mean: 

How to setup CDC/timestamp on SAP S/4 Tables for Extracting Delta Records

0 Kudos

Hello,

We are currently extracting data directly from the HANA database using HANA SQL in SSIS via the ODBC connector provided in the the Hana Studio Client. This works ok, but is inefficient for master data tables such as KNA1 where there is no timestamp field. We then have to extract all the records every time and update our SQL database.

What is the best way to effectively add a timestamp to master data tables and other SAP tables that don't contain dates such as ERDAT or AEDAT, etc.

I read a bit about SAP CDC, but was a bit overwhelmed and not sure what the simplest approach would be. If anyone could provide some suggestions that would be appreciated.

Thank you,

Gary

CharlesFeng
Advisor
Advisor
0 Kudos

Hi martins.gary,

Could you please share more details about the technology you used to extract data?
Is it Smart Data Integration (SDI) or Smart Data Access (SDA) or any others?

Best regards,
Charles

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

We're using HANA SQL in Microsoft SSIS (SQL Server Integration Services), using the HANA Studio provided ODBC connector to read from the HANA database.