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.
- Open a Faces JSP file.
- 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.
- In the Name field, type the name of your SDO. If you want to reuse
existing mediator or metadata information, follow the substeps below:
- 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.
- 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.
- 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. |
- 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:
- Click Browse.
- In the Browse Connections dialog box, click Add.
- 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.
- To set the directory path to the Siebel libraries, click Browse.
- Click OK.
- 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.
- 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.
- 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.
- 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:
- In the Page Data view, right-click on your Siebel mediator node and select Configure.

- This will activate the Siebel SDO wizard that corresponds to this mediator
node.