Chat now with support
Chat with Support

Stat 6.3 - System Administration Guide

Overview of Stat Administration Administrative Utilities Stat Security General Maintenance Tables
System Maintenance Service Domain Maintenance Department Maintenance Issue Tracking Maintenance Country Maintenance Customer Maintenance Object Type Maintenance PeopleSoft Environment Connection Maintenance Pre/Post Migration Steps Parameters Oracle Applications Configuration Oracle Applications Connection Maintenance Generic Application Connection Maintenance Schema Object Parameters Maintenance Data Object Maintenance PeopleSoft Search Configurations Stat Report Definition Maintenance Version Control Management Connection Maintenance
Service Domain-Specific Maintenance Configuring the Stat Central Agent Email Configuration Object Security Appendix: Sample Service Domain Configuration Appendix: User Class 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 Appendix: Troubleshooting Chart Appendix: stat.conf Configuration Appendix: Custom Report Files

Testing File Locations, Servers, and Default Directory Locations

You can test the connection between Stat and any file location, server, directory or change management environment by selecting the row and clicking Test Connection. This directs Stat to test its connectivity to the selected file location, file server, directory or environment. If successful, Stat displays a “Connection Successful” message box. If Stat is unable to connect, it displays a message box stating the cause of the failure, for example, “User ID or Password is not defined.” The connection between Stat and the file server is always established by the Stat Central Agent. For this reason, ensure that the Stat Central Agent is up and running before testing any connections.

PeopleSoft Environment Connection Maintenance

The PeopleSoft Environment Connections Maintenance table defines the PeopleSoft environments to which Stat can connect. These are the environments available for selection on CSRs and the various PeopleSoft wizards. Within the definition for each environment is the information Stat needs to connect to it.

PeopleSoft environment connection security is controlled by the following user class rights:

•
PeopleSoft Connection - Add
•
PeopleSoft Connection - Edit

The PeopleSoft Environment Connection Maintenance table is displayed in a standard maintenance window. To open this window, select Maintenance | General | PeopleSoft Connect.

Stat provides change management support for PeopleSoft running on a several different platforms, including Oracle, SQL Server, and DB2 (z/OS and AIX). Although most of the values that you specify in the PeopleSoft Environment Connection Maintenance table are the same regardless of which platform you are running on, some values are DBMS-specific. For this reason, the following sections describe each value in the maintenance table for each platform supported by Stat, along with any special considerations you should bear in mind when defining connections between Stat and your PeopleSoft environments.

Oracle

PeopleSoft Environment Connection Maintenance

The PeopleSoft Environment Connections Maintenance table defines the PeopleSoft environments to which Stat can connect. These are the environments available for selection on CSRs and the various PeopleSoft wizards. Within the definition for each environment is the information Stat needs to connect to it.

PeopleSoft environment connection security is controlled by the following user class rights:

•
PeopleSoft Connection - Add
•
PeopleSoft Connection - Edit

The PeopleSoft Environment Connection Maintenance table is displayed in a standard maintenance window. To open this window, select Maintenance | General | PeopleSoft Connect.

Stat provides change management support for PeopleSoft running on a several different platforms, including Oracle, SQL Server, and DB2 (z/OS and AIX). Although most of the values that you specify in the PeopleSoft Environment Connection Maintenance table are the same regardless of which platform you are running on, some values are DBMS-specific. For this reason, the following sections describe each value in the maintenance table for each platform supported by Stat, along with any special considerations you should bear in mind when defining connections between Stat and your PeopleSoft environments.

Oracle

 
Value
Description

Active

If selected, indicates that this environment definition is active in Stat

Environment Cd
(Key Value)

A 1-10 character code which uniquely identifies the environment

Staging DB

Indicates if the environment is used as a staging database

PS Version
(Required Value)

The tools release of the environment

Data Obj Version

The version number of the PeopleSoft application, as defined in the Data Objects Maintenance table. Select a value in this field only if you plan on using Stat to manage data objects within this environment.

Description
(Required Value)

A 1-35 character description of the environment

Physical
Locking

Specifies whether or not physical locking is used for PeopleSoft proprietary objects in this environment

Req. Migr. Approval

If selected, indicates that archive sets cannot be migrated into the environment without migration approval

DBMS
(Required Value)

Oracle

Syntax Override

N/A

ODBC DSN

N/A

Database Name

The name of the environment (TNS Alias).

Used by the Stat Client for auto-migration to the staging database and to the target.

DB User ID

N/A

DB Password

N/A

Database Server

The name of the environment (TNS Alias).

The same as the Database Name above. Neither should be preceded by a “@” sign.

Srv Login ID

The Oracle user ID for the PeopleSoft schema owner. The PeopleSoft default is “sysadm.”

Server Pwd

The Oracle password for the Srv Logon ID

Host Name

Name of the machine hosting the database.

Required value for the Stat Central Agent connection. However, N/A if the Use Tns option is selected.

Service Name

The listener service of the database. Used by the Stat Central Agent and the Stat Oracle Agent to establish JDBC connections to the Oracle database.

Required value for the Stat Central Agent connection. However, N/A if the Use Tns option is selected.

DB Listener Port

Port number for the database listener (Oracle default value is 1521).

Required value for the Stat Central Agent connection. However, N/A if the Use Tns option is selected.

Use Tns

For RAC Oracle databases, configures Stat to invoke TNS

Tns Entry

The full description as it appears in the tnsnames.ora file with no line breaks or carriage returns

Other Database Parameters

Additional DBMS-specific parameters, if needed

Connect ID

PeopleTools Connect ID. Can be used when target environment has different from Staging environment Connect ID.

Note: For PeopleTools 8.54 or higher

Connect ID Password

PeopleTools Connect ID password. Can be used when target environment has different from Staging environment Connect ID password.

Note: For PeopleTools 8.54 or higher

PS Config File

The path and name of the PeopleSoft configuration file, if any, that Stat imports when executing CLI functionality for this environment. You can either enter the location manually, or you can click the folder icon and select the location in the Browse for Folder dialog box.

CAUTION: Specifying an incorrect value in this field can result in the deletion of a user’s configuration data during a migration in which CLI functionality is invoked.

Base Language

For PeopleSoft 8.54 or higher, the base language of the environment. The default is ENG.

CAUTION: When migrating archive sets, the base language of the staging database must be the same as the base language of the environment that the archive set came from (i.e., the source).

Stat PS OprId
(Required Value)

Required for PeopleSoft Object Locking in Stat. 30 characters in length maximum. Default is STAT.

Last Update
(Read Only)

The date and time this record was last updated

Update By
(Read Only)

The user who last updated this record

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating