Siebel EAI Interview Questions – EAI Siebel Adapter

Answer: EAI Siebel Adapter is pre-build business service which interacts with Siebel Object manager to perform CRUD operations on Siebel Database. Following methods are available on the service:

1. Query method is used to query data from Siebel, output of this method is Integration Object instance.
2. Query can be executed using :
1. Row id of the primary BusComp
2. Search spec consisting of parent and child buscomp fields.
3. Integration object instance – which is also known as Query By Example
3. Only required input argument of this method is Output Integration Object Name which is the name of integration object which is queried by the service.

Insert

1. Insert Method can be used to insert records in siebel database. 
2. This method only accepts integration object instance as input argument.
3. Values must be provided for all the fields of at least one user key.

Update 

1. Is used to update the records in siebel database
2. Method will throw error if no records or multiple records found for the user key defined.
3. Performs synchronise operation for child bus comp.

Upsert 

1. Is combination of Insert and Update.
2. Method queries for provided user key values and decides to update if record is found in database otherwise it deletes the records. 

Delete

1. Delete method is used to delete one or more records from the database. Inputs which can be provided are:
1. Primary Row Id of primary business component.
2. Search spec
3. Integration Component Instance.
2. Exception: It does not deletes the child records from the database if child IC is not present in inputs.

Synchronise

Execute