Peoplesoft Integration Kit

Crystal Reports has been embedded in PeopleSoft for many versions. The BusinessObjects integration kit for PeopleSoft extends the usefulness of the embedded reporting functionality by providing all the features of Business Objects XI to the report consumer.

Reporting Off Peoplesoft Data

The native PeopleSoft driver connects to the PeopleSoft query as defined within the PeopleSoft system. Furthermore, because you are required to pass a username to the PeopleSoft system, the driver will honor the parameters and security defined by the PeopleSoft query. To access the PeopleSoft query, select the PeopleSoft driver from the list of drivers available to Crystal Reports. After authenticating, a list of accessible queries becomes available. Select a query, and Crystal Reports treats the query's resulting recordset the same way it treats a table. The developer is presented with a listing of fields that make up the query. These fields can then be dragged onto the report and the report can be developed as described in the first half of this book.

Viewing the Reports

After the report is complete, the user can publish the report and this report can then be viewed via InfoView. The integration kit allows for PeopleSoft authentication so PeopleSoft users can log on to InfoView using their PeopleSoft credentials. The security integration creates a group in Business Objects XI for each PeopleSoft role that is mapped. A single install of Business Objects XI can be mapped to multiple PeopleSoft domains.