Insert or update records in a table

In this example, we show how to perform an upsert operation that either inserts new records or updates existing ones based on a key column.

Pipeline


SAP HANA Upsert Pipeline

Input Data

The input data from the JSON Generator contains records with employee information.


SAP HANA Upsert Input Data

Configuration

We configure the Upsert Snap with the key column(s) that determine whether to insert or update a record.


SAP HANA Upsert Configuration

Output

The output shows the result of the upsert operation for each record processed.


SAP HANA Upsert Output