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