Stat for PeopleSoft

Simplified PeopleSoft Change Control & Change Management

Stat® for PeopleSoft is a version control and change management software that provides you with increased visibility into – and control over – the change process, allowing your organization to be more responsive to updates and patches. By implementing Stat, you can help manage change, establish and maintain change control, ensure your organization achieves regulatory compliance, and reduce the total cost of ownership of PeopleSoft applications.

Integrated with Oracle PeopleSoft Enterprise

Enforce separation of duties for improved compliance
Simplify migration with pre- and post-migration analytics
Automate rollback through native object support
Manage configuration and setups
Evaluate the impact of patches and customizations
Manage all applications from one repository for easier auditing
Control Hyperion, Informatica and other supporting applications

Get Started

Features
Sys Reqs
Videos
Screenshots
Docs

Third-Party Version Control Support – Archive and migrate objects from SVN, CVS and PVCS.
Custom Reports – Create reports according to unique requirements, including global parameters definitions, additional fields from the SQL query, layout and style preferences, and more.
Pre- and Post-Migration Steps on Distributed Environments – View and execute both post- and pre-migration steps on distributed databases from the window that comes up after a migration.
Pre- and Post-Migration Steps on Mass Migrations – Run the steps directly from the Mass Migration wizard as opposed to having to open each individual CSR.
Customized Migration Order – Specify the migration order in the Mass Migration Wizard for automatic CSR moves.
Automated Patching – Automate and enforce pre-determined, best-practice, and optimized change management processes, minimizing risk of manual error and allowing developers and DBAs to focus on higher-value activities.
Impact Analysis – Identify the impact that object modifications and patches have on other objects as the changes cascade through the system. This analysis provides you with a complete report of all changes impacting a given instance, allowing for a more streamlined testing process.
Version Control and Roll Back – Capture an unlimited number of interim application versions (“snapshots” taken during development), which can be archived with any combination of objects/files in each version. When necessary, this allows for selective retrieval and rollback (by object/file).
Workflow for Project and Process Management – Track all issues, automate team processes, group tasks by project, assign status requirements, and provide approval authorization. You can manage this from one central location, through either the Stat client for the Web or for Windows.
Regulatory Compliance Management – Ensure regulatory compliance by locking out and auditing unauthorized changes to an application. Stat enforces change policies via workflow, role-based security rights and audits of any and all changes to the underlying business logic. Stat also provides compliance-related reports for easily achieving compliance objectives.
Support for PeopleSoft Unicode Databases – Support the locking, archiving and migration of all PeopleSoft Unicode data.

Core Concepts

Support objects natively
Enforce separation of duties
Reduce or eliminate manual tasks by streamlining and automating change management processes
Enhance the structure of change processes

Evaluate the impact of patches before applying them to any environment
Manage change-related data centrally to provide quick access
Improve change processes by providing a more stable and secure environment

Change Request Management

Issue tracking for the help desk
Project management
Automatic escalation of assigned or past due tasks
Custom description templates

Integration with 3rd party service desks
Notifications as requests are worked
Ability to handle attachments

Workflow

Ease of configuration
Integrated approvals
User defined tasks/workflow
Minimal consulting services required

Enforcement of required approvals
Email-based approvals
Different behavior based on change type

Version Control and Object Management

Manage objects in their native form: PeopleSoft proprietary objects
Maintain multiple versions of objects
Create and edit objects
Data Objects (e.g. PeopleSoft Functional Configuration Data) archive & migration
Schema Objects (e.g., tables, views, index, etc.) archive & migration
Provide wizards to facilitate object management

Establish baselines
Lock down objects
PeopleSoft proprietary objects
Track and display object history
Co-exist with existing version control system

Migration Management

Migrate any or all objects
Define the migration path
Synchronize environments
Complete the migration
Post migration steps
Support for SSH protocol in script execution

Direct/Point-to-Point Migrations
Enforce required approvals
Migrate multiple projects simultaneously (mass migration)
Pre migration steps
Database refreshes
Roll back changes, if required (individual objects, projects, packages)

Patch Management

Compare patch levels between environments
Impact analysis across multiple environments
Evaluate whether pre-requisites have been met

Analyze the impact of new patches on objects
Import patch projects

Auditing and Reporting

Role-based access controls
Centralized repository of change data
Custom reports
Scheduled report generation

Audit trail of all application-level change activity
Pre-defined change history reports
Web-based interface for ad-hoc reporting
Distribution of reports via email, PDFs, etc.

Product Architecture

Centralized server for minimal overhead
Support for multiple database connections
Complete, self-contained, fully integrated solution

Choice of platforms (Windows, Unix, Linux)
Web client interface for functional users and administrators

Supported Databases

DBMS	Oracle: 9i version 9.0.1 and higher, 10g version 10.1.0.2 and higher, and 11g (Unicode and non-Unicode support for all Oracle DBMS) MS SQL Server: 2005, 2008 (Unicode and non-Unicode: ISO Character Set with Unicode collation. Database defined with BINARY collation) Notes: Can reside on same server as PeopleSoft or Oracle E-Business database or separate server. If PeopleSoft is configured for Unicode operation, the Stat database must be also.
Hardware Requirements	Hardware independent. Must support Oracle or SQL Server.
Minimum Requirements	Development database: 4 GB Demo database: 500 Mb Production database: 20 GB (growth varies dramatically by usage)

Stat Client

Operating System	Windows 2000, Windows XP Professional (current SP recommended), Windows Vista and Windows 7 (32-bit)
Database Connectivity	Oracle: Oracle Client 9, 10 and 11 MS SQL Server: 2000 client, 2005 client, 2008 client
Minimum Requirements	866 MHz, 256 Mb RAM per user on same machine Disk: 500 Mb for local install (recommended) or <1 Mb w/network install with 500 Mb on the network
Web Browser	Microsoft Internet Explorer (Windows) Versions 6.0, 7.0, 8.0, Mozilla Firefox 3.5, Apple Safari 4 and Opera Opera 9.6

Stat Server

Operating System and JDK/SDK	Standalone configuration (recommended): Windows 2000 Server SP2, XP Professional, 2003 Server, Windows 2008 Server, Red Hat Enterprise Linux AS release 4 and release 5, Solaris 8, Solaris 9, Solaris 10, HPUX 11.11 and 11.23 or 64bit AIX v5.2, 5.3 or 6.1 (all English-based) JDK/SDK Versions: 1.5.x; 1.6.0_5 or higher Windows, Solaris, and RedHat Linux require Sun’s JDK/SDK HPUX 11.11, 11.23 requires HP’s JDK/SDK 64bit AIX v5.2, 5.3 and 6.1 requires IBM’s JDK/SDK Standalone configuration not recommended on same machine as SQL Server Stat Database WebLogic configuration (optional): WebLogic 10.3 and higher
Minimum Requirements	1 GHz (2GHz recommended for 20+ users) Pentium 4 (or equivalent) RAM: 512 MB (2 GB recommended for 20+ users) DISK: 1 GB
E-mail	Supported protocols: Outbound e-mail-SMTP, Secure SMTP, Inbound e-mail- IMAP4, Secure IMAP4, POP3 and Secure POP3

PeopleSoft Environment

PeopleTools Applications	Supports all applications that are certified by PeopleSoft to run on the following PeopleTools versions: v7.0 (all versions), v7.5 (all versions), v8.0-v8.22, and v8.4-v8.52.
PeopleSoft Applications	Supports all PeopleSoft Applications built on PeopleTools, including but not limited to the following: CRM (Customer Relationship Management) EPM (Enterprise Performance Management) ESA (Enterprise Service Automation) Financials Human Resources Management Portal Solutions Student Administration Supply Chain Management Trading Exchange Services Other (e.g., custom applications, etc.)
Supported Databases	Oracle: Oracle 8i, 9i 10g, and 11g (Unicode and non-Unicode) Connectivity: Oracle Client 9i MS SQL Server: 2000, 2005, 2008 (Unicode and non-Unicode: ISO Character Set with binary collation) Connectivity: SQL Server 7.0, 2000 client, 2005 client Note: PeopleTools 8.48 and higher require Stat to be running on SQL Server 2005 client. Sybase: ASE 12.5, 15.0 (Unicode and non-Unicode) Connectivity: Sybase ASE ODBC client DB2: DB2 UDB 7.1, 8.1, 9.1, 9.5, 9.7 (AIX, OS/390, z/OS) Notes: Stat supports the locking, archival and migration of all PeopleSoft Unicode data. Character sets other than Western cannot be entered directly into Stat through the Stat GUI interface. All Stat features are available for use in a Unicode environment except for File Object Impact Analysis and File Compare & Merge.
FTP, SSH Servers Requirements	Must be NT, Unix, MVS or Netware compatible; SSH2 must use standard format listing; OpenSSH (UNIX and Windows), SSH Communications Corp. (UNIX and Windows), bitwise WinSSHD, and wodSSHServer are supported. VanDyke VShell 2.1 is NOT supported. The configuration of your SSH server determines which ciphers are used when connecting to the Stat Server. The Stat Server currently supports the following cipher and MAC configurations: Ciphers: Blowfish Triple DES AES128Ctr AES192Ctr AES256Ctr Message Authentication Code (MAC): HMAC-MD5 HMAC-SHA1 HMAC-MD5-96 HMAC-SHA1-96