How to create a custom view to join multiple tables in Sterling OMS

 Introduction:

There can be a business requirement to fetch data from different tables from database and use it for further processing. For example - In Inventory console, we need to search and display data from extended attributes of yfs_item.

We can either write a custom logic to fetch the data from required tables and then do post processing to return the output in desired format. There is also a possibility to join required tables in a View. Latter one also requires customization but can be better performing.

Views can be created for out-of-the-tables and/or custom tables. Let's see how we can create custom views in IBM Sterling OMS.

Sterling and JBoss - JMS and Transaction Timeout configuration

Introduction: 

There are a lot of considerable differences in JBoss 5 compared to JBoss 4 and don’t expect existing configuration to work seamless when migrating from JBoss 4x to 5x.

While working in IBM Sterling, if you are using JBoss as Application server and as JMS provider then this might be helpful for you to see the configuration files in JBoss and how to configure it in Sterling.

In this post, I will be talking about JMS and Transaction Timeout settings in JBoss 4x vs 5x.

Jmeter Automation using Java

Introduction:

Even though I come from a development background, I had to work as a support team member for some time for one of the project. It's quite common in IT industry that depending upon the project need your role will change accordingly even if it doesn't match with your skills set. 

There were many repeated tasks on daily basis which we have to do. Like - sending reports to business teams, reprocess exceptions, close alerts, process stuck orders etc. I did not like this repeated work and thought of automating few things. I observed the pattern for few tasks was like -

• Connect to DB
• Execute a query to DB
• Export the output to CSV file
• Execute existing Jmeter script which reads data from CSV file and invokes API/Service

Exposing REST Services in Sterling OMS

Introduction:

Prior to IBM Sterling OMS v9.4, it was only possible to expose APIs/Services as SOAP web service. REST API features are enabled now with standard installs and updates of IBM Sterling OMS v9.4 onwards.

XML API (XAPI) capabilities are now accessible through a simple REST API layer. Developers can create, read, update, and delete resources by using HTTP calls that are compliant with REST standards.

Both SOAP and REST have their own Pros and Cons. But here we will just focus on basics of enabling REST services with examples.