Update data in a SQL Server database

This example pipeline demonstrates how to extract data, transform it, and update the SQL Server database.


SQL Server Update Example Pipeline

  1. Configure the Mapper Snap to transform the content from the JSON data. On validation, the Snap displays the transformed output.

    Mapper Snap Configuration


    Mapper Snap Output

  2. Configure the SQL Server Update Snap to update the dbo table with the specified Update Condition. This updates the city column from vizag (WHERE condition) to Hyderabad, the country column as India, and the product column as AppLE. On validation, the Snap displays a confirmation message indicating that the data was successfully updated in the database.

    SQL Server Update Snap Configuration


    SQL Server Update Snap Output