Create a table in SQL DB and populate it with some sample values

Lets create a Mule service which accept the name as uri parameter which we will use to lookup in SQL DB

Chose select operation in DB connector and add the SQL query

Add Object to JSON activity to convert the List to JSON – which will be send back to caller as response

 

Run the mule flow and test it through SOAP UI where we can see the result

 

One Thought to “MS SQL Server – Select Operation”

  1. rxoc

    Great article, very useful !!

Leave a Comment