SAP Table Connector

Back Next

Advanced properties

You can configure additional options in the Advanced Properties field in the Source transformation.

You can use the following properties as advanced properties when you configure delta extraction on SAP source tables:

When the external application time zone differs from the SAP system time zone, enter the SAP system offset time in minutes in the following format:

delta_offset=<SAP system offset time in minutes>

For example, if the difference between the external application time zone and SAP system time zone is 480 minutes, enter the following value:

delta_offset=480

To fetch the changed data of key fields that are marked for hard deletion in SAP to the target table, enter the following advanced property:

fetch_del_rows=true

You can configure the

fetch_del_rows=true

advanced property in delta extraction mappings using the following guidelines:

To fetch the deleted delta records to the target table, select

Data Driven

as the operation and

Update Else Insert

as the update mode in the Target transformation. Otherwise, data corruption occurs in the target.

When you perform delta extraction for the deleted records, the Secure Agent fetches only the key value for the deleted delta records.