Preparing the Environment

In this section:

Prior to configuring the Adapter for PeopleSoft, you must ensure that minimal software requirements have been met. In addition, you must define a PeopleSoft Access ID to enforce PeopleSoft security. Administrators must also review available connection options before beginning the initial configuration.


Top of page

x
Software Requirements

The following software is required on the server to support the Adapter for PeopleSoft:

Note: For information about PeopleSoft with versions of software other than those listed in this topic, contact your Information Builders representative.


Top of page

x
Setting Up the PeopleSoft Access ID

The Adapter for PeopleSoft initially authenticates with PeopleSoft using a PeopleSoft application user ID and password. If successful, the adapter attaches to the RDBMS using an access ID of your choice. Typically, this access ID is either the default PeopleSoft access ID (often it is SYSADM), or it is an RDBMS ID dedicated to the adapter. In either case, the access ID must have read access to the following PeopleSoft tables and views:

PSCLASSDEFN

PSDBFIELD

PSDBFLDLABL

PSOPRCLS

PSOPRDEFN

PSOPTIONS

PSPRCSQUE

PSPRCSRQST

PSRECDEFN

PSRECFIELD

PSRECFIELDDB

PS_SCRTY_ACC_GRP

PS_TREE_ACCESS_VW

PSTREEDEFN

PSTREENODE

In addition, the access ID must have read access to any PeopleSoft Records that you wish to report against. If your PeopleSoft Records have row-level security, this ID must also have read access to the Query Security Records associated with each.

Note: The PSPRCSRQST and PSPRCSQUE tables are required only for Process Scheduler integration. If you are using this integration, these two files will also require write privileges.


iWay Software