Follow Siebel_Experts on Twitter Sieble Expert Panel on LinkedIn

Home » Interview Question, Siebel EAI, Siebel EIM, WorkFlow Policy

Integration Of Third Party Appication With Siebel

11 March 2010 6,406 views 4 Comments Bookmark and Share



I have seen developers discussing different ways to integrate third party applications with Siebel. Hope this nicely elaborated article will help you understanding this better.

I have asked industry experts to share their ideas on to this and now publishing responses with you. More ideas are open. Lets discuss this and provide your expert suggestion in comment section.

Responses of industry expert:

Read what Joan Martí Peraire says about intgrating siebel with third party appication.

In order to integrate Siebel with external application, what I can share, from my own experience, is that there are two options that can be easily carried out without any problem:

Option A: Using synchronous workflow that retrieve xml file that contains process information.

You should create integration objects within the Siebel repository to provide the definition of the mapping between the fields in the xml and Siebel.

Add a Sub Process step to invoke an EAI XML Converter(using this integration object created as a Input Argument – IntObjectName)
Business Service Name: EAI XML Converter
Business Service Method: XMLDocToIntObjHier

In Addition, add another Sub Process step to invoke an EAI Siebel Adapter Upsert (When a Workflow Process has a Business Object then a Siebel Operation Upsert step defined will upsert the record in the Primary Buisiness Component.)
Business Service Name: EAI Siebel Adapter
Business Service Method: Upsert

(*) For queues we need an external system/middleware.

Option B: Data load via EIM

EIM batch jobs are used for bulk data load. EIM are background batch jobs (not real time jobs).

In this case it’s required:

1. Previous Thread : PL/SQL can be used in order to delete previous records in EIM table.

delete from siebel.eim_EXAMPLE
where if_row_batch_num = LOT_NUMBER;

2. Preparing the EIM Tables : This section provides assistance in loading the EIM tables with data used to control insertion of rows from Siebel base tables.

insert into siebel.eim_EXAMPLE (
row_id,
/* This value in combination with the nonempty contents of if_row_batch_num must yield a unique value. */
if_row_batch_num,
/* Set this to an identifying number for all EIM table rows to be processed as a batch.*/
if_row_stat,
/* In each row to be deleted, set this column to FOR_INSERT to indicate that the row has not been inserted. */
[…]
/*Add Required Fields to be informed*/
);

3. Finally, execute EIM through Server Manager, using a sentence such as:

set ExecuteEIM =”Run task for component EIM with config=C:\sea704\EXAMPLE.ifb”

%SRVRMGR%srvrmgr /g %SERVER% /e % SERVER % /u %USER% /p %PASSWORD% /s %EIMSERVER% /c %ExecuteEIM% /o %BASE%\Log.LOG

Feel free to contact Joan Martí Peraire joan.marti.peraire@enginyers.net for any information/query on above article:

SocialTwist Tell-a-Friend

Related posts:

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

4 Comments »

  • Ajay Godbole said:

    Another Option is to use Inbound WebServices which will use the same steps from Option A.

    You can import the WSDL in Tools to create External Integration Objects.

    In the workflow process, the Initial step will be to define a Mapping in the DataMap Editor to map between the External and Internal Integration Objects. Rest of the workflow steps remain the same.

    # 11 March 2010 at 8:22 pm
  • Narayan Patro said:

    I would emphasize on Joan Martí Peraire’s words wherein the high level category is Real time and Batch load. Both are ways of integrating Siebel with third party applications.
    Siebel provides a lot of ways for real – time interfaces to work. All one have to do is judge the requirements alongwith scalability option and adopt one or more ways to accomplish the same. I have outlined the different real time integrations supported:
    Data Sharing Integrations include EBC and VBC configurations.
    Data replicating integrations include the following:
    1. Peer to Peer integration using HTTP
    2. Web Services / ASI
    3. Queue Based Transport (MSMQ, IBM MQ and JMS)
    4. COM Based Integration (DLL) — Tightly coupled interfaces.
    5. Java Based Integration (uses Java Class from external application and EAI Java Business Service to integrate)
    6. File Based real time integration — This approach is a bit different from the batch load done via EIM. In this approach, files can be placed on a local filesystem or a ftp server from which an RCR can pick the file and pass it onto a workflow or BS for further processing.

    Again all these integrations support synchronous or asynchronous mode exception being Queue based which only supports asynchronous mode. However you can achieve near real-time integration using Queue based system.

    # 12 March 2010 at 2:06 am
  • Piyush said:

    There are few points I would like to add from my exp.

    While integrating siebel with external application, we use Web services, queues or batch integrations.

    1. Web Services: They are the fastest method of integrating external applications. Pros are like no extra setup needed, data can travel via internet.But they have their cons like, limitation of data to be sent (vary from 1-4MB), retry mechanism needed in case of failure.
    Web services can be real time as well as background jobs.

    2. Queues: In queues we can send more data as compared to web services. No retry mechanism in needed incase of queues. In this way queues are more reilable. But for queues we need extra h/w as well as s/w setup at siebel as well as external system/middleware

    3. EIM: EIM batch jobs are used for bulk data load. EIM are background batch jobs. they are not real time jobs.

    Regards,
    Piyush

    # 12 March 2010 at 8:07 am
  • Naresh said:

    Hi,
    There is another way of integrating 3rd party applications with Siebel.
    Symbolic URLs, these will act as direct link of 3rd party applications into siebel, by allowing access to that application from siebel within.
    Regards,
    Naresh.

    # 5 January 2011 at 11:50 am

Leave your response!

Add your comment below, or trackback from your own site. You can also subscribe to these comments via RSS.

Be nice. Keep it clean. Stay on topic. No spam.

You can use these tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <font color="" face="" size=""> <span style="">

This is a Gravatar-enabled weblog. To get your own globally-recognized-avatar, please register at Gravatar.