Defining Databases

When performing a PeopleTools upgrade, initially you will connect to your target database using your current PS Home. Once the target database is updated to the new release, the rest of the steps will require you to connect using the New PS Home.

Select this checkbox if you need to edit the database after the database has been upgraded to the new PeopleTools release.

Enter the location of new PS_HOME.

Enter the location of your new PS_APP_HOME.

Enter the location of your new PS_CUST_HOME.

The SQRBIN value is read only and derived from the PS Home and platform setting.

By default , the -ZIF parameter is to set the full path and name of the SQR initialization file, SQR.INI. Make any necessary changes or add additional SQL parameters if needed.

This field is read-only and will contain the path that is used in Change Assistant:

1. StagingDirectory\SQR

2. PS_CUST_HOME\SQR

3. PS_APP_HOME\SQR

4. PS_HOME\SQR

Each path is separated by a “;” (semi-colon).

The static display is: “<StagingDir>\SQR;<Cust_Home>\SQR;<App_Home>\SQR;PS_Home>\.

Enter the host name or the IP address of the application server where the appropriate Process Scheduler server domain is running (PSPRCSRV.EXE and so on).

Enter the domain's JSL port (listener port).

Enter the domain connection password for the application server.

Enter the name of the Process Scheduler server definition, such as PSUNIX.

You can download and view the Process Scheduler logs from within Change Assistant so that you don't need to monitor the processes separately using Process Scheduler monitoring and logging. Similar to other Change Assistant log files, the downloaded Process Scheduler log files are saved to the Change Assistant output directory.

• None: Disables the ability to view Process Scheduler log information from within Change Assistant.

• FTP: Select if Process Scheduler is running on a UNIX server.

• File Copy: Select if Process Scheduler is running on a Windows server.

(Applies only to FTP option). Enter the machine name or IP address of the FTP server where the Process Scheduler logs are located.

(Applies to File Copy and FTP option). Enter the path to where the Process Scheduler logs are located on the server.

• For the FTP option, enter the absolute path on the FTP server.

• For the File Copy option, this is the (mapped) path on the Change Assistant workstation.

(Applies only to FTP option). Enter the user ID and password required for connecting to the UNIX server (as if an FTP client were connecting).

Enter the server name and port for the environment. Contact your Integration Broker administrator or system administrator for the correct values.

The format for the Server:Port field is:

<machine_name>:<https_port>

For example:

rtdc79614.us.oracle.com:443

If the https port is the default 443 the port is optional.

You can also enter a complete https URL in this format:

https://<machine_name>:<https_port>/PSIGW/HttpListeningConnector

For example:

https://rtdc79614vmc.dsi-inet.peoplesoft.com:443/PSIGW/HttpListeningConnector

This field is required if more than one database is connected to the server. Enter the name of the PeopleSoft node with which the integration gateway is to communicate.

Contact your Integration Broker administrator or system administrator for the correct values.

Specify the name of the Execution Options configuration to use.

Specify the path to the PTF client executable.

The default location is C:\Program Files\PeopleSoft\PeopleSoft Test Framework.

Select this option to enter details for the proxy server. When you select this option, the proxy information fields are enabled.

Enter the following information for the proxy server:

• Server: Enter the server name.

• Port: Enter the server port.

• User: Enter the user ID for the proxy server.

  If you use network authentication, use the DOMAIN\USER format.

• Password: Enter the password.