If you would like to understand the basics of MuleSoft, refer to this article before going next:
Database Schema and Procs
This is the database payout which will be queried out from the SQL server to MuleSoft.
Getting Started,
Start Anypoint Studio to get started.
Create a new Mule Project from the File tab.
Provide the project name and leave everything default and click Finish.
Now drag and drop HTTP Listener from Mule Palette to designer view.
Now configure Listener to set some properties. Click on Listeners and click on Add button to set the Connector configuration.
Keep everything the same, click the Test connection and OK button.
Enter Path value.
Setup JDBC
You'll need to do the following to connect the MS SQL server with Mulesoft.
Download and install the sqljdbc4.2.jar file. It is required for you to connect to the MS SQL database. http://www.java2s.com/Code/Jar/s/Downloadsqljdbc420jar.htm
Ensure the TCP/IP port is enabled in SQL configuration (default port is 1433).
Add sqljdbc4.2.jar into the build path of your Mule application. Right-click on your application, then do Build Path > Configure Build Path > Libraries > Add External Jars.
Join the conversation! Your thoughts help the community grow.