WebFOCUS Repository Post-Installation Tasks

Topics:

How to:

This section explains how to create the WebFOCUS Repository and verify the WebFOCUS Client configuration.

For NLS configuration information, review this section and consult the WebFOCUS Security and Administration manual.

WebFOCUS Repository Table Creation

As of WebFOCUS 8.2, a unified repository model (referred to as the WebFOCUS repository) has been implemented to provide streamlined data access for all your reporting, scheduling, security, and administrative requirements. Tables that are created for ReportCaster and accessed by the Distribution Server are now part of the WebFOCUS repository. The WebFOCUS Business Intelligence (BI) Portal, which enables end users to access WebFOCUS reports through a user-friendly web interface, stores and retrieves reporting content from the WebFOCUS repository.

The WebFOCUS repository can reside on the same system as the WebFOCUS Client or on a different system, and can be stored in any JDBC-compliant database for which a driver exists.

Since the WebFOCUS repository has been restructured as of WebFOCUS 8.2 and is different from previous WebFOCUS releases, you must create a new repository when migrating from earlier WebFOCUS 7.7.x versions. For more information on migrating existing ReportCaster data, see the Migration manual.

Procedure: How to Create the Repository Tables

To create the Repository tables:

  1. Navigate to the following directory:
    drive:\ibi\WebFOCUS82\utilities\WFReposUtil

    Note: During installation, if the Create WebFOCUS Repository check box is selected, then the installer will run the WFReposUtilCMDLine.bat file in CREATE_INSERT mode. If any errors occur during this process, you can view the WFReposUtilCMDLine.log file for details. If the Create WebFOCUS Repository check box is not selected during installation (in the case of an existing repository), then you must manually run the WFReposUtilGUI.bat file in DROP_CREATE_INSERT mode. Alternatively, you can run the WFReposUtilCMDLine.bat file in DROP_CREATE_INSERT mode.

  2. Run the WFReposUtilCMDLine.bat file by right-clicking the file and selecting the Run as Administrator option.

    This utility creates a .log file with the same name in the same location after running it.

    A Command Window opens, which allows you to create tables or to drop and re-create tables.

  3. Enter a selection from the list of available options:
    • create
    • create_or_extend
    • insert
    • create_insert
    • update
    • drop
    • extract
    • create_ddl
    • quit
  4. Press Enter to continue.

    A prompt for credentials displays. These are credentials for the database connection.

    Note:
    • If updates are performed, the user ID needs to have permissions to create and alter tables.
    • Depending on the option selected, you may be prompted for WebFOCUS Administrator credentials.

    A message appears if any errors occur during the repository creation or re-creation process.

WebFOCUS

Feedback