StreamSets

StreamSets

Connect with experts and peers to elevate technical expertise, solve problems and share insights.

 View Only
Expand all | Collapse all

How to do CRUD operations via streamsets ?

  • 1.  How to do CRUD operations via streamsets ?

    Posted Fri September 15, 2023 06:17 AM

    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?



  • 2.  RE: How to do CRUD operations via streamsets ?

    Posted Mon September 18, 2023 06:21 AM

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