Insert data into a table

This example pipeline demonstrates how to insert data into a table. The customer1 table does not exist on the database initially. So, the Snap creates a table using the Create table if not present checkbox and inserts the data.


SQL Server Insert Example Pipeline

  1. Pass the data to insert using the JSON Generator Snap.

    JSON Generator Configuration

  2. Configure the Mapper Snap to map the data between the JSON Generator and SQL Server Insert Snaps.

    Mapper Snap Configuration

  3. Configure the SQL Server Insert Snap to insert the data from the Mapper Snap into the newly created customer1 table under dbo schema. On validation, the Snap displays the output with the success message of the inserted message.

    SQL Server Insert Snap Configuration


    SQL Server Insert Snap Output