The connector installation includes a set of Data Mover data
files containing menu definitions, panel definitions, record
definitions, and PeopleCode required to support the connector.
These files are used to create the following:
- Event queue tables that store event notifications, and an
archive table that stores processed events.
- An Application Engine used to move events between event
tables.
- A derived work record for storing temporary values and
PeopleCode.
- A set of PeopleSoft message definitions for each business
object/verb combination. Message definitions are stored either in
the Connector Integration activity in the IBM
WebSphere business integration adaptor business process or,
when ICS is the integration broker, in the activities and business
processes associated with supported collaborations. For example,
message definitions for Employee object/verb combinations are found
in the CWEmployee activity in the CWEMPLOYEE
business process.
To copy the required business-integration objects into the
PeopleSoft database, you must perform a selective application
upgrade. The upgrade process involves copying the objects from a
source database, the application upgrade database (AUDB), to the
target database in the PeopleSoft environment. For detailed
information on Application Upgrader, see the PeopleSoft
Administration Tools guide.
Before performing the application upgrade you must create and
prepare the AUDB by performing the following steps:
- Create a new database to use as the upgrade database.
- Launch the PeopleTools Data Mover by double clicking the
PSDMT.EXE file.The Data Mover window appears.
- Import the file
%ProductDir%\connectors\PeopleSoft\PeopleSoft7\dependencies\DataMover\
CWUpgPrj.dat into the upgrade database.
- In Data Mover, open the script
%PeopleSoft%\script\auimport.dms.
- Run the script by selecting File>Run Script, or by clicking
the Run Script button. The message definition data is imported.
Ensure that the Successful Completion message
appears.
At this point, it is a good idea to run a comparison report
between the AUDB and the target database. However, if you are
certain that there are no business-integration objects in the
target database, you can skip this report and perform the
application upgrade.
Perform the application upgrade as follows:
- Log on to the AUDB.
- In the Application Designer, open the CWUpgPrj
project.
- From the Tools menu, select Copy>Upgrade.
- Sign on to the target database by clicking Signon. The Signon
screen is displayed. Enter the name of the target database,
operator ID, and password.
- In the Copy dialog box, select the Export Project check box.
Make sure that all other items in the list box are also selected,
then click Copy.
If PeopleSoft is the source application, you may skip the next
two steps.
- To complete the installation of the event tables, go to Data
Designer and perform a SQL Table Create against XR_EVENT,
XR_FUTURE_EVENT, TMP_FUTURE_EVENT, and
XR_ARCHIVE.
- Go to Data Designer and perform a SQL View Create against
XR_SRCH.
- In the PeopleSoft Security Administrator, open the Operator
class for the connector and give this class the privileges to use
all items in the EVENT_NOTIFICATION menu group.
To test that the application upgrade executed successfully:
- Close all PeopleSoft windows.
- Log out of the application, then log back in.
- Select the Start Menu, and confirm that the Event Notification
menu is displayed.
- Note:
- The Application Engine is not required if the connector does
not support PeopleSoft as a target application.
The Application Engine is a batch process that moves events from
the future events table to the event table. To import the
Application Engine follow these steps:
- In your Data Mover window, import the file
%ProductDirS%\connectors\PeopleSoft\PeopleSoft7\dependencies
\DataMover\CWAE.dat into the production database.
- In Data Mover, open the script CWAEIn.dms.
- Run the script by selecting File>Run Script or by clicking
the Run Script button.
- When the script runs successfully, open the Process Scheduler
and schedule XR_MOVE to run at midnight every night. For
information on using the Process Scheduler, see the PeopleSoft
Administration Tools manual.
Next you must import message definitions to support WebSphere
Business Integration Adapter Framework business objects. The
message definitions enable the connector to communicate with the
PeopleSoft system via the Message Agent API. The import script
file, CWBPIn.dms, is located in
%ProductDirs%\connectors\PeopleSoft\PeopleSoft7\dependencies\DataMover.
This file contains the following scripts:
Table 1. Message definition
scripts
Script |
Message
definitions |
CWBP.dat |
Event
notification message definitions |
CWEMPL.dat |
Employee
message definitions |
CWDEPT.dat |
Department
message definitions |
CWEMPL_757.dat |
Employee
message definitions for use with PeopleTools 7.57 |
To import the message definitions into the PeopleSoft system,
follow these steps:
- In the Data Mover window, open the .dms scripts for
the business objects you need to support.
- Run the scripts by selecting File>Run Script or by clicking
the Run Script button. Ensure that the Successful
Completion message is displayed. The message definition data
is imported.
- Note:
- If the message definition import fails, use delbp.sql
to delete all WebSphere Business Integration Adapter Framework
message definitions, then repeat the import steps. The
delbp.sql file is located in
%ProductDirs%\connectors\PeopleSoft\PeopleSoft7
\dependencies\DataMover.
To enable triggering for Department and Employee business
objects, you must embed fields in certain panels. Table 2 details which embedded fields are
required for each business object.
Table 2. Business
object triggering fields
Business
object |
Use for |
Field name |
Panel |
Level |
Department |
Event
notification |
DEPT_TRIGGER |
DEPT_TBLGBL_SBP |
Level 0 |
Employee |
Event
notification |
EMPL_PERS_TRIGGER |
PERSONAL_DATA2 |
Level 0 |
Employee |
Event
notification |
EMPL_JOB_TRIGGER |
JOB_DATA1 |
Level 0 |
Employee |
Request |
EMPL_OTHERPHONE |
PERSONAL_DATA2 |
Level 1
(phone scrollbar) |
To embed fields in the appropriate panels:
- In Panel Designer, open the panel for the appropriate business
object listed in Table 2.
- On the menu bar, select Add >Edit Box.
- Click on the panel to drop an edit box on the panel.
- Right click on the field and select Record from the popup
menu.
- In the Edit Box Record dialog box, enter XR_EVENT_WRK for
Record Name, and enter the related Field Name from the table
above.
- Click OK and right click on the Edit Box again.
- Select Use from the popup menu.
- Select the Invisible check box, and click OK.
