Skip to main content

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?

@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