Tag : Integration

Execute MSSql Server Stored Procedure from WSO2 Enterprise Integrator

Even though we can write SQL queries in database agnostic manner when we expose database tables as services with WSO2 Enterprise Integrator, there might be some challenges when dealing with stored procedures. Recently I found one such a situation. I was working on a project which was using Microsoft SQL Server as the database. For one use case, there was a requirement to execute an update and return the updated records to the frontend. As you know, we can’t do […]

Invoking a REST API with SFTP content through WSO2 EI

Let’s assume there are two systems which cannot directly communicate with each other. But the source system has the functionality to generate a file with the required data so that we can use the generated file to update the other systems. For this example, we assume the second system exposed a REST service to update the system but not a file upload. So we will use the WSO2 ESB to read the files from the remote secure FTP location and […]

XPath tricks for WSO2 ESB

When we use WSO2 ESB, we might find some difficulties to achieve small things which we can easily do using regular programming languages. Yes, ESB is not a platform that we use to do programing… Simply we configure a message flow using XML to achieve some task. But ESB is powerful enough to do most of the things that we do using programing language. I’m going to explain few tricks that we can use with WSO2 ESB Evaluate multiple conditions […]