9 Database and File Management

This chapter describes the how to upload and download files to and from the server, how to manage the Oracle Load Testing for Web Applications database, and how to select the database to use.

Database Management

The Oracle Load Testing for Web Applications database is used to store the results of your load test sessions. You use the Oracle Test Manager for Web Applications Database Configuration to configure databases for use in Oracle Load Testing for Web Applications. The Databases option on the Manage menu in Oracle Load Testing for web Applications is used to set the current database to use. The Database Manager dialog box

Name - displays the ODBC System Data Source name of the database.

Description - displays a description of the database.

Type - displays the type of database.

Connection String - displays the connection string.

Adding an Oracle Database

To add an Oracle database:

Select Programs from the Start menu then select Oracle Test Manager for Web Applications Database Configuration from the Oracle Application Testing Suite menu.
Select Oracle Load Testing.
Click New.
Select Use existing schema or Create new schema & tables.

This dialog box has the following options:

System user credentials - specify the login authentication credentials if you select to create a new schema and tables, as follows:
- User name - enter the login user name for the database system.
- Password - enter the login password for the database system.
Connection details - enter the Oracle database connection information.
- Name - enter the name of the database This name appears in the Databas selection lists for Oracle Test Manager for Web Applications and as the ODBC Data Source name.
- Description - enter any description text to identify the database.
- Host - enter the host name of the machine on which the database server is running.
- Port - enter the port number that you want to communicate with. If you are running multiple instances of SQL Server on the same host, specify the port number you want to communicate with.
- SID - enter the System Identifier for the Oracle database.
- User name - enter the login user name for the database.
- Password - enter the login password for the database.
Enter the database information.
Click Save.
If creating a new schema, enter the password for both the Administrator and default accounts and click OK.
Click Close.
Either restart the computer or restart the Oracle Application Testing Suite Application service by going to the Control Panel Administrative Tools and open Services and restart the Oracle Application Testing Suite Application Service.

Selecting the Database to Use

Select Programs from the Start menu then select Oracle Test Manager for Web Applications Database Configuration from the Oracle Application Testing Suite menu.
Select Oracle Load Testing as the product type.
Select the database you want to use to store Oracle Load Testing for Web Applications data.
Click Set as current.
Click Close.
Restart Oracle Load Tesitng for web Applications.

Removing Databases

You can remove databases from Oracle Test Manager for Web Applications. Doing so does not delete the database files. It removes the database from the database selection lists so that the database is no longer available in Oracle Test Manager for Web Applications. The database cannot be deleted if it is open in Oracle Test Manager for Web Applications.

To remove a database from Oracle Test Manager for Web Applications:

Select Programs from the Start menu then select Oracle Test Manager for Web Applications Database Configuration from the Oracle Application Testing Suite menu.
Select the database that you want to remove.
Click Remove.
Click Yes to confirm the deletion.

Updating Databases

You can change the name, location, and login information for databases that you are using in Oracle Test Manager for Web Applications.

Select Programs from the Start menu then select Oracle Test Manager for Web Applications Database Configuration from the Oracle Application Testing Suite menu.
Select the database that you want to update.
Click Update.
Make any changes.
Click OK.

Uploading Files

You can upload files from the local machine to the Oracle Load Testing for Web Applications server. This can be useful if you are accessing Oracle Load Testing for Web Applications on a remote machine via the Web UI and want to upload scripts from your local Oracle Functional Testing for Web Applications.

Select Upload File from the Tools menu.

File Type - select the type of file.
- Type - lists the types of files that can be uploaded.
File to Upload - the options listed here depend on the type of file being uploaded.
- <extension> - enter the file you want to upload.
- Browse - opens the Choose File dialog box for browsing and selecting a file.
Destination - the options displayed here depend on the type of file you are uploading and only apply to certain file types.
- Repository - select the repository where you want to upload the file.
- Workspace - select the workspace where you want to upload the file.
Select the type of file that you want to upload.

Note:
If you are uploading a ServerStats Metric Profile, the metrics associated with the profile must be uploaded separately.
Enter the file name or click Browse to locate the file.
Select the destination location to which you want to copy the file.
Click OK.
Click OK.

Downloading Files

You can download files from the server to the local machine. This is useful if you want to access a script from the Oracle Load Testing for Web Applications Server and edit it on your local machine.

Select Download File from the Tools menu.

File Type - select the type of file you want to download from the Oracle Load Testing for Web Applications server to the local machine.

Repository - a list of repositories from which you can download files.

Workspace - lists the workspaces available in the selected repository.

<file list> - lists the files of the selected type in the selected workspace that are available to download.
Select the type of file that you want to download.
Select the Repository and Workspace in which the file is located if applicable to the type of file you are downloading.
Select the file you want to download. If you are downloading scripts, the Download Multiple Files dialog box is displayed.

This dialog box lists script parts available for downloading for the selected script. Select the part you want to download and click Close.
Select the script part that you want to download. Script parts must be downloaded separately.
The File Download dialog box is displayed.
Click Save to open the Save As dialog box.
Select the location where you want to save the file and click Save.
Click Close in the Download Complete dialog box.
If you are downloading scripts, select another script part to download or click Close to exit the Download Multiple Files dialog box.
Select another file to download or click Close to exit the Download File dialog box.