Installing the Product › Installation Modes › Installation Using the GUI Wizard › Step 6. Connect to a Database

Step 6. Connect to a Database

CA OM Web Viewer uses a database system for data persistence and caching administrative data. You can use an external database or let CA OM Web Viewer create an embedded database (Apache Derby embedded database). For best performance, we recommend that you use an external database server.

Do the following if you choose to use an embedded database:

1. Select Use embedded database.

   CA OM Web Viewer will create an Apache Derby embedded database upon the first time it is launched.

2. Click Next and proceed to Step 7.

If you choose to use an external database, select Use external database and do the following:

Be aware that a database account and a pre-created database are required.

1. Select a database type from the Database type drop-down list.

   The drop-down menu lists a number of database types; we provide their JDBC drivers.

   

   For DB2 database, you will be prompted to select an IBM DB2 license file. In this case, select your license file (for example, db2jcc_license_cisuz.jar) from your local system.

2. If the type of database you want is not on the list, do the following:
   1. Select Other - Select a local JDBC driver.

      A dialog opens.

   

   1. Select a JAR (Java Archive) file that contains an appropriate JDBC driver.

      A pop-up dialog that lists all available JDBC driver classes in this JAR file is displayed.

   

   1. Select a class which serves as the JDBC driver and click OK.
3. Supply all the database connection parameters.

   Host name

   Defines the name or IP address of the database server.

   Port number

   Defines the port number on which the database is running.

   Database name

   Defines the name of the database that is to be used by CA OM Web Viewer.

   User name

   Defines the name of the database user.

   Password

   Defines the password of the database user; this information is stored in an encrypted form.

   With CREATE TABLE privileges

   • If the database account specified in the User name field has CREATE TABLE privileges, only an empty database is required. Select this check box, and CA OM Web Viewer will create all necessary tables the first time it is started.
   • If this account does not have CREATE TABLE privileges, clear this check box and ask your database administrator (DBA) to create tables according to the Data Description Language (DDL) statements provided with CA OM Web Viewer.

   See Database Requirements for more information.

   Maximum connections

   Defines the maximum number of database concurrent connections allowed in the system.

   JDBC URL

   Provides a valid URL that is required to establish database connections. The initial value is provided according to the input to the other fields. Make necessary changes to this string, if required.

4. Click the Test button to verify the connection.

   A Connection Successful message tells you that your entries were valid, otherwise, modify the parameters and try it again.

   Note: The test function is unable to verify whether this database account has CREATE TABLE privileges.