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.
- Open a Faces JSP file.
- 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.
- 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 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.
- 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.
- 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. |
- 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 dialogue box, click Add.
- 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.
- To set the directory path to the PeopleSoft libraries, click Browse.
- Click OK.
- 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.
- 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.
- 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.
- 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:
- In the Page Data view, right-click on your PeopleSoft mediator node and
select Configure.

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