Peoplesoft Administration Tools

Peoplesoft Administration Tools/Enterprise People Tools

Peoplesoft admin tools commonly referred to as Enterprise people tools make maintenance easy and cost-effective.

Uses Of People Tools :
1) Manage the applications deployed in the environment
2) Perform admin tasks such as configuring security,monitor performance,troubleshoot,upgrade to new version,apply patches,transfer data from target to source system.
3) Admin tasks can be performed using the browser interface that is used to perform peoplesoft business transaction

List Of Admin Tools :
1) PeopleTools Security.
2) PeopleSoft Performance Monitor.
3) PeopleSoft Diagnostic Framework.
4) PeopleSoft Data Mover.
5) Data Integrity Tools.
6) PeopleTools Utilities.
7) PeopleSoft Configuration Manager.

PeopleTools Security :
Peopletools security addresses the security threats by grouping access privileges(authorizations) in the form of rolesThere can be Manager role,admin role etc which restricts the access.There are different users when the application is deployed in production.The application can be accessed via internet and poses security threat.Limiting access through roles addresses this issue.Different users include suppliers,vendors,internet users,employees,customers.PeopleTools Security enables us to manage the role-based system, including directory group import capabilities, to leverage your Lightweight Directory Access Protocol (LDAP) directory facilities.

Peoplesoft Performance Monitor:
It is a built-in utility that enables sysadmins to monitor the performance of main elements in peoplesoft system,such as web servers,application servers,peplesoft process scheduler servers.
We can analyze historical data and monitor real-time performance.
We get the following reports using peoplesoft performance monitor:
1) Durations and key metrics of PeopleTools runtime execution, such as SQL statements and PeopleCode events.
2) Key resource metrics, such as host CPU utilization and web server execution threads.
The metrics provided by PeopleSoft Performance Monitor enable system administrators to:
1) Monitor real-time system performance.
2) Identify poorly performing tiers, hosts, domains, servers, application code, and SQL in a PeopleSoftenvironment.
3) Identify performance trends.
4) Address and isolate performance bottlenecks.

Peoplesoft Diagnostic Framework :
Peoplesoft Diagnostic Framework is designed to diagonize and resolve incidents by Peoplesoft Global Support Centre(GSC).
It enables the critical system data to be packaged and sent to PeopleSoft Global Support Center without the need for IT intervention. This reduces dministration overhead and can help PeopleSoft solve customer issues more quickly.

The diagnostic framework retrieves diagnostic information from a PeopleSoft database enabling us to:
1) Discover problematic application-related data.
2) Explore setup details.
3) Present information to PeopleSoft support in a common format.

Peoplesoft Datamover:
Peoplesoft datamover provides a development interface that enables us to script various maintenance tasks.Scripts can be run from command-line or development environment.

PeopleSoft Data Mover enables us to perform the following tasks:
1) Transfer application data between PeopleSoft databases.
2) Move PeopleSoft databases across operating systems and database platforms.
3) Execute Structured Query Language (SQL) statements against any PeopleSoft database, regardless of the underlying operating system or database platform.
4) Create, edit, and run scripts.

Peoplesoft Data Archive Manager:
Data Archiving that enables transaction recovery and maintains data integrity is critical for any application and Peoplesoft data can be archived using Peoplesoft data archive manager.

PeopleSoft Data Archive Manager provides an integrated and consistent framework for archiving data from PeopleSoft applications. Using a predefined template, we can select any queries and multiple objects that meet our archiving and restoration requirements. Leveraging the Archive Query in
PeopleSoft Query, we can easily define and customize your archive template.

Data Integrity Tools :
It is used to verify integrity of data in peoplesoft system.

We use these tools during installations, upgrades, and system configuration to verify the PeopleSoft system and compare it to the underlying SQL objects to ensure synchronization.

Data Integrity tools include:

SYSAUDIT - The System Audit (SYSAUDIT) identifies orphaned PeopleSoft objects and other inconsistencies within the system. An example of an orphaned object is a module of PeopleCode that exists, but which does not relate to any
other objects in the system.

DDDAUDIT - The Database Audit Report (DDDAUDIT) finds inconsistencies between PeopleTools record and index definitions and the database objects. This audit focuses on tables, views, and indexes.

SQL Alter - The PeopleSoft Application Designer SQL Alter function brings SQL tables into accordance with PeopleTools record definitions.

Peopletool Utilities :
The PeopleTools Utilities provides a set of tools for accomplishing some of these
more infrequent tasks.

Examples of tasks that require the use of the PeopleTools Utilities are:
1) Setting your base language.
2) Specifying a specific style sheet.
3) Setting PeopleBook Help locations.
4) Editing messages in the message catalog.
5) Entering values in the URL catalog.
6) Setting PeopleCode and SQL trace options.

Peoplesoft Configuration Manager :
PeopleSoft Configuration Manager simplifies Windows workstation administration by enabling us to adjust PeopleSoft registry settings from one central location.

The Configuration Manager applies only to workstations being used by developers and system administrators who need access to the development
environment. For example, developers who need to access PeopleSoft Application Designer to view and modify pages, records, components and so on need the appropriate options set in the PeopleSoft Configuration
Manager.

PeopleSoft Configuration Manager contains a variety of controls that let us set up workstations for connecting to the database, connecting to application servers, or setting trace options.

We can set up one development workstation to reflect the environment at our site, and then export the configuration file, which can be shared among all the development workstations at our site.