Preparing the PeopleSoft Environment

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 your Information Builders representative.

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 Information Builders support.

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:

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.