Table of Contents

Search

  1. Preface
  2. Configuring PowerExchange for PeopleSoft
  3. Understanding PowerExchange for PeopleSoft
  4. Working with PeopleSoft Sources
  5. Application Source Qualifier for PeopleSoft Sources
  6. Accessing XLATTABLE Data
  7. Creating PeopleSoft Sessions and Workflows
  8. Datatype Reference
  9. PeopleSoft Language Codes
  10. Glossary

PowerExchange for PeopleSoft User Guide for PowerCenter

PowerExchange for PeopleSoft User Guide for PowerCenter

Step 1. Configure PeopleSoft Security

Step 1. Configure PeopleSoft Security

You can extract data from a PeopleSoft system while protecting the PeopleSoft metadata and data. To access PeopleSoft metadata and data, the PowerCenter Client and PowerCenter Integration Service require a database user name and password to read both the PeopleSoft metadata tables and the underlying physical database tables. While you can use the table owner names as the database user name, you can keep PeopleSoft metadata and source data secure by creating new database user names with read-only access. You can create one user for metadata and one user for source data. Alternatively, you can create a single user to access both metadata and source data.

0 COMMENTS

We’d like to hear from you!