How to do CRUD operations via streamsets ?

@Sankar Arunachalam 

In this scenario, a Mainframe DB2 data collector engine is essential for establishing a connection to DB2 within StreamSets.

There are different way to handle the CRUD operation in StreamSets.

Below the sample example

Origin(DB2) → Destination(Azure SQL)

Just give a try and let me now if it helps. 

https://docs.streamsets.com/portal/platform-transformer/latest/transformer/Destinations/AzureSQL-D.html

Thanks & regards

Bikram_