Understanding Administration Tools
This chapter provides overview information and discusses:
PeopleTools Security.
PeopleSoft Performance Monitor.
PeopleSoft Diagnostic Framework.
PeopleSoft Data Mover.
Data Integrity Tools.
PeopleTools Utilities.
PeopleSoft Configuration Manager.
Additional administration utilities.
Understanding Administration Tools
With Information Technology infrastructure becoming more complex, Enterprise PeopleTools offers the state-of-the-art tools to make maintenance easy and cost-effective. The Enterprise PeopleTools administration tools enable system administrators to manage the applications you have deployed within your organization. The administration tools enable you to perform numerous administrative tasks, such as configure security, monitor performance, troubleshoot, upgrade to new versions, apply patches, and transfer data from target to source systems. Most of the tasks can be completed using the same browser interface used for completing business transactions in PeopleSoft applications.
PeopleTools Security
The PeopleSoft security approach is tailored for the internet. As you implement PeopleSoft, you need a robust and scalable means by which you can grant authorization to users efficiently. When you deploy your applications to the internet, the number of potential users of your system increases exponentially. Suddenly, you have customers, vendors, suppliers, employees, and prospects all using the same system.
Just as PeopleTools provides the foundation for PeopleSoft applications, PeopleTools security provides the foundation for PeopleSoft security and for managing the user life cycle within the application.
You can apply security to all users, including employees, managers, customers, contractors, and suppliers. You group your users according to roles to give them different degrees of access. For instance, there might be an Employee role, a Manager role, and an Administrator role. PeopleTools security enables you to manage the role-based system, including directory group import capabilities, to leverage your Lightweight Directory Access Protocol (LDAP) directory facilities.
Users who belong to a particular role require a specific set of permissions, or authorizations, within your system so that they can complete their daily tasks. Because of the increase in users due to the internet deployment, PeopleTools security enables you to perform numerous maintenance tasks programmatically, which enables your system administrators to focus on other tasks. PeopleTools security also delivers robust encryption methods to provide additional custom data protection.
PeopleTools security also provides the capability for easily integrating enterprise user management and access applications like Oracle Access Manager and Oracle Identity Manager.
Additionally PeopleTools security implements the WS-Security framework to protect web services-based integrations.
See Also
Getting Started with Security Administration
PeopleSoft Performance Monitor
PeopleSoft Performance Monitor is a built-in diagnostic utility that enables system administrators to monitor performance of the main elements of your PeopleSoft system, such as web servers, application servers, and PeopleSoft Process Scheduler servers. You can monitor real-time performance as well as analyze historical data.
PeopleSoft Performance Monitor reports:
Durations and key metrics of PeopleTools runtime execution, such as SQL statements and PeopleCode events.
Key resource metrics, such as host CPU utilization and web server execution threads.
The metrics provided by PeopleSoft Performance Monitor enable system administrators to:
Monitor real-time system performance.
Identify poorly performing tiers, hosts, domains, servers, application code, and SQL in a PeopleSoft environment.
Identify performance trends.
Address and isolate performance bottlenecks.
See Also
Getting Started with Performance Monitor
PeopleSoft Diagnostic Framework
The PeopleSoft Diagnostic Framework is designed to facilitate the diagnosis and resolutions of incidents by Oracle Global Customer Support. It enables the critical system data to be packaged and sent to PeopleSoft Global Support Center without the need for IT intervention. This reduces administration overhead and can help PeopleSoft solve customer issues more quickly.
The diagnostic framework retrieves diagnostic information from a PeopleSoft database enabling you to:
Discover problematic application-related data.
Explore setup details.
Present information to PeopleSoft support in a common format.
See Also
Getting Started with Data Management
PeopleSoft Data Mover
PeopleSoft Data Mover enables the database administrator or system programmer to perform a number of functions, including:
Transfer application data between PeopleSoft databases.
Move PeopleSoft databases across operating systems and database platforms.
Execute Structured Query Language (SQL) statements against any PeopleSoft database, regardless of the underlying operating system or database platform.
Create, edit, and run scripts.
PeopleSoft Data Mover provides a development interface that enables you to create scripts using specific commands. You can run scripts from the development environment or from a command line. You use PeopleSoft Data Mover during the PeopleSoft installation, but it is also used for a variety of maintenance tasks.
See Also
Getting Started with Data Management
PeopleSoft Data Archive Manager
In any enterprise application, the ability to purge and archive transactional data is critical to data management. You need to have consistent methods to archive transactional data before your database increases to unmanageable sizes. PeopleSoft Data Archive Manager provides an integrated and consistent framework for archiving data from PeopleSoft applications. Using a predefined template, you can select any queries and multiple objects that meet your archiving and restoration requirements. Leveraging the Archive Query in PeopleSoft Query, you can easily define and customize your archive template.
See Also
Using PeopleSoft Data Archive Manager
Data Integrity Tools
PeopleSoft provides several tools to ensure the integrity of the data that is stored in the PeopleSoft system. Typically, you 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. |
See Also
Getting Started with System and Server Administration
PeopleTools Utilities
As you work with the PeopleSoft system, you find that there are some administrative tasks that you only need to perform occasionally. The PeopleTools Utilities provide a set of tools for accomplishing some of these more infrequent tasks. Although use of these utilities may be infrequent, they provide an easy means to manage important aspects of your PeopleSoft environment. Examples of tasks that require the use of the PeopleTools Utilities are:
Setting your base language.
Specifying a specific style sheet.
Setting PeopleBook Help locations.
Editing messages in the message catalog.
Entering values in the URL catalog.
Setting PeopleCode and SQL trace options.
See Also
Getting Started with System and Server Administration
PeopleSoft Configuration Manager
PeopleSoft Configuration Manager simplifies Windows workstation administration by enabling you to adjust PeopleSoft registry settings from one central location. Note that 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 you set up workstations for connecting to the database, connecting to application servers, or setting trace options. You can set up one development workstation to reflect the environment at your site, and then export the configuration file, which can be shared among all the development workstations at your site.
See Also
Getting Started with System and Server Administration
Using PeopleSoft Configuration Manager
Additional Administration UtilitiesWith Enterprise PeopleTools, you can also take advantage of:
Oracle Enterprise Manager.
Oracle Configuration Manager.
Oracle Enterprise Manager
Oracle Enterprise Manager provides a comprehensive, integrated management solution that helps you achieve high levels of performance and availability, and reduce the costs of managing applications. Oracle Enterprise Manager monitors the health of all application components, the hosts that they run on, and the key business processes that they support. Oracle Enterprise Manager’s diagnostic tools help to identify system issues for you to address. In addition to monitoring and diagnostics, Oracle Enterprise Manager also manages the configuration of application environments through its integrated configuration management tool. This tool provides the ability to configure application environments properly by keeping an inventory of application and infrastructure components, tracking the changes that are made, and validating the changes to make sure that they are correct. Oracle Enterprise Manager provides the tools that help organizations achieve the required application performance and availability, improve management productivity, better utilize resources, and drive down costs.
To integrate the Oracle Enterprise Manager with your PeopleSoft implementation, you can install the PeopleSoft Enterprise Environment Management Plug-in for Oracle Enterprise Manager (licensed separately from PeopleTools).
See Also
This document on oracle.com:PeopleSoft Enterprise Environment Management Plug-in for Oracle Enterprise Manager Implementation Guide
http://www.oracle.com/enterprise_manager/index.html
Oracle Configuration Manager
Oracle Configuration Manager is used to collect configuration information from your environment and store that information at Oracle to provide you proactive resolutions to issues affecting your specific environment. During your PeopleTools installation, you have the option of installing Oracle Configuration Manager along with PeopleTools. Oracle Configuration Manager, working in conjunction with Software Configuration Manager (SCM), enables Oracle to deliver:
Faster time to problem resolution.
Service Request (SR) management and tracking for your configurations.
Security patch advice and health checks specific to your configurations.
Knowledge content tailored for your configurations.
Note. There is no relationship between PeopleSoft Configuration Manager and Oracle Configuration Manager. PeopleSoft Configuration Manager is used only for configuring development workstations.
See Also
PeopleTools Installation Guide <for your platform>
http://www.oracle.com/technology/documentation/ocm.html