Cisco Cisco Workload Automation 6.3 User Guide

Configuring the PeopleSoft Adapter

Configuring the Adapter

A check mark appears next to the 

 function category indicating that one or more functions are selected 

within the category.

If needed, different security policies with varying authorized functions can be created to provide different levels of access 
for a variety of users.

Defining PeopleSoft Users

Before you can work with PeopleSoft jobs in CWA, an access ID to the Process Scheduler database tables (the database 
owner or equivalent) and one or more application users (operator IDs) must be defined in CWA. These user definitions 
authorize a connection to be established to the PeopleSoft database and permit requests to be made on behalf of 
application users.

Access to the PeopleSoft environment can be controlled by creating specific user definitions with PeopleSoft privileges. 
Scheduling administrators can grant runtime user (operator ID) privileges to other users who need to run PeopleSoft jobs. 
Scheduling users can also be limited to specific PeopleSoft instances or servers, if desired.

The user of the PeopleSoft adapter for CWA is limited when running PeopleSoft to the same privileges available 

to the PeopleSoft operator IDs created by the PeopleSoft Administrator. Be sure that the operator ID has read access to 
the PeopleSoft run control values for each process that needs to be scheduled.

The PeopleSoft administrator must provide the CWA administrator with an access ID that consists of the name and 
password of a database account with access to the Process Scheduler database tables. In this documentation, this user 
account is referred to as the PeopleSoft database user. This is a runtime, non-interactive, user account and is only used 
to provide backend access to the PeopleSoft database by CWA. The database connection for this user is not made 
directly available to any scheduling user.

CWA reads from a large number of data tables, but only updates the following:



 (insert, update and delete process requests)

As of PeopleTools 8, CWA also updates the following tables:



 (update of 

 and 

)



 (controls access to output, logs and other content)



 (inserts column in distribution table)



(updates and modifies request parameters)



 (queues process requests)



 (controls report distribution text associated with process requests)



(specifies the operator IDs and/or roles as the target of report distribution)



(demonstrates how run control values are passed to processes that run within the Process 

Scheduler)

Your PeopleSoft administrator might not allow access to the database owner account, though it is strongly 
recommended. If the database owner

account is not used, verify that the database user account provided for CWA can 

update the tables listed above along with read access to other tables as described in 

.

Adding the PeopleSoft database user to CWA is the same as adding any other CWA user. The CWA administrator must 
create a user record for accessing the PeopleSoft database using the name and password that the PeopleSoft 
administrator provides.