Overview of Stat Administration
Stat Architecture and Components
Administrative Utilities
Windows Client / Web Browser
Stat Central Agent / App Web Server
Database Tier
Application Environments
Stat Administrator Responsibilities
Manage Stat Maintenance Tables
Administer Security
Manage the Stat Central Agent
Provide End-User Support
Perform Application Upgrades
Perform Database Maintenance
The Stat SYSTEM User Account
Standard Maintenance Windows
Buttons and Controls
The Record List
Field Types
Adding and Deleting Records
Using the Color Selection Dialog Box
Importing and Exporting Maintenance Tables
Stat INI Editor
Stat Security
The Database Tab
Encryption Key Update
Data Replicator
Table Dump Utility
PeopleSoft Object Mover Instruction Update Utility
Configuration Guide for New Installations
General Setting Information
Changing the STATLOGIN Password
Testing Connections
Editing Records
Deleting Records
Duplicating Records
Copying Record Values
Order of Appearance
Printing the Stat INI file
The Options Tab
Stat Security Layers
Defining User Classes
Editing User Class Rights
Defining Stat Users
General Maintenance Tables
Copying User Definitions
Resetting Passwords
The User Access Information Window
LDAP Connection Maintenance
Connection Manager
Service Domain Access Tab
PS Options Tab (PeopleSoft only)
User File Directories Tab
Queue Assignment Tab
Application Access Tab
Object Type Access Tab
Environment Access Tab
Pre/Post Migration User Parameters Tab
Synchronizing User Access Information
User Password Security Settings
System Maintenance
Service Domain-Specific Maintenance
General Tab
License Tab
Users Tab
Other Options Tab
Parameters Tab
DB Scripts Tab
CSR History Tab
Approvals Tab
Service Domain Maintenance
Department Maintenance
Issue Tracking Maintenance
Country Maintenance
Customer Maintenance
Object Type Maintenance
File Types
PeopleSoft Environment Connection Maintenance
File Types for Oracle Applications
Source File Locations
File Type User Directories
VCM Locations
File Templates
Setup Object Types for Oracle Applications
File Servers
File Path Syntax
Case Sensitivity and File Name Conversion
Server-Specific Pre/Post Migration Step Parameters
SFTP Public Key-Based Authentication
User Default Directories
Oracle Apps Base Directories
Testing File Locations, Servers, and Default Directory Locations
Oracle
Testing Environment Connections
Inactivating PeopleSoft Environments
Managing File Locations by Environment
PeopleSoft Options
Pre/Post Migration Steps Parameters
Oracle Applications Configuration
Oracle Applications Connection Maintenance
Setting Up User Connections
Setting Up Physical Object Lock Exclusions
Setting Up Migration Approval Lists
Copying PeopleSoft Environments
Testing Environment Connections
Defining Oracle Applications Servers
Start/Stop Oracle Applications Agents
Inactivating Oracle Applications Environments
Setting Up Migration and Patch Approval Lists
Updating Products per Environment
Copying Oracle Applications Environments
Generic Application Connection Maintenance
Testing Environment Connections
Inactivating Generic Application Environments
Managing Source File Locations by Environment
Setting Up Migration Approval Lists
Copying Generic Application Environments
Schema Object Parameters Maintenance
Data Object Maintenance
PeopleSoft Search Configurations
Creating Tables and Views
Stat Report Definition Maintenance
Version Control Management Connection Maintenance
Employee View Example (Pre PeopleTools Version 8.48)
Employee View Example (PeopleTools Version 8.48 and Higher)
Country View Example
Department View Example
Exclusions
Working With Service Domains
Activity Code Maintenance
Application Maintenance
Application Environment Maintenance
Auto Task Maintenance
Business Rule Maintenance
Configuring the Stat Central Agent
Defining Business Rules
CSR Log Topics Maintenance
CSR Priority Maintenance
CSR Type and Status Maintenance
Customer Priority Maintenance
Generic Application Migration Path Maintenance
Selecting a Trigger Event
Defining Rule Criteria
Defining Message Content
Defining a Distribution List
Defining a Command to Run
Resetting a Rule
Saving Rules
Disabling Rules
Copying Rules
Viewing Rule History
Migration Path Diagram
Defining Distribution Environments
Updating CSR Migration Paths with Additional Environments
PeopleSoft Migration Path Maintenance
Migration Path Diagram
Defining Distribution Environments
Updating CSR Migration Paths with Additional Environments
Oracle Application Migration Path Maintenance
Migration Path Diagram
Defining Distribution Environments
Updating CSR Migration Paths with Additional Environments
Pre and Post Migration Steps
Release Management Maintenance
Template Maintenance
Queue Maintenance
Workflow Maintenance
Starting and Stopping the Stat Central Agent
Defining Agent Jobs
Email Configuration
Error Notification
Job Maintenance
Job Classes
Stat Central Agent Printers
Monitoring the Stat Central Agent
Check for Past Due Items
Email Reports and Print Reports
Log Off and Wait
PS Object Lock Sync
Purge Agent Event Tables
Purge Audit Tables
Purge Deleted Archive Sets
Purge Error Log Tables
Purge Migration Event Tables
Stat Central Agent Purge System-Generated Logs
Run Operating System Command
Unlock Locked CSRs
The Schedule Tab
The Error Notification Tab
Accessing the Job Monitor
Schedule Tab
Jobs Tab
Logs Tab
Filtering and Sorting
Showing Job and Log Details
Customizing the What's New Tab in Stat Web
Customizing Field Labels for the Stat Web Client
Configuring the Stat Central Agent for Email
Outbound Mail Configuration
Inbound Mail Configuration
Object Security
Default Values Tab
Special Processing Tab
Skip Processing
Undeliverable Processing
Info Request Processing
Adding a Parameter
Order of Processing
Removing or Editing a Parameter
Advanced Customer Identification and Tracking # Tabs
Regular Expressions
Regular Expression Examples
Adding a Regular Expression
Order of Processing
Removing or Editing a Regular Expression
Field-Specific Tabs
Reply Tabs
PeopleSoft Proprietary Object Security
PeopleSoft Object Security Setup Instructions
Frequently Asked Questions
File Object Security
Appendix: Sample Service Domain Configuration
Appendix: User Class Rights
Notes on User Class Rights
CSR Edit Rights
CSR Tabs Rights
CSR Tasks Rights
Generic Application Migration Management Rights
Generic Application Object Management Rights
Maintenance - File Object Rights
Maintenance - General Rights
Maintenance - Service Domain Rights
Oracle Apps Migration Rights
Oracle Apps Object Management Rights
Oracle Apps Patch Management Rights
PeopleSoft Migration Management Rights
PeopleSoft Object Management Rights
Project Rights
Security Rights
Stat Central Agent Rights
Tool Rights
Wizard Rights
Appendix: Creating a Staging Database
Appendix: Database Tuning
Appendix: Oracle Applications File Type Directory
Appendix: Ports and Firewalls
Appendix: REST Web Services API
Appendix: SOAP-Based Web Services API
Services and Exposed Methods
Appendix: Troubleshooting Chart
Login Service
Class Definitions
long connect( String userId, String password ) throws WSLoginFault;
void disconnect( long connectId );
CSR Service
Approval Service
Stat Database
Stat Central Agent
Stat Oracle Agent
Login/Connection
Administrative Utilities
CSRs
Stat Web
Archiving and Migrating
Printing
Miscellaneous
Appendix: stat.conf Configuration
Appendix: Custom Report Files
Administrative Utilities
Stat INI Editor
The Stat.ini file contains the information Stat needs to connect to Stat databases. It is located in the Stat version-specific documents folder: C:\ProgramData\Quest Software\Stat\.
|
IMPORTANT: If the user does not have access to the folder listed above, the stat.ini file is installed in the Stat version-specific documents folder in the following location: C:\Users\<user>\AppData\Local\VirtualStore\ ProgramData\Quest Software\Stat\. |
The following is a sample Stat.ini file:
To open the Stat INI Editor, select Tools | Launch INI Editor, or select Ini Editor from the Windows Start menu. The Editor opens with the default Stat.ini file displayed.
To open a different Stat.ini file, select File | Open, or click the Open toolbar button in the Stat INI Editor toolbar. Then select the file you want. Each INI file opens in a separate record window.
The record window is comprised of two tabs: Database and Options.
The Database Tab
The Database tab lists the database(s) that Stat can connect to. From here you can edit an existing INI file entry or create a new one. The figure below shows how the INI information appears in the INI Editor. The information is taken directly from the sample INI file on the previous page. The INI Editor helps edit a file by asking for the exact information it needs. For example, if the DSN field is not required for a particular database, that field is grayed out.
|
1 |
Select File | New. |
|
2 |
Select Edit | New Record. |
|
4 |
In the DBMS field, select a DBMS. |
|
5 |
Enter the STATLOGIN password in the Encrypted Login Password field, either by entering an encrypted password from another stat.ini file or by clicking Change Password and entering the STATLOGIN password. |
|
7 |
Select File | Save as. Then specify a name for the INI file. |
|
8 |
Click Save. |
General Setting Information
The following table contains general database connection settings for the Stat INI Editor. Each record in the Stat INI Editor represents a database in the INI file. For more general information on available DBMS settings, see any of the Environment Connection Maintenance sections in Chapter 4, General Maintenance Tables .
|
Database interface identifier. This identifier is DBMS and DBMS release specific. | |
|
The encrypted password of STATLOGIN. This value can be changed, as described below. | |