Connecting to PeopleSoft Instances

To schedule workload in an PeopleSoft instance, you must first set up a connection between Redwood Server and the PeopleSoft instance.

  • A PeopleSoft object that points to the underlying Oracle database
    • As soon as you create it, it will create a Process Server and Queue

J2EE URL

The URL must be defined in the PeopleSoft system; navigate to Main Menu > PeopleTools > Integration Broker > Configuration > Service Configuration.

Copy 
http[s]://<server>:<port>/PSIGW/PeopleSoftServiceListeningConnector
  • <server> - the FQDN of the PeopleSoft host
  • <port> - the port of the PeopleSoft host

Example:

Copy 
http[s]://ppl.example.com:8000/PSIGW/PeopleSoftServiceListeningConnector

You can also access https://<host>:<port>/PSIGW/PeopleSoftServiceListeningConnector/PROCESSREQUEST.1.wsdl and locate the PROCESSREQUEST_Port entry:

Copy 
<wsdl:service name="PROCESSREQUEST">
  <wsdl:documentation>Reporting Web Service</wsdl:documentation>
  <wsdl:port binding="tns:PROCESSREQUEST_Binding" name="PROCESSREQUEST_Port">
    <soap:address location="https://ppl.example.com:8000/PSIGW/PeopleSoftServiceListeningConnector"/>
  </wsdl:port>
</wsdl:service>

Credentials

The username and password is stored in a credential. Redwood Server retrieves the username and password by using the PeopleSoft credential which has an Endpoint matching the value of the PeopleSoft object and has default set as the Virtual Username.

Prerequisites

  • PeopleSoft 8.5 or higher
  • The PeopleSoft plugin requires version 9.2 or higher
  • on-site-related topic Connectivity from the central Redwood server to the PeopleSoft server on its port
  • cloud-related topic Connectivity from the Secure Gateway to the PeopleSoft server on its port

To connect to instances of PeopleSoft, you need a free slot in the ProcessServerService.PeopleSoft.limit license key.

Procedure

Create an PeopleSoft System object

  1. Navigate to "Environment > PeopleSoft".
  2. Choose New PeopleSoft System from the context menu.
  3. Fill in the fields Name (referred to as <pps_name>), J2EE URL, and Default Time Zone.
  4. Click Save & Close.
  5. Navigate to "Environment > Process Servers".
  6. Click Save & Close.

Create the credential for PeopleSoft

  1. Navigate to "Security > Credentials".
  2. Choose New Credential from the context menu, select PeopleSoft as a protocol, fill the connection string into the Endpoint property and default into the Virtual Username field. Fill the username and password into the respective fields.

Start the Process Server and submit a test job

  1. Navigate to "Environment > Process Servers".
  2. Choose Start from the context menu of the Process Server <pps_name>_ProcessServer.
  3. Refresh the window until the Process Server is starting, if after two minutes the Process Server has not started, inspect the Operator Messages Monitor.
  4. Navigate to Definitions > Processes and choose Submit from the context menu of System_PeopleSoft_ProgramImport.
  5. Choose the <pps_name>_Queue Queue served by the PeopleSoft Process Server and monitor the process until it reaches the status Completed, if the it reaches status Error, check "Monitoring > Operator Messages".