4
Using the Configuration Editor

This chapter describes how to use the Configuration Editor to configure the PeopleSoft 7.5x adapter. The Configuration Editor is only used at runtime. The following topics are discussed:

• Configuration Editor

• PeopleSoft Login

• PeopleSoft Scalability

• Data Formats

  Note: Profiles and Deployment are sensitive to the Master Key setting. If using a shared machine, before accessing the Configuration Editor ensure the Master Key is set to either that of User1 or create a new Master Key for your profiles. Refer to the Oracle Application Server InterConnect Configuration Editor User's Guide for more information on the Master Key.

Configuration Editor

To configure settings for the PeopleSoft 7.5x adapter you must access the PeopleSoft Configuration Editor as follows:

1. Change directories to the installation directory using a command prompt.

2. Type configeditor and press Enter.

   The Configuration Editor displays.

3. Select PeopleSoft to edit the PeopleSoft configuration settings for your profile.

   Note: Under some circumstances you may wish to run your adapter under a profile other than iStudio. This may be needed, for example, if you want to run two instances of the PeopleSoft 7.5x adapter on the same machine. You may want to have two instances of the same type of adapter if these instances need to connect to different backend system installations. To accomplish this create a new profile using the configuration editor and enter the settings for this new profile. The name of the new profile should be the same as the name of the application. For example, if your application is called APP2, create a profile called APP2. Now APP2 uses the settings in the profile called APP2, whenever it runs.

4. Click Profile.

5. Select Set As Default from the Profile dropdown menu.

6. Select your new profile.

   Figure 4-1 Configuration Settings Editor

   

   Text description of the illustration istudioconfigsettings.gif

7. Click OK.

8. Select File > Exit to exit the Configuration Editor after completing the setup.

PeopleSoft Login

The Login branch is only available for user-defined profiles and provides connection information to a PeopleSoft system. You must identify both the ODBC driver and the Application driver as the PeopleSoft Service Provider supports both queries and message.

Figure 4-2 Login Panel

Text description of the illustration istudiologin.gif

Table 4-1 Login Panel Configuration Settings 

Login Panel Fields	Field Description
Data Source Name	This works in a two-tier mode and is used for queries, for example, Microsoft SQL Server. Insert the ODBC driver: Select the Control Panel > ODBC Data Source and make sure that a PeopleSoft Data Source is available and that the PeopleSoft Data Source points to the correct data. Open the database by double-clicking the data source to view the DataBase Name. Insert the Data Source Name from the Control Panel dialog into this text area.
Application Server Name	This works in a two-tier mode and is used for queries, such as Microsoft SQL Server. Insert the ODBC driver: Select Control Panel > ODBC Data Source and make sure that a PeopleSoft Data Source is available and make sure that the PeopleSoft Data Source points to the correct data. Open the database by double-clicking the data source to view the DataBase Name. Insert the Data Source Name from the Control Panel dialog into this text area. On a Unix systems, the form is machine_name:port_number. For example, People2:7000.
Operator ID	Insert the identification used to access the PeopleSoft application.
Password	Enter the PeopleSoft password. The Password is only editable under specific user-defined profiles.
PeopleSoft Version	Select the version of the PeopleSoft application.

PeopleSoft Scalability

The PeopleSoft setup predetermines the total number of servers. This tab determines how servers are to be used with the PeopleSoft 7.5x adapter and the server process idle time-out.

Figure 4-3 Scalability Panel

Text description of the illustration istudioscalability.gif

Table 4-2 Scalability Panel Configuration Settings 

PeopleSoft Scalability Panel Fields	Field Description
Message Agent Servers	Maximum Number of Servers--The setting defaults to one server. The maximum number is determined by the PeopleSoft system. The adapter's API--psmsrv75 (for PeopleSoft 7.5.x) is the Message Agent Server providing PeopleSoft libraries with scalability. As PeopleSoft libraries are not multi-threaded, scalability can only be achieved by having several processes. Reclaiming Interval--The default setting is 5 minutes. After a set period of time of no activity, a server process is stopped to be re-used by another process. It is important that this setting not be too low--making allowances for the connection time to a PeopleSoft system.
Open Query Servers	Maximum Number of Servers--The setting defaults to one server. The maximum number is determined by the PeopleSoft system. The adapter's psqrysrv (PeopleSoft 7.5.x) is the Query Server providing PeopleSoft libraries with scalability. As PeopleSoft libraries are not multi-threaded, scalability can only be achieved by having several processes. Reclaiming Interval--The default setting is 5 minutes. After a set period of time of no activity, a server process is stopped to be re-used by another process. It is important that this setting not be too low--making allowances for the connection time to a PeopleSoft system.

Data Formats

The Data Formats tab provides conversion information for date and time strings used in messages. This tab is for those applications requiring a date, for example, Automation applications. The information is determined by the PeopleSoft system.

Figure 4-4 Data Format Panel

Text description of the illustration istudiodataformats.gif

Table 4-3 Data Format Panel Configuration Settings

Data format Panel Fields	Field Description
Date	The format is MM/DD/YYYY.
Time	The format is hh:mm:ssAA, where AA is either AM or PM.
Date Time	The format is MM/DD/YYY hh:mm:ssAA, where AA is either AM or PM.