Required modifications

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:

Performing a selective application upgrade

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:

  1. Create a new database to use as the upgrade database.
  2. Launch the PeopleTools Data Mover by double clicking the PSDMT.EXE file.The Data Mover window appears.
  3. Import the file %ProductDir%\connectors\PeopleSoft\PeopleSoft7\dependencies\DataMover\ CWUpgPrj.dat into the upgrade database.
  4. In Data Mover, open the script %PeopleSoft%\script\auimport.dms.
  5. 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:

  1. Log on to the AUDB.
  2. In the Application Designer, open the CWUpgPrj project.
  3. From the Tools menu, select Copy>Upgrade.
  4. 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.
  5. 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.

  6. 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.
  7. Go to Data Designer and perform a SQL View Create against XR_SRCH.
  8. 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:

  1. Close all PeopleSoft windows.
  2. Log out of the application, then log back in.
  3. Select the Start Menu, and confirm that the Event Notification menu is displayed.

Importing the application engine

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:

  1. In your Data Mover window, import the file %ProductDirS%\connectors\PeopleSoft\PeopleSoft7\dependencies \DataMover\CWAE.dat into the production database.
  2. In Data Mover, open the script CWAEIn.dms.
  3. Run the script by selecting File>Run Script or by clicking the Run Script button.
  4. 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.

Installing message definitions

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:

  1. In the Data Mover window, open the .dms scripts for the business objects you need to support.
  2. 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.

Embedding PeopleCode into panels

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:

  1. In Panel Designer, open the panel for the appropriate business object listed in Table 2.
  2. On the menu bar, select Add >Edit Box.
  3. Click on the panel to drop an edit box on the panel.
  4. Right click on the field and select Record from the popup menu.
  5. In the Edit Box Record dialog box, enter XR_EVENT_WRK for Record Name, and enter the related Field Name from the table above.
  6. Click OK and right click on the Edit Box again.
  7. Select Use from the popup menu.
  8. Select the Invisible check box, and click OK.

Copyright IBM Corp. 1997, 2003