Creating or editing a PeopleSoft endpoint

PeopleSoft endpoints provide the connection information that Studio and the Integration Appliance use to connect to specific PeopleSoft servers and database instances. You can create multiple endpoints that refer to separate instances.

Procedure

  1. To create a new PeopleSoft Endpoint:
    1. Click New Endpoint in the Studio Project tab toolbar and choose PeopleSoft from the menu

      OR

      Right-click the Endpoint folder in the Project tab and choose PeopleSoft from the menu.

      A new connector displays in the list, and a blank PeopleSoft pane displays in the workspace.

      The connector listing is assigned a PeopleSoft label, appended with a number.
    2. To edit this name to reflect the connector's application, right-click the listing and choose Rename.
  2. To open an existing endpoint:
    • Expand the Project tab Endpoints folder and double-click the existing endpoint listing.
  3. To configure the endpoint settings:
    1. When the PeopleSoft pane displays in the Studio workspace, configure the available options as described in the following tables.
      Note: If you are editing an existing endpoint, changing the properties of that endpoint globally affects all orchestrations that use that endpoint.
    2. When option configuration is complete, click Test Connection. This confirms that Studio can connect to the specified database.
    3. When the test results dialog box is displayed, click OK. If the test fails, the test results dialog box suggests tips for diagnosing the failure.
      Configuration Description
      Server Name Specifies the name or IP address of the machine hosting the PeopleSoft application.
      Port Specifies the port number assigned to the PeopleSoft application.
      User Name Specifies the user name that the Integration Appliance uses to connect to the PeopleSoft application.
      Password Specifies the password associated with the application-access user name.
      Database Configuration  
      Use Database for Browse in Configure Panel Ensure that this option is selected and provide the following Database Configuration parameters so that you can browse the database when configuring the PeopleSoft activity. When the checkbox is selected,  metadata discovery happens using the PeopleSoft database directly. This option is not required for the Receive Message activity.
      Connection URL Specifies the full URL assigned to this PeopleSoft database instance.
      Database Driver Specifies the driver.
      Database Schema Specifies the schema used by this database.
      User Name Specifies the user name used by the Integration Appliance to connect to the specific database instance.
      Password Specifies the password associated with the database-access user name.
      Connection Pool Options  
      Minimum Connections Specifies the lowest number of database connections that the Integration Appliance keeps open in the connection pool. Entering 0 (zero) is supported.
      Maximum Connections Specifies the maximum number of database connections that the Integration Appliance can keep open in the connection pool. Entering 0 (zero) means the maximum number of connections is unbounded.
      Maximum Idle Time Specifies the amount of time in minutes that a database connection can be open and idle before being closed by the Integration Appliance. Entering 0 (zero) means that the connections are closed when they are returned to the pool—no idle time.
      Maximum Wait Specifies the amount of time in seconds that the Integration Appliance waits for an unresponsive database connection before cancelling the attempt.