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

MS SQL Server - Select Operation


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

MS SQL Server - Select Operation


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

MS SQL Server - Select Operation


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


Thank you for taking out time to read the above post. Hope you found it useful. In case of any questions, feel free to comment below. Also, if you are keen on knowing about a specific topic, happy to explore your recommendations as well.
For any latest updates or posts on our website, you can follow us on LinkedIn. Look forward to connecting with you there.

Share this:
Notify of
1 Comment
Newest Most Voted
Inline Feedbacks
View all comments
4 years ago

Great article, very useful !!