How to upsert data in Integration Object IO using EAI Siebel Adapter business service in Siebel Workflow

Why Integration Component:

We use IO in Siebel for inbound and outbound integration. But we can use IO for normal use as well. For example you have requirement to move data (rows) from one business component to an other. Looping is the long way you can make IO and do this in one go. Just query, use data map if you need to modify the data or destination business component have different fields name and insert or upsert the data in other business component or in the same if only data modification is required. Upsert method is interesting choice because on defined user keys in IO you can update the data if no key matches siebel will insert new row.

Below is the process of using "Upsert" method of "EAI Siebel Adapter" business service using workflow business service step.

Procedure:

IO must be compiled on SRF (EAI, SIA) and Deployed to run time data base for which you want to upsert (insert/ update) data in Siebel using Workflow and we have to prepare SiebelMessage before inserting. For that we can use use Datamap or prepare SiebelMessage manually or it could be Web Service input.

Add new Business Service step in Siebel Workflow, set its properties as below:

Business Service Name: EAI Siebel Adapter
Business Service Method: Upsert

Set the values of Input Arguments as below:

Input Argument: SiebelMessage
Type: Process Property
Property Name: SiebelMessage

Set the values of Output Arguments as below:

Property Name: New Id
Type: Output Argument
Output Argument: PrimaryRowId

Note: SiebelMsg is a process property with type hierarchical.

ITCanopy

Search This Blog