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® 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: PeopleSoft® 8.54 and higher requires Oracle 64 bit client.

Note: Oracle E-Business is only supported on an Oracle Stat database.

Microsoft® 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 disk space

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

Stat client

Operating system

Windows Vista®, Windows® 7, Windows 8 (32-bit or 64-bit), and Windows 10

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

Database connectivity

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

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

SQL Server 2005, 2008, 2012, and 2014 client

Web browser

Microsoft Internet Explorer (Windows) Versions 9, 10 and 11
Mozilla Firefox 43.0 and higher
Google 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):

NOTE: Standalone configuration not recommended on same computer as the SQL Server® Stat Database

Windows Server® 2008, Windows Server 2012, Windows® 7, Windows8, Windows 10

NOTE: The Stat Central Agent can run on Windows 64-bit computers

Red Hat® Enterprise Linux® releases 5. 6 and 7

Oracle® Solaris 8, Solaris 9, Solaris 10

HP-UX 11.11 and 11.23 or 64-bit

NOTE: HP-UX 11.11, 11.23 requires HP JDK/SDK (32-bit)

IBM® AIX® v5.2, 5.3, 6.1, or 7.1 (all English-based)

NOTE: 64-bit AIX v5.2, 5.3, 6.1 and 7.1 requires IBM JDK/SDK.

JDK/SDK versions (32 or 64-bit) 7 or 8

Oracle Fusion Middleware 11g and 12c configuration

Server Stat Database

Minimum requirements

CPU: 2.5 GHz (Dual Core processor )  Core i3 (or equivalent)
RAM: 2 GB
Disk:  500 MB

E-mail

Supported protocols: Outbound email-SMTP, Secure SMTP; Inbound email-
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: v8.0-v8.22, and v8.4-v8.55.

PeopleSoft Applications

Supports all PeopleSoft Applications built on PeopleTools.

PeopleSoft Databases

Supports the following database platforms in conjunction with

PeopleTools Supported Platforms:

  • Oracle® (10g, 11g, and 12c)
  • SQL Server® (2005, 2008, 2012, and 2014)
  • IBM® DB2® UDB (7.1, 8.1, 9.1, 9.5, 9.7 on IBM® AIX®, OS/390, z/OS; 10 on z/OS)

Oracle E-Business Suite

Releases

Stat™ supports all products, including custom products, in the Oracle® EBusiness Suite Release 11i (11.5.10 and higher), 12, 12.1.1, 12.1.2, 12.1.3 (current release is 12.1.3), and 12.2 (current release is 12.2.5).

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, IBM, 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 (32-bit): 7 and 8

 
  • Windows, Solaris, and RedHat Linux require Oracle JDK/SDK (32-bit)
  • HPUX 11.11, 11.23, 11.31 requires HP JDK/SDK (32-bit)
  • 64-bit AIX v5.2, 5.3, 6.1, and 7.1 requires 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 Central Agent. The Stat Central Agent 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

Videos

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.