Transcript STAT Control, Visualize and Automate Change

Stat – Simplify Change
Management and Version
Control with Stat 5.7.0
Fernando Volonte
Product Manager
1
Confidential
Global Marketing
What is Stat – Change Management?
• Complete change lifecycle solution
• Specially designed for PeopleSoft & EBS
• Integration validated by Oracle
Auditing &
Reporting
Change
Request
Management
• Market leader with over 650 customers
• Stat for PeopleSoft in market since 1997
• Stat for Oracle E-Business in market since
2004
• Online user community to share knowledge
2
Confidential
Release &
Migration
Management
Patch
Management
Workflow
Version
Control
Global Marketing
 Manage and track all changes
 Enforce controls and separation of duties
for compliance
Why
customers
choose Stat?
 Version control and change management
around code and config changes
 Reduce effort, and human error, in
moving code to multiple environments
 Automate project/code deployments and
recovery capabilities
 Support tracking of db refreshes and
recovering lost objects
 Impact Analysis to show how changes
will affect downstream objects
 Support Patching in a controlled manner
 Meet Audit and Report requirements
3
Confidential
Global Marketing
How Stat helps through SDLC
4
Issue
Tracking
Workflow
and
Security
Version
Control and
Comparisons
Show the who,
what, when, and
where
Integration with
existing Helpdesk
ticketing systems
Enforce change in
a consistent way
and add security
Separation of
duties
Automated
approvals
Control when
and who can
affect
environments
Natively version
and package code
and configurations
Automated initial
backup
Side-by-side
comparisons
Confidential
Automated
Migrations
and
Recovery
Automate
migrations and
reduce manual
steps
Utilize delivered
functionality
Automate code
recovery
Keep
environments in
sync
Impact
Analysis
and
Patching
Auditing
and
Reporting
Identify what will
be impacted
before its
changed
Reduction in time
when compiling
auditing
requirement
Full audit trail
Schedule and
deliver reports
Support the
patching process
Track patches
Global Marketing
Stat 5.7.x Architecture
E-Business Suite Environment
Stat for
OEBS Agent
Central Agent
App/Web Server
Oracle
E-Business Suite
Dev
Test
Prod
Web Browser
Stat
Dev
Custom
Apps
Windows
Client
Test
Single Repository
Prod
5
Confidential
Global Marketing
Stat 5.7.x Architecture
PeopleSoft Environment
PeopleSoft
Stat Central Agent
App/Web Server
Dev
Test
Staging DB
Prod
Web Browser
Stat
Dev
Custom
Apps
Single Repository
Test
Windows Client
Prod
6
Confidential
Global Marketing
Disclaimer Statement
This document lists the improvements and changes that are currently
planned for the future releases of Stat.
As always with forward-looking documents, this is not a commitment
to deliver the functionality as changing business factors may cause
us to re-evaluate our plans for this release in terms of scope and
timing. This document cannot be used in any contracts or as a
condition of purchase.
8
Confidential
Global Marketing
Stat Roadmap
1H2012
Q12013 Q22013 Q12014 Q22014 Q32014 Q12016
5.6.2
5.6.3
• Add Perforce to
supported 3rd party
version control systems*
• Improved performance
and functionality of web
interface*
5.6.4
• PeopleTools
8.53 support*
• Ability to change
STATLOGIN password
• Add Show Errors to SQLPlus
logic and parse return log for
errors
• Move schema objects to
Oracle Agent if module is
Oracle Apps
• Upgrade to Java 1.6
• Various other fixes
9
5.7
5.7.x
5.7.x
6.0.x
• Componentize Stat
• Deployments
• Approvals (mobile)
• Redesigned user
interface
• PeopleTools • Expanded custom apps
support (Java, .NET)
8.54 support*
• Custom reporting option
• Oracle Fusion Apps
support
• Oracle eBusiness r12.2
support*
• Miscellaneous
fixes
• Complete rewrite of
migrations – new
Migrations console,
scheduling migrations
• Clone users or copy en
masse
• Enhanced auditing of
security tables*
• Enhanced reporting
• Support for user security
best practices*
• Extensive Workflow
improvements
• Update migration paths
Confidential
Global Marketing
Dell SOFTWARE CONFIDENTIAL
What’s New in Stat 5.7.0
14
Confidential
Global Marketing
Ability to Clone a User
Copy and/or Sync
New Users
15
Confidential
Global Marketing
Copy/Sync Options
Users can be created an masse
and then synced with an
existing user
Copy individual users
16
Confidential
Global Marketing
Enhance User Maintenance Functions
Multi-select of objects for easier
administration of object access
Tree structure for object
type access selection
17
Confidential
Global Marketing
User password change through Web Client
User passwords can be reset
via the web client
18
Confidential
Global Marketing
Restrict Archive Set Source Location and
Resolution Requirement based on workflow
Select from which environments
status
one can archive within a Workflow
Status
Select which
Status requires a
resolution
19
Confidential
Global Marketing
Source DB Name Parameter – honorable
mention
Source DB Name
20
Confidential
Global Marketing
Allow for multiple LDAP domains
Configure as many
domains as you
require
21
Confidential
Global Marketing
5.7.0 – Security Table Audits
22
Confidential
Global Marketing
Updates to reports
Description
Migration Complete History
Long Description
Report of compete migration history. Includes approvals, pre/post migration steps,
objects, and distributed environments, sorted by migration ID.
Category
Layout
Migrations
MaintenanceSecurity Settings
Compliance
Migrations
List
User Rights Assignment by Service Domain Rights assignment by service domain for the selected user.
STAT Audit Table
Stat Audit Table updated by triggers when certain STAT tables are modified.
Post Migration Checklist
List of Post Migration Checklists by CSR, Migration Date, and Step Order.
List of Post Migration Steps run for each migration. Listed by CSR, Migration Number,
Post Migration Step History
Archive ID and Object Type.
Migrations
Pre Migration Checklist
List of Pre Migration Checklists by CSR, Migration Date, and Step Order.
Migrations
Crosstab
Excel
Excel
570-csr by priority with descriptions
CSRs by priority with descriptions
Standard
Objects Unlocked on Open CSRs
Excel
Pre Migration Step History
List of unlocked objects on open CSRs.
Objects
List of Pre Migration Steps run for each migration. Listed by CSR, Migration Number,
Archive ID and Object Type.
Migrations
Deleted Objects by Object Type
List of deleted objects sorted by Object Type, then by Environment.
Migrations
Excel
Deleted Objects by Environment
List of deleted objects sorted by Environment, then by Object Type.
Migrations
Excel
Deleted Objects by Env - State Based
Migrations
Excel
Migrations
Excel
Migrations
Migrations
Excel
Excel
Migrations
Excel
Migrations
Migrations
Excel
Excel
Migration History by Date w Obj
List of deleted objects sorted by Environment, then by Object Type. State Based.
List of Archive Set migrations to Distributed Environments, sorted by Target
Environment, then by Migration Date. Contains the objects migrated.
List of Archive Set migrations to Distributed Environments, sorted by Migration Date,
then by Target Environment. Contains the objects migrated.
List of Archive Set migrations sorted by Target Environment, then by Migration Date.
List of Archive Set migrations sorted by Target Environment, then by Migration Date.
Contains the objects migrated.
List of state based PeopleSoft Archive Set migrations sorted by Target Environment,
then by Migration Date. Contains the objects migrated.
List of Archive Set migrations sorted by Migration Date, then by Target Environment.
List of Archive Set migrations sorted by Migration Date, then by Target Environment.
Contains the objects migrated.
Migrations
Excel
Release Mgmt - Migrations By Release
List of Archive Set migrations sorted by Release name.
Migrations
Excel
Distributed Migr History by Env w Obj
Distributed Migr History by Date w Obj
Migration History by Env
Migration History by Env w Obj
Migration Hist with Objects-State Based
Migration History by Date
23
Confidential
CSR Reports
Global Marketing
Excel
Excel
Excel
CSR Approvals Override Report
24
Confidential
Global Marketing
Migration Console
New Migration Console
26
Confidential
Global Marketing
Migration Console cont.
Refresh
Filter
Check staging
Print
Export to excel, csv, check formats
Show Migrations
27
Confidential
Global Marketing
Migration History and Logs
Migration Approvals tab in Migration History
Migration History and related object listing
28
Confidential
Log Tab
Global Marketing
Migration Logs cont.
Double-click a row to view additional
log information
29
Confidential
Global Marketing
Additional Migration Functions
View/Execute Pre/Post
Migration Steps
30
Confidential
View Project Audit
Flags
Global Marketing
Migration Approvals
Migration Approvals
Overrides are
displayed and report
can be exported
31
Confidential
Global Marketing
Migration Approvals continued
Migration Approvals
Standard approvals
32
Confidential
Global Marketing
Enhanced Migration Wizard
Ability to size window
and panes therein
Schedule Migrations
Option to Stop
Migrations on error
or continue
Select object
class to migrate Proprietary, file,
schema or Data
objects
33
Confidential
Select which objects to migrate
in an archive set. All or just
rollback a few!
Set your PeopleSoft Audit
Flags for Stat Projects
from here!
Global Marketing
Set Audit Flags
34
Confidential
Set your PeopleSoft Audit
Flags for Stat Projects
from here!
Global Marketing
Add Copy Archive Sets functions
Copy archive sets
Comment
automatically added.
35
Confidential
Copy from the
environment of your
choosing.
Global Marketing
Workflows
AND/OR
Qualifiers
Pick and
choose to
whom
approvals
should be sent
Indicates Workflow
status will dynamically
transfer when approvals
have been met
36
Confidential
Global Marketing
Migration Paths
Select from which
environment to
replicate Object
Listing data
Add new environments to
existing migration paths
37
Confidential
Select CSRs to be
updated
Global Marketing
Thank you!
Fernando Volonte – [email protected]
Product Manager
39
Confidential
Global Marketing