Understanding Common Functions that Reference a Password Data Store

The common functions discussed in this topic can be combined to reference a password database store. These functions can help achieve a sign on point between the portal and other target system software.

For each target system (email, web-based, and so forth), the user ID and password are stored and usually encrypted. When attempting to access information through PeopleSoft Interaction Hub features that need to retrieve information from these target systems, such as the Email pagelet, the PeopleSoft Interaction Hub performs the connection to the system using the user credentials stored in the password data store.

Note: This is a one-way integration. No data is written to the target system, such as Microsoft Exchange. A login is performed and data is retrieved, but user credentials or data is never updated in the target system.

The PeopleSoft Interaction Hub uses these functions for third-party email and calendar integration:

InsertUpdateUsrNamePsswd.

Used for inserting and updating.
GetUsrNamePsswd.
Returns the user name and password that are associated with a Uniform Resource Locator (URL) identifier and a portal user ID.
DeleteUsrNamePsswd.
Used for deleting.

For example, when accessing the Email pagelet, the Get function is called. It retrieves the user credentials from the data store, which can then be passed to the target system. The Insert/Update is used when the user sets up the pagelet for the first time, or subsequently updates his user ID or password. The Delete is used when the user deletes these stored credentials from the password data store.