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.
