Stat for PeopleSoft

Change management and version control software

Simplify change management requirements for PeopleSoft applications.

Respond faster to updates and patches with this change management software that provides better visibility and control. Establish and maintain change and version control to ensure your organization meets regulatory compliance and lower the total cost of ownership of PeopleSoft applications.

  • Enforce separation of duties for better compliance
  • Schedule migrations during off hours
  • Streamline migration with pre- and post-migration analytics
  • Automate rollback through native object support
  • Manage configuration and setups
  • Analyze the effect of patches and customizations
  • Control all applications from a single repository for simpler auditing
  • Manage Hyperion, Informatica and other supporting applications

Features

  • Off-hours code migrations – Schedule migrations of code during off hours, without manual or user intervention.
  • Third-party version control support – Archive and migrate objects from SVN, CVS and PVCS.
  • Custom reports – Gain more flexibility with customized reports that include unique requirements, such as global parameters definitions, additional fields from the SQL query, layout and style preferences, plus much more.
  • Pre- and post-migration steps on distributed environments – Determine and complete 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 – Quickly complete the steps directly from the mass migration wizard, instead of being forced to open each CSR.
  • Customized migration order – Determine the migration order in the mass migration wizard for automatic CSR moves.
  • Automated patching – Reduce the risk of manual errors, and enable developers and DBAs to concentrate on more critical activities by automating and enforcing pre-determined and optimized change management processes.
  • Impact analysis – Experience a simpler testing process with an analysis that delivers a full report of the changes that impact a specific instance. Understand the influence that object modification and patches have on other objects as changes move through the system.
  • Version control and roll back – Archive any combination of objects/files in each version as you capture an unlimited amount of interim application versions or “snapshots.” Experience selective retrieval and rollback by object/file.
  • Workflow for project and process management – Control a variety of activities (through the Stat client for the web or for Windows) from a central location. Monitor all issues, automate team processes, organize tasks by project, assign status requirements and deliver automated approval authorization.
  • Regulatory compliance management – Lock out and audit unauthorized application changes to ensure compliance. Enforce change policies by workflow, role-based security rights and audits of any changes to the underlying business logic. Get compliance-related reports that help you achieve compliance objectives.
  • Support for PeopleSoft Unicode databases – Support the locking, archiving and migration of all PeopleSoft Unicode data.

Specifications

Stat Environment

DBMS

Oracle: 9i version 9.0.1 and higher (see note), 10g version 10.1.0.2 and higher, 11g, and 12c (Unicode and non-Unicode support for all Oracle DBMS). Oracle client must be 32-bit.

Note: Oracle E-Business is only supported on an Oracle Stat database. Also, 9i databases are no longer supported by Oracle.  Some features may not function as expected.

MS SQL Server: 2005, 2008, 2012, 2014 (Unicode and non-Unicode: ISO Character Set with
Unicode collation. Database defined with BINARY collation).

Note: If you are running Stat on Microsoft SQL Server and your PeopleTools environment is 8.48 or higher, Stat must be on at least MSS 2005, regardless of the PeopleTools platform. Also, If PeopleSoft is configured for Unicode operation, the Stat database must be as well.

 

Minimum requirements

Development database: 4 GB available disk
Production database: 20 GB available disk (size can grow dramatically)

Stat client

Operating system

Windows XP Professional (current SP recommended), Windows Vista, and Windows 7/8 – 32-bit or 64-bit

Note: The Stat client is a 32-bit application. It can run on a 64-bit workstation or Windows server. In some cases the compatibility mode may need to be set to XP

Database connectivity

Database connectivity must be 32-bit, even on a 64-bit device.

Oracle: 9, 10, 11, and 12 (client must be compatible with RDBMS version and must be 32-bit)

MS SQL Server: SQL Server 2000 client, 2005 client, 2008 client, 2012 client

Web browser

Microsoft Internet Explorer (Windows) Versions 9, 10 and 11
Mozilla Firefox 18 and higher
Apple Safari 6.0 and higher
Opera 11.5 and higher
Chrome 23 and higher (see known issue 0236176)

Minimum requirements

CPU: 1.6 GHz or greater
RAM: 1 Gb RAM
Disk: 500 Mb for local install (recommended) or <1 Mb w/network install with 500 Mb on the network

Stat Central agent

Operating system and JDK/SDK

Standalone configuration (recommended):

Windows Server 2008, Windows Server 2012, Red Hat Enterprise Linux release 5 and 6, Solaris 8, Solaris 9, Solaris 10, HPUX 11.11 and 11.23 or
64bit AIX v5.2, 5.3, 6.1, or 7.1 (all English-based)

NOTE: The Stat Central Agent can run on Windows 64bit machines JDK/SDK Versions (32-bit): 1.6.0_x (1.6.0_5 minimum); 1.7.0_x
Windows, Solaris, and RedHat Linux require Oracle(Sun) JDK/SDK (32-bit)
HPUX 11.11, 11.23 requires HP JDK/SDK (32-bit)
64bit AIX v5.2, 5.3, 6.1 and 7.1 requires IBM JDK/SDK (32-bit)
Standalone configuration not recommended on same machine as SQL
Server Stat Database

Oracle Fusion Middleware 11g configuration (optional):

WebLogic Application Server 10.3.3-10.3.6

Minimum requirements

CPU: 2.5 GHz (Dual Core processor )  Core i3 (or equivalent)
RAM: 2 GB
Disk:  500 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.54.

PeopleSoft Applications

Supports all PeopleSoft Applications built on PeopleTools.

PeopleSoft Databases

Supports the following database platforms in conjunction with PeopleTools

Supported Platforms:

  • Oracle (8i, 9i, 10g, 11g, and 12c)
  • MS SQL Server (2000, 2005, 2008, 2012, and 2014)
  • DB2 UDB (7.1, 8.1, 9.1, 9.5, 9.7 on Aix, OS/390, z/OS; 10 on z/OS)

 

Oracle E-Business Suite

Releases

Stat supports all products, including custom products, in the Oracle's EBusiness Suite Release 11i (11.5.10 and higher), 12, 12.1.x, 12.2.x. Some Stat features will depend on the AD product release.

Technology stack

All components of the technology stack for the Oracle E-Business Suite should be in compliance with Oracle's certification requirements

Stat Oracle Agent - Hardware platforms

All versions of Sun SOLARIS, HP-UX, AIX, Linux and Windows certified with Oracle E-Business Suite. Stat will be certified with most UNIX and Intel based platforms supported by Oracle. Contact Dell Software for updated platform certification.
JDK/SDK Versions:  1.6.x (minimum 1.6.0_5); 1.7.0_x
Windows, Solaris, and RedHat Linux require Sun's JDK/SDK
HPUX 11.11, 11.23, 11.31 requires HP's JDK/SDK
64bit AIX v5.2, 5.3, 6.1, and 7.1 requires IBM JDK/SDK (32-bit)

Developer object compare

Oracle developer object comparison is an optional feature with its own requirements. To enable object compare support for Oracle developer objects, a compatible version of Oracle Developer and the Forms Applet Jar Files component of the Oracle Forms product must be installed. Additional requirements are needed for the following:

  • To enable object compare support for Oracle developer objects in patches, the Oracle JVM and the file stat_db.jar must be installed.
  • To enable object compare support for form library files that have attached libraries, the FORMS60_PATH environment variable must be set to reference a staging directory (FORMS PATH for FORMS 10).

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, AES128CBC
  • AES192Ctr, AES192CBC
  • AES256Ctr, AES256CBC

Message Authentication Code (MAC):

  • HMAC-MD5
  • HMAC-SHA1
  • HMAC-MD5-96
  • HMAC-SHA1-96

Screenshots

loading

Stat for PeopleSoft

Take a Screenshot Tour

Stat for PeopleSoft

Stat for PeopleSoft

Enforce custom business rules via workflows

Stat for PeopleSoft

Stat for PeopleSoft

Email integration, Help Desk integration for workflow actions.

Stat for PeopleSoft

Stat for PeopleSoft

Manage change of both PeopleSoft database and flat file objects.

Stat for PeopleSoft

Stat for PeopleSoft

Restore objects and files immediately to a prior version.

Stat for PeopleSoft

Stat for PeopleSoft

Offer complete change management and version control – certified by PeopleSoft.