How to do CRUD operations via streamsets ?

  • 15 September 2023
  • 1 reply
  • 13 views

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?


1 reply

Userlevel 5
Badge +1

@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_

 

Reply