Stat 6.0 - System Administration Guide

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 and for file locations, servers and directories, prompts you to test a FTP file transfer. 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.”

In the case of file locations, servers and directories, you can test a FTP file transfer if Stat was successful in testing the connection. Clicking Yes at the prompt launches the Stat FTP Test tool.

The tool displays files in your local drive and files residing on the remote location. To test a file transfer, select a file and use the arrow buttons to move a copy of the file between both locations. Any errors are reported in the bottom half of the window.

For Sftp servers, you can also test SSH connectivity, which can be useful when troubleshooting SSH issues with custom commands in post migration steps. The SSH field displays an example of command to test a Unix server. To test SSH connectivity, enter a SSH command in the field and click SSH Run.

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:

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 UDB (both OS/390 and AIX/Unix). 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 10g, 11i, and 12c

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:

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 UDB (both OS/390 and AIX/Unix). 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 10g, 11i, and 12c