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