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.
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.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. |