Preparing the PeopleSoft Environment

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.

Software Requirements

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

  • An appropriate RDBMS connectivity product on the computer where you will install the Adapter for PeopleSoft server. This is to provide access to a PeopleSoft data source server for operational data access.
  • To support integrated authentication to PeopleSoft 8.1 or higher, Java 2 SDK version 1.3.1 or higher must be installed. Additionally, Publish and Subscribe services must be active on the PeopleSoft Application server.
Note: For information about PeopleSoft with versions of software other than those listed in this topic, contact Customer Support Services.

WebFOCUS Client Compatibility

The PeopleSoft adapter will return a FOC047 error message as the result of any query when the WebFOCUS client setting of DBA source is set to IBIMR_user. If this setting is required to be active with the PeopleSoft adapter, please contact Cusstomer Support Services.

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

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.