Delete records from a table

This example deletes the records from table 'USER'. After the execution of the pipeline all the user records with age 52 are deleted from table.

• SAP HANA - Delete

Execute SQL query to retrieve data

In this example, we have a table named USER that stores user details. It has 3 columns: NAME, AGE and CITY. We will execute the query and retrieve users with age 60 with this pipeline.

• JSON Generator
• SAP HANA - Execute

Insert data into a table

This example demonstrates how to insert data into a table. This pipeline generates user data in JSON format, maps the fields to the corresponding SAP HANA table columns, and inserts the data into a SAP HANA database table.

• JSON Generator
• Mapper
• SAP HANA - Insert

Retrieve data from a table

In this example, we show how to retrieve data from a table called "USER".

• JSON Generator
• SAP HANA - Select

Execute a stored procedure

In this example, we are using schema QA_J in TEST_TABLE1.

• SAP HANA - Stored Procedure

Update records in a table

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

• JSON Generator
• SAP HANA - Update

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.

• JSON Generator
• SAP HANA - Upsert