Showing posts from December, 2019

Configure Kerberos based Authentication into WSO2 Datasources

As you know, Kerberos can be used to authenticate System or users reside on a none secured network. In my use case, I have Windows AD and MSSQL server and I have a couple of WSO2 Servers running on Linux systems.

In my initial setup I have configured, WSO2 servers has to use SQL users. But instead of using SQL users, I prefer to use AD users. So I have started configuring Kerberos and faced a lot of troubles.

If you are starting from scratch, I would recommend writing a Java class to connect MSSQL server using Kerberos. Then You can identify all small mistakes such as character case issues, typos, JDBC driver compatibility issues, etc. 
Below are a few issues I have faced:
1) CASE is significant in krb5.conf file

2) I found that we need to use MSSQL JDBC 6.4 version in order to get new tickets. But if you are just planning use pre-generated tickets, you can use the older version as well.
Here are the steps you need follow when configuring Kerberos with WSO2 Enterprise Integrator. 
1) …

Compare Two XML Elements and Filter using WSO2 EI

Think about an integration scenario, where you are getting a list of data from a service endpoint(Data 1) and you want to exclude or match this response against the data returned by another service endpoint(Data 2).

In such a situation, first, you need to have a unique attribute in both data set to exclude or match elements. So in my use case, list of data and matching content is as below

<CodeLists><CodeList><Id>O</Id><Name>Open</Name></CodeList><CodeList><Id>C</Id><Name>Cancelled</Name></CodeList><CodeList><Id>X</Id><Name>Denied</Name></CodeList><CodeList><Id>P</Id><Name>Pending</Name></CodeList><CodeList><Id>D</Id><Name>Duplicate</Name></CodeList></CodeLists> Data 1