Adding PeopleSoft service data objects

A PeopleSoft mediator automatically retrieves translate table values for a component interface while building the mediator metadata. The values will be saved in the mediator metadata, which is saved in the folder WebContent/WEB-INF/wdo of the portlet project. But in order for the mediator to successfully retrieve the translate table values, a special Component Interface needs to be created on the PeopleSoft server. This needs to be done prior to using Rational® Developer to configure a PeopleSoft mediator instance.

For detailed instructions on using PeopleTools to create the translate table interface or the component interface WPS_CI_LIST, refer respectively to Creating and enabling the translate table interface, WPS_XLATTABLE or Creating the component interface "WPS_CI_LIST" for using PeopleSoft mediator tools.

These instructions will guide you through the process of connecting to a PeopleSoft 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 PeopleSoft record or PeopleSoft 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 PeopleSoft 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 target component instances, 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 PeopleSoft record is an existing record or a list of existing records in the PeopleSoft 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 PeopleSoft record. It shows as disabled when the SDO data object is targeting a PeopleSoft record list. Choose this option if the intention of the SDO data object is to create a new PeopleSoft 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 dialogue box, click Add.
    3. In the Create or Edit a Connection dialogue box, enter the values necessary to make a connection to your PeopleSoft database server. To enter the PeopleSoft host information necessary for the Details field, click Assemble.
    4. To set the directory path to the PeopleSoft libraries, click Browse.
    5. Click OK.
    6. In the Browse Connections dialogue box, make sure that your new connection is highlighted; then click OK to return to the Select PeopleSoft Server Connection page.
  6. Once you select a connection, the wizard automatically starts retrieving ALL the defined components from the PeopleSoft server. From the list of component interfaces, select the one you want to use; then click Verify Available Actions.
  7. After a few seconds, the Available Actions window will show the actions that are supported for this component interface by the PeopleSoft server. To verify these actions, click OK; then click Next.
  8. In the Select Fields page, select the fields that you want for this component. If the selected action was to Retrieve existing values, click Filter to specify the search criteria for locating particular records. Click Finish.

The last step will take a while because the wizard will be retrieving translate table values into the mediator metadata.

A node representing the configured PeopleSoft mediator will appear in the Page Data view. If certain fields of the target component interface require values through either a translate or prompt table, new mediators need to be configured manually. Automatic configuration for either translate or prompt table value retrieval is not supported.

Editing your PeopleSoft SDO

To make changes to the metadata for the PeopleSoft mediator you just created, follow these steps:
Related concepts
PeopleSoft data access
Feedback
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.