Adding Siebel service data objects

These instructions will guide you through the process of connecting to a Siebel source and specifying a data object for use in your application. Note the choices for adding a record versus a record list.

 
  1. Open a Faces JSP file.
  2. From the Data palette, click on either Siebel record or Siebel record list and drag it to the JSP file. The Create EIS SDO Object wizard will open.
  3. In the Name field, type the name of your SDO. If you want to reuse existing mediator or metadata information, follow the substeps below:
    1. If you check the box labeled Retrieve and existing record from scope, you can use this wizard to retrieve an existing Siebel object from one of the scopes. You must specify both a key name and a scope from which to retrieve. You must also check the box labeled Reuse metadata definition from an existing record or record list and specify the mediator metadata file. Once you enter this information and click Next, you will be taken to a page that displays the schema of the data graph that is a result of interpreting the mediator metadata. On that page, you must select the root feature of the SDO object.
    2. If you only want to reuse information from a previously created object, check the box labeled Reuse metadata definition from an existing record or record list. This will populate the rest of the wizard pages with information collected from the metadata file such as a target business component, selected fields, etc. Note: you will need to have imported the existing metadata file into the project before you can select it via the wizard.
  4. Choose the action you would like to use to initialize this record; then click Next. Depending on what type of field each choice will yield the following actions:
    Radio Button Description
    Fill record with existing data from the database If the target Siebel record is an existing record or a list of existing records in the Siebel server, choose this option to have the mediator first retrieve the existing record(s) and populate the SDO data object with the retrieved data.
    Create an empty record in order to create a new row in the database. This option is only available for targeting a Siebel record. It shows as disabled when the SDO data object is targeting a list of Siebel records. Choose this option if the intention of the SDO data object is to create a new Siebel record.
  5. In the Select server connection page, choose a connection from the drop-down menu. If you do not have an existing connection, do the following:
    1. Click Browse.
    2. In the Browse Connections dialog box, click Add.
    3. In the Create or Edit a Connection dialog box, enter the values necessary to make a connection to your Siebel database server. To enter the Siebel host information necessary for the Details field, click Assemble.
    4. To set the directory path to the Siebel libraries, click Browse.
    5. Click OK.
    6. In the Browse Connections dialog box, make sure that your new connection is highlighted; then click OK to return to the Select Siebel Server Connection page.
  6. Once you select a connection, the wizard automatically starts retrieving ALL the defined business objects from the Siebel server. From the list of business objects, expand the object of your choice to reveal the business components. Select a component; then click Next.
  7. In the Select Fields page, select the fields that you want for this component.
    • If the intended action is Create or Update, make sure that the primary key field, which is usually Id, is deselected. Because Siebel primary key field values are not to be assigned or updated by user operations, including the primary key field in the mediator with the Create or Update action will cause the server to throw an exception.
    • If the SDO data object is targeting a Siebel record list, you can use both the "Sort" and "Filter" buttons to specify sort and search criteria. For Siebel records, only the "Filter" button is available.
  8. Click Finish.

A node representing the configured Siebel mediator, as well as picklist mediators, will appear in the Page Data view. Mediators for retrieving picklist values are automatically generated when the main mediator's action is "Create" or "Update".

Editing your Siebel SDO

To make changes to the metadata for the Siebel mediator you just created, follow these steps:
Related concepts
Siebel data access
Related tasks
Creating controls and binding with Siebel SDOs
Feedback
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.