In this blog post I would like to record below topics regarding integrating SQL Server in a Mule flow: Connecting to SQL Server Different authentication mechanisms Run scripts/stored procedures Limitation 1. Connecting to SQL Server Mule provides DataBase connector which can be configured to connect different databases like Oracle, MySQL, Derby and in our case SQL Server as well. Before…
Category: INTEGRATION USING MULE
Debugging .Net Code with Mule Anypoint Studio
With all the amazing connectors MuleSoft provides, I was happily surprised to see MuleSoft also has Visual Studio plugin which works with the mule dotnet connector. What this means is, not only can you use your most complex .Net code in Mule flow but you can now also hit a break point and debug the .Net code when your mule flow…
API Management/Gateway
API Management/Gateway has gained lot of attention and interest in past year. I thought of writing a small blog to explain briefly what it is and compare two major contenders in this space. API Management/Gateway: API Management as the name suggests, is used to manage all the APIs within an organization with well defined policies, rules and restrictions in a single…
Encrypting values in property file
As a premium feature, MuleSoft provides secure property placeholder which helps in encrypting/decrypting the properties within the mule flow. Consider scenario where an api call requires username/password in the header which is used to authenticate the caller before performing any operation. If you are writing a mule application to make this api call, the value for password may not be stored…
HTTP Connector
Mule provides two different kinds of HTTP connectors based on the runtime version. For anything below 3.6 the HTTP connector is an endpoint based connector and runtime 3.6 and above contains HTTP operation based connector. Endpoint-based Connector An Endpoint based connector is used to connect flows and like any endpoint configuration, it has ability to embed message processors in it. Below are…
Mule Domains
Domains projects in mule are a way to share resources among multiple mule applications. Think of it just like declaring global connector configurations but instead of sharing the configurations within multiple flows in a single application, it is now shared across multiple flows and multiple applications. Every mule project is associated to a domain. If you observed the mule-deploy.properties, by default the domain…
Mule as Azure Worker Role using Anypoint Studio
In this post, I am attempting to explain steps involved in creating Worker Role and running Mule using Azure toolkit for Eclipse. Step1: To begin, open Anypoint Studio and install Azure toolkit for Eclipse by choosing Helpà Install New Software and entering the URL: http://dl.msopentech.com/eclipse Reference: https://github.com/MSOpenTech/WindowsAzureToolkitForEclipseWithJava Note: I am using the newest beta version Anypoint studio 6 and mule runtime 8.0…
Guaranteed Delivery!!
In a distributed and disconnected world loosing data is the most terrible thing which can happen. If you are using Mule as ESB and trying to pass messages, how do you ensure you do not loose messages when the system connected at outbound is down? How do you perform retries without asking the publisher to send the data again? Is it…
PaaSify Mule using Azure and SpringBoot
There is a lot of hype about PaaS and it appears to be the go to strategy where ever possible. I wont blame if people don’t want to deal with infrastructure and headache of following up with middleware to check if everything is installed as per instructions. I have noticed, one can write a very detailed installation instructions but, there is…
MSMQ Connector
Mule MSMQ Connector helps in reading/writing messages from MSMQ. Personally I have had few hiccups in getting this working and even to extent of raising few defects on the connector and windows gateway service. Although personally (at the time of writing this blog), I am still not 100% confident on this connector working (as windows gateway service is a black box) but I am very much…