Automatic synchronization of EIS data using the WebSphere Process Server relational Service

Before you start

WebSphere adapters can connect to many Enterprise information Systems (EIS) that use the Service Component Architecture (SCA) programming model. This tutorial will help you use the WebSphere adapters and WebSphere Process Server Relational Services to create a model that synchronizes the data in the EIS without having to save all IDs.

Goal

The WebSphere Process Server (hereinafter referred to as Process server) supports a useful feature that generates managed IDs to maintain relationships.

In this tutorial, you will learn:

Create records in SAP® and siebel® that generate unique IDs in both systems.

Invokes the relational service to generate the managed IDs associated with these two IDs.

Find the corresponding Siebel record and use the relational service to update automatically (next update SAP Records).

Implement the DELETE and RETRIEVE operations in the same way.

Prerequisite

You need to be familiar with WebSphere Resource adapters for SAP and Siebel, WebSphere integration Developer, and WebSphere Process Server.

System Requirements

You need to install the following software to configure and deploy the module:

WebSphere Integration Developer V7.0.

WebSphere Process Server V7.0.

Refer to Quick Ststartcenario to create the WebSphere Adapter for SAP and WebSphere Adapter for Siebel module.

Study time

5 hours

Business Use Cases

You will first learn about a use case scenario and then use the uses of WebSphere Process Server.

Suppose that a scenario where XYZ company uses SAP to store payroll information and use Siebel to process Human resources (HR) data. Each record in the payroll system corresponds to a single record of the human resources system. When the SAP payroll system is created, updated, or deleted, the HR system also operates accordingly. Input from each system can be provided separately with a common interface.

The SAP and Siebel systems have their own ID management systems, which require a separate logical ID to map the system, which is used for update and delete operations, thereby avoiding the manual entry of all managed system IDs.

To integrate various EIS, you can use WebSphere adapters. The task of logically mapping the unique IDs of each system can be accomplished using the relational services of the WebSphere Process Server.