Update records in a table

In this example, we show how to update employee records in a table based on their ID.

Pipeline


SAP HANA Update Pipeline

Configuration

We configure the Update Snap to update records where the ID matches the incoming document value. The condition uses a variable from the upstream data.


SAP HANA Update Configuration

Output

The output shows the number of rows affected by the update operation.


SAP HANA Update Output