9 Configuring Databases

This chapter explains how to add and remove databases from Oracle Test Manager for Web Applications, and how to update name, location, and login information for databases that you are using in Oracle Test Manager for Web Applications.

Adding Databases

You can add an existing Oracle Database 11g Enterprise Edition, 10g Enterprise Edition, 10g Express Edition database to Oracle Test Manager for Web Applications or you can create a new schema. In addition, you can create tables in an empty database. When you add a database, Oracle Test Manager for Web Applications creates a user account for the default user and the administrator. Use Oracle Test Manager for Web Applications Administrator to add more users and to customize projects.

Note:

If you are re-installing Oracle Test Manager for Web Applications and intend to use the same database after reinstallation, you must remove the database name from the System DSN registry before configuring the database for use in Oracle Test Manager for Web Applications. Do this in the ODBC Data Source Administrator by selecting Control Panel from the Start menu and open Data Sources (ODBC) in the Administrative Tools. Select the database name on the System DSN tab and click Remove.

Adding a Database

To add an Oracle database:

1. Select Programs from the Start menu then select Oracle Test Manager for Web Applications Database Configuration from the Oracle Application Testing Suite menu.

2. Select Oracle Test Manager.

3. Click New.

4. Select Use existing schema or Create new schema & tables.

   This dialog box has the following options:

   Use existing schema - when selected, a database is added using an existing Oracle Test Manager schema.

   Create new schema & tables - when selected, a database is added using an new Oracle Test Manager schema and tables.

   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 database 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 Oracle Database on the same host, specify the port number you want to communicate with.

   • Service - enter the Service name for the Oracle database.

   • User name - enter the login user name for the database.

   • Password - enter the login password for the database.

   Options - select options, as follows:

   • Install samples - when selected, the sample data is installed into the new database. For Oracle Test Manager for Web Applications, the sample data is the Sample Project used for the tutorial. For Oracle Load Testing for Web Applications, the sample data is the two load sessions that can be used to generate sample reports.

5. If creating a new schema, enter the System user credentials.

6. Enter the database connection information.

7. Click Save.

8. Click Close.

9. 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.

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:

1. Select Programs from the Start menu then select Oracle Test Manager for Web Applications Database Configuration from the Oracle Application Testing Suite menu.

2. Select the database that you want to remove.

3. Click Remove.

4. 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.

1. Select Programs from the Start menu then select Oracle Test Manager for Web Applications Database Configuration from the Oracle Application Testing Suite menu.

2. Select the database that you want to update.

3. Click Update.

4. Make any changes.

5. Click OK.