Dinesh J Weerakkody

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 […]

Migrating APIs between WSO2 API Manager environments

WSO2 API Manager 2.0.0 onwards, there is a tool to migrate APIs between environments. Unfortunately, this tool will export/import only one API at a time. While I’m working with different customers, I have noticed that migrating APIs between environments is not an easy task if there so many APIs in the environment. So I have written a tool, which will migrate all the APIs available in the given source environment to another environment. Prerequisites WSO2 API Manager environments (both environments […]

Custom project structures for enterprise level WSO2 projects

When we are developing simple applications, most of the time we tend to use the standard project structures because those project structures are designed for general use cases. When it comes to enterprise level applications we might have to use custom project structures due to the architecture level design decisions. As I mentioned in the WSO2 development best practices page, we should separate the environment specific dependencies from the logic so that we don’t have to touch the logic when […]

Dynamic OTP page for WSO2 IS based on user claims

One Time Password (OTP) is something that we are heavily using these days to enhance the security of the applications. If you are using the WSO2 Identity server as a Single Sign-On (SSO) server, you have the functionality to send OTP and validate at the time of users logging in to the system. Also, you have the option to enable multiple channels to send the OTP. Mainly we can configure SMS and Email OTP and at the time of login […]

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 […]

Using the WSO2 API Manager Swagger PHP clients

Swagger, now OpenAPI, became a popular way of defining API metadata. A few years back, WSO2 API Manager started using swagger-codegen functionality to generate client SDKs. PHP is one of the supported languages and we are going to discuss, how to use the generated PHP SDKs in client-side. Why only PHP? most of the other languages are straightforward but PHP SDKs are a bit of pain. There are two ways of generating the client SDKs. Through WSO2 API Manager Store UI Through […]

Renaming WSO2 Carbon Archive with Maven

By default, maven based projects will use the artifact id and the version number as the name of the final artifact (jar file, war file, etc.). In case if we want to change that behavior, there is a standard way defined by maven to specify a different name to the final artifact. You just need to add the finalName element to build section. <project … > … <build> … <finalName>Custom_Name</finalName> … </build> </project> But when it comes to WSO2 Carbon […]

Metrics in WSO2 products

WSO2 Carbon Metrics [1] is a analytics tool, which is based on Metrics library [2]. This OSGI module is enabling Developers and DevOps guys to analyze the behaviors of WSO2 Carbon servers. This is really useful to gather performance related informations such as latency of the each module or latency in different scenarios. Some of the WSO2 products, including the WSO2 API Manager, has already bundled this feature to their latest releases and can be use OOB. By adding a […]

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 […]

OMG.. It’s Shreya Goshal.. :)

I heard that Shreya Goshal is coming to Sri Lanka. I grabbed a ticket and went to the ground bit early.. 🙁 unfortunately it was a rainy day.. Concert started after one hour. Once the show started, we were staring at the stage and didn’t even want to bother about the rain.. So I was ended up with cold.. Even only Shreya and her support singer was performed, it is was a great show since her voice is truly amazing.. […]