B Configuring OracleAS Adapter for PeopleSoft

This appendix describes how to configure OracleAS Adapter for PeopleSoft. To configure:

• Specify the version of PeopleSoft you are using.

• Install the Component Interfaces of the adapter.

• Install the TCP/IP message router adapter.

• Copy the psjoa.jar file (and, for PeopleSoft release 8.1, the pstools.properties file) into the OracleAS_home\adapters\application\lib directory.

This appendix contains the following topics:

• Specifying the PeopleSoft Version

• Installing the Adapter Component Interfaces

Specifying the PeopleSoft Version

OracleAS Adapter for PeopleSoft supports multiple versions of PeopleSoft. However, certain versions are incompatible with each other, and the adapter must recognize the version you are using.

After installation, files for both PeopleSoft versions appear in the default location, OracleAS_home\adapters\application\lib.

Use the corresponding location on non-Windows systems.

To ensure that the adapter functions properly, remove the file that does not correspond to your release:

• For PeopleSoft 8.4x releases, remove iwpsci81.jar.

• For PeopleSoft 8.1x releases, remove iwpsci84.jar.

After changing the contents of the lib directory, restart all components.

Installing the Adapter Component Interfaces

OracleAS Adapter for PeopleSoft includes two custom Component Interfaces. Application Explorer uses these Component Interfaces to create schemas for events and services.

To configure Component Interfaces for OracleAS Adapter for PeopleSoft, you must:

1. Import and build the Component Interfaces.

2. Configure Component Interface security.

3. Test the Component Interfaces.

Importing and Building the Component Interfaces

The Component Interfaces provided with OracleAS Adapter for PeopleSoft are delivered through a PeopleSoft project:

• For PeopleSoft Release 8.4, it is the IWY_CI_84 project, packaged in iwpsci84.zip.

• For PeopleSoft Release 8.1, it is the IWY_CI_81 project, packaged in iwpsci81.zip.

On Microsoft Windows, the default location of the files is OracleAS_home\adapters\application\etc\peoplesoft.

Use the corresponding location on non-Windows systems.

Importing and Building the Component Interfaces

To import the IWY_CI_81 or IWY_CI_84 project to PeopleSoft:

1. Unzip iwpsci81.zip or iwpsci84.zip to any directory.

   The unzip process creates its own subdirectory. For example, if you extract the file to c:\temp, it creates c:\temp\IWY_CI_81 or c:\temp\IWY_CI_84.

2. Launch the PeopleSoft Application Designer in the two-tier mode.

3. Open the Copy From File Select Project dialog box as follows:

   • In PeopleSoft 8.4, select Copy Project from the Tools menu, and then select From File.

   • In PeopleSoft 8.1, select Copy Project from File from the File menu.

     The Copy Project From File dialog box opens.

4. Navigate to the original directory in which you unzipped the file.

5. 
   Description of the illustration copyfromfile.gif
   
   

6. Click Open (in release 8.4) or Copy (in release 8.1) to open the Copy From File dialog box.

   
   

   Note: Although the preceding figures illustrate PeopleSoft release 8.4, the corresponding instructions are accurate for releases 8.1 and 8.4.

   
   

7. Highlight all objects listed in Definition Type(s), and click Copy.

   The Application Designer displays the following message, which indicates successful completion.

   
   Description of the illustration copyendedmessage.gif
   
   

8. To build the views in the project, select Build, and then select Project.

   The Build dialog box is displayed.

   
   Description of the illustration builddialogbox.gif
   
   

9. In the Build Options pane, select Create Views.

10. Select your site's customary option in the Build Execute Options pane. (In the previous figure, Execute SQL now is selected.)

11. Click Build.

    The Application Designer displays a Build Progress status window.

    
    Description of the illustration build_progress_dialog_box.gif
    
    

    You can use your native SQL Tool to view the records from the generated view to ensure that they have been created correctly.

12. If the view has not been generated correctly, click Close, and double-click the SQL Build log statement.

    The PSBUILD log file appears.

    
    Description of the illustration logfile.gif
    
    

13. If you encounter problems, check the Build settings options by selecting Build, and then Settings.

    The Build Settings dialog box is displayed.

    
    Description of the illustration build_settings_dialog.gif
    
    

Depending on the application server database for PeopleSoft, some databases may require the Tablespace name. Consult your PeopleSoft database administrator for more information regarding this function.

You have now finished importing and building the Component Interfaces. To configure security for Component Interfaces, refer to "Configuring Component Interface Security".

Configuring Component Interface Security

Application Explorer requires the custom Component Interfaces that you imported and built in the previous step, so you need to ensure that all Application Explorer users have access to these Component Interfaces. As with all PeopleSoft objects, security is assigned at the Permission List level. Review your site security requirements to determine which users are going to work with Application Explorer, and then set Component Interface security for each distinct Permission List belonging to those users.

Note: These Component Interfaces are required for creating schemas and business services, and they are used at runtime for using the Find method. They have only Get and Find access and cannot be used to update your PeopleSoft database. This minimizes any possible security exposure. In PeopleSoft release 8.1, you can set security in 2, 3, or 4-tier mode, whereas in release 8.4 and higher, you can set security 4-tier mode only.

The following steps describe how to configure security for all supported releases of PeopleSoft in all supported modes. The figures shown in the steps reflect PeopleSoft release 8.4 in 4-tier mode.

Description of the illustration permissionsandroles.gif

1. Select PeopleTools, Security, User Profiles, Permissions & Roles, and then Permission Lists.

2. Click Search and select the relevant Permission List.

   The Permission List pane opens on the right.

   
   Description of the illustration permission_list_search.gif
   
   

3. Click the right arrow next to the Sign-on Times tab to display the Component Interfaces tab.

   
   Description of the illustration rightarrow.gif
   
   

4. Click the Component Interfaces tab.

5. To add a new row to the Component Interfaces list, select the plus sign (+).

6. Enter or select IWY_CI_ATTRIBUTES Component Interface and click Edit.

7. To set the Get and Find methods to Full Access, click Full Access (All).

8. Click OK.

9. Repeat steps 5 through 8 for the IWY_CI_MESSAGES Component Interface.

10. Scroll down to the bottom of the Component Interfaces window, and click Save.

You have finished configuring security for the Component Interfaces delivered with OracleAS Adapter for PeopleSoft. To test these Component Interfaces, refer to "Testing the Component Interfaces".

Testing the Component Interfaces

You must test each of the OracleAS Adapter for PeopleSoft Component Interfaces before using them.

To test the Component Interfaces:

1. In PeopleSoft Application Designer, open the IWY_CI_ATTRIBUTES Component Interface.

2. Select Tools, and then Test Component Interface.

   The Component Interface Tester dialog box is displayed.

   
   Description of the illustration compfacetesterdialog.gif
   
   
   
   

   Note: The Create New option is disabled because the Add method is not applicable to this Component Interface.

   
   

3. Click Find. Entries for the underlying component appear.

   A message may appear stating that display is limited to a certain number of entries. This is not a problem.

   
   Description of the illustration findresultsdialog.gif
   
   

4. Highlight one of the lines with its corresponding key in the Find Results window and click Get Selected. The relevant data for the selected key is displayed.

   If this window opens, the Component Interface has been successfully tested for the Find method.

   
   Description of the illustration compfacetesterwindow.gif
   
   

5. Click Get Existing. For the Get method, an existing key must be entered.

   
   Description of the illustration compfacetestdialog_bcn.gif
   
   

   The exposed properties for the key that is entered are returned.

   If the following window opens, the Component Interface has been successfully tested for the Get method.

   
   Description of the illustration compfacetesterwin_fkey.gif
   
   

6. Repeat this process for the IWY_CI_MESSAGES Component Interface.

You have finished testing the Component Interfaces.

Installing the TCP/IP Message Router for OracleAS Adapter for PeopleSoft

To enable PeopleSoft to send an XML event document to components using TCP/IP, you must install the type of TCP/IP message router required for your PeopleSoft release:

• For Release 8.4, install the TCP/IP target connector. For more information, refer to "Installing the TCP/IP Target Connector for PeopleSoft Release 8.4".

• For Release 8.1, install the TCP/IP handler. For more information, refer to "Installing the TCP/IP Handler for PeopleSoft Release 8.1".

Note: If you are not using PeopleSoft messages for event handling, you may skip this topic.

Installing the TCP/IP Target Connector for PeopleSoft Release 8.4

The TCP/IP target connector for PeopleSoft release 8.4 is installed with OracleAS Adapter for PeopleSoft. The default location on Microsoft Windows is OracleAS_home\adapters\application\etc\peoplesoft\iwpsevent84.jar.

Use the corresponding location on non-Windows systems.

To install the TCP/IP target connector for PeopleSoft Release 8.4:

1. Extract TCPIPTARGET84.class from iwpsevent84.jar. Use any extraction utility for your platform.

2. Port TCPIPTARGET84.class to the platform where the PeopleSoft gateway Web server is located.

3. Place TCPIPTARGET84.class in the PeopleSoft server target connector directory.

Installing the TCP/IP Handler for PeopleSoft Release 8.1

The TCP/IP target connector for PeopleSoft release 8.1 is installed with OracleAS Adapter for PeopleSoft. The default location on Microsoft Windows is OracleAS_home\adapters\application\etc\peoplesoft\iwpsevent81.jar

Use the corresponding location on non-Windows systems. If this location does not exist, contact your distributor for copies of the relevant files.

To install the TCP/IP Handler for PeopleSoft release 8.1:

1. Port iwpsevent81.jar to the platform on which the PeopleSoft gateway Web server is located.

2. Place iwpsevent81.jar in the servletclasses directory under the PeopleSoft Web server.

3. Extract the embedded class files.

Installing the TCP/IP Handler on a UNIX System

To install the TCP/IP handler for PeopleSoft release 8.1 on a UNIX system:

1. Log on to the UNIX system with the proper PeopleSoft ID and permissions.

2. Navigate to the PeopleSoft Web servlets directory. This may vary by release and by Web server, but is usually:

   
   $PS_HOME/webserv/servletclasses
   
   
   
   

3. Issue the jar command to extract the class files required by PeopleSoft.

   This is a sample command:

   
   jar -xvf /tmp/iwpsevent81.jar
   
   

   It displays the following output on a Sun or Solaris system:

   
   $ jar -xvf /tmp/iwpsevent81.jar
   
   created: META-INF/
   
   extracted: META-INF/MANIFEST.MF
   
   extracted: psft/pt8/tcphandler/TCPIPHandler81$Entry.class
   
   extracted:
   
   psft/pt8/tcphandler/TCPIPHandler81$HandlerEntry.class
   
   extracted:
   
   psft/pt8/tcphandler/TCPIPHandler81$PublicationHandler.class
   
   extracted: psft/pt8/tcphandler/TCPIPHandler81.class
   
   $
   
   

   
   

   Note: The files are placed in a new directory, tcphandler, under psft/pt8.

   
   

Copying PeopleSoft Files into the Lib Directory

Application Explorer creates XSD schemas and business services from PeopleSoft Component Interfaces, and creates XSD schemas from PeopleSoft messages. To do this, the following files must be in the OracleAS_home\adapters\application\lib directory.:

Ensure the following is in the lib directory:

• PeopleSoft Java Object Adapter (psjoa.jar)

  This file provides a low level interface between client applications and PeopleSoft. This file is provided with PeopleSoft and can be found in the following directory:

  
  PS_HOME\web\PSJOA
  
  
  
  

  The psjoa.jar file is different for every version of PeopleSoft. When you upgrade your Peopletools release, be sure to copy the new release's psjoa.jar file into the OracleAS_home\adapters\application\lib directory and restart all components.

• pstools.properties (for PeopleSoft 8.1.x)

  PeopleSoft release 8.1x requires an additional file, pstools.properties, found in the following directory:

  
  PS_HOME\web\jmac
  
  
  
  

• psoftcrmci.jar

  This is a set of Java classes generated from PeopleSoft Component Interfaces.