Category Enterprise Integration

August 20, 2019 Posted in API, Blogs, Enterprise Integration, ESB, SOA

In enterprise integration area, there are more and more REST APIs than ever. API management turns to be very important for every organization.

I collected the logos of some main API management vendors, along with the logos of those vendors who offer tools that have dependencies with API management, such as data modeling tool, service registry, identity management and application infrastructure, put them together with vendors’ logos who offer monitoring, DevOps and logging services. So we understand the technology stack of API management.

In API management box, I put vendors logos according to Gartner Magic Quadrant for API management...

November 19, 2018 Posted in Blogs, Database, Enterprise Integration

Recently I worked on an interesting use case from auditing which requires to roll up status of lower level tables into higher level. We already have a tree hierarchical design in our data model.

There are two options: one is to handle the roll-up pair by pair; another is to design a context table which presents the tree structure and use Oracle hierarchical query to go through tree traversal based on depth first search. The second  option is obviously an optimized approach to go. Since it may easily handle larger size model – as long as we have the context table ready. Let’s dive in and see how we handled this.

First, I created a context table which presents the context id and parent context id relationship. It’s a self-reference table.

create table ls_context_info
(
  context_id numbe...

January 31, 2018 Posted in Blogs, BPM, Enterprise Integration, ESB, SOA

It’s an era with many directions! There are so many tools available for enterprise integration. To choose the right one usually means whether the organization may get expected return on the possible huge investment.

Each enterprise integration requirement can be different. I assume you are working in a SOA environment, facing the pressure to move to cloud, but not quite ready.

We will talk about our preferred BPM and ESB tools, plus the choice of SOA integration and web service protocols.

Let’s start from analyzing business requirements and setting the processes using BPM application. By defining business processes, we get well-defined boundaries of services.

BPM: Activiti (Open Source, Free)

Alfresco Activiti can be the best choice to define and manage business processes and workflows...