How to do CRUD operations via streamsets ?

Source- IBM DB2

Destination - Azure Postgresql DB.

How can be done it? What is best way to accomplish this?

<user-mention data-id="1388">@Sankar Arunachalam</user-mention> 

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_

Thanks for the info! Using the Delta Executor can help make these data tasks easier, even for simple setups. It's a handy tool to try with StreamSets for smooth connections and actions!

------------------------------
Alex 421
------------------------------