Installing the Product › Installation Modes › Installation Using the Console Mode › 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 one of the following:

• Select 1 to use an external database.

  Note: A database account and a pre-created database are required.

  =====================================================================
  Database Connection
  -------------------
    ->1- Use external database
      2- Use embedded database (Apache Derby Embedded Database)
  Do you want to use an external database: 1
  
    ->1- Derby
       2- DB2
       3- Oracle
       4- MS SQL Server
       5- Other - select a local JDBC driver
  Database type: 1
  Host name: db.company.com
  Port number: 1527
  Database name: AdminDB
  User name: admin
  Password:
  Encrypting password... Done.
    ->1- Yes, this account is granted with CREATE TABLE privileges.
      2- No, this is a restricted account without CREATE TABLE privileges.
  Does this account have CREATE TABLE privileges?:
  Maximum number of connections for Read (DEFAULT: 100):
  Maximum number of connections for Write (DEFAULT: 100):
  JDBC URL (DEFAULT:
  jdbc:derby://db.company.com:1527/AdminDB;create=true):
  Choose one of the following options to continue:
    ->1- Test database connection
      2- Accept the current database settings
      3- Go back to edit connection information
  Select an action:
  Testing database connection...
  Connection successful.
  Choose one of the following options to continue:
      1- Test database connection
    ->2- Accept the current database settings
      3- Go back to edit connection information
  Select an action:
  

  Specify the following information.

  Database type

  Lists a number of database types for which we provide their JDBC (Java Database Connectivity) driver. 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 computer.

  If the type of database is not on the list, select Other to select a JDBC JAR file on your local computer. After selecting a JAR file, you will be asked to select a class which serves as the JDBC driver.

  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 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 encrypted and stored.

  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 Prerequisites for more information.

  Maximum connections

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

  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.

  After all information is entered, select Test database connection to validate the connection. This provides a quick test on the database connection information.

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

• Select 2 if you want to use an embedded database.

  ========================================================================
  Database Connection
  -------------------
      1- Use external database
    ->2- Use embedded database (Apache Derby Embedded Database)
  Do you want to use an external database: 2
  

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