Slide 2
Slide 2 text
Connecting MS SQL Server To Call
Stored Procedure To Insert Data Into
Table
Mulesoft provides wide range of connectors which is very handy while integrating solution.
In many scenarios, we required to connect to database for querying, inserting and
updating the table. Mulesoft provides a database connector which allows JDBC
connectivity with relational database to execute various SQL operations like Select, Insert,
Update, Delete and Stored Procedures.
Mulesoft provide database connector to connects various JDBC databases like MS SQL,
Oracle, Derby, MYSQL etc.
Prerequisite To connect MS SQL Server With Mulesoft
• Download and Install sqljdbc4.jar file. It will require to connect MS SQL database.
• Ensure that TCP/IP port is enabled in SQL configuration (default port is 1433).
• Add sqljdbc4.jar into your build path of Mule application. Right click on your
application then Build Path < Configure Build Path < Libraries < Add External
Jars.