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:
Subscribe
Notify of
guest
1 Comment
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
rxoc
rxoc
4 years ago

Great article, very useful !!