MS SQL Server – Select Operation

To Show MS SQL Server – Select Operation, let’s start with creating 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