Fetch employee details from a table in the SQL Server database

This example pipeline demonstrates how to retrieve employee details from the Employee_Demo table.


SQL Server Select Example Pipeline

Download this Pipeline
  1. Configure the Mapper Snap to pass the value for the WHERE clause (EmpID field is used) to retrieve employee details for the specified EmpID from the Employee_Demo table.

    Mapper Snap Configuration

  2. Configure the SQL Server Select Snap to retrieve employee details from the Employee_Demo table where EmpID matches the value from the Mapper Snap. The SQL query uses the WHERE clause to filter data.

    SQL Server Select Snap Configuration

  3. View the output showing the retrieved employee details.

    SQL Server Select Output

To successfully reuse pipelines:
  1. Download and import the pipeline into SnapLogic.
  2. Configure Snap accounts as applicable.
  3. Provide pipeline parameters as applicable.