WebFOCUS Repository Setup

The ReportCaster 8 repository structure has changed from previous releases and is now a part of the WebFOCUS repository. Therefore, you cannot use a repository from an early release without migrating its contents.

To store delivery information, as well as distributed reports and files, ReportCaster needs access to a database repository. The WebFOCUS Repository can be stored in a DB2 database on any machine with a TCP/IP connection to the Distribution Server. Derby is also supported. If you want to use another JDBC-compliant database, contact Customer Support Services for additional assistance.

Repository Options

Review the information below and decide on the database server to use:

DB2. To use a DB2 repository, a DB2 JDBC driver must be on the machine or machines that run the WebFOCUS Client and the ReportCaster Distribution Server. For more information on using a DB2 repository, see Additional ReportCaster Repository Topics and Tasks.
Derby 10.9.1.0. If you choose, Derby can be installed with WebFOCUS. If you are also installing Tomcat, the required JDBC driver (derbyclient.jar) will be added to the Tomcat configuration file.

For more information about repositories, see Additional WebFOCUS Repository Topics and Tasks.

WebFOCUS Repository Pre-Installation Tasks

How to:

Prepare for a WebFOCUS Repository

During the WebFOCUS installation, you are prompted for information that WebFOCUS and ReportCaster need to access your repository. After WebFOCUS receives this information, you can use the WebFOCUS utilities to create repository tables and perform other repository-related tasks.

Additional information on ReportCaster Repositories is available in Additional ReportCaster Repository Topics and Tasks.

Top of page

Procedure: How to Prepare for a WebFOCUS Repository

Additional background information and sizing guidelines are available in Additional ReportCaster Repository Topics and Tasks.

Ask your DBA to perform the following:

Install the JDBC driver for your WebFOCUS repository database on the WebFOCUS Client and ReportCaster Distribution Server machine or machines. You will be prompted for the path to the driver during the WebFOCUS and ReportCaster installation.
Create or assign a user ID and password that will own the repository. You will be prompted for this information during the WebFOCUS and ReportCaster installation.
If applicable, create a DB2 library for the WebFOCUS repository and ensure the user ID you created is the library owner. You will need the name of this library during the ReportCaster installation.