WebFOCUS Repository Setup

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 Derby, SQL Server, Oracle, DB2, MySQL®, or other JDBC-compliant database on any machine with a TCP/IP connection to the Distribution Server. If you use Report Library, the database must support BLOBs. If you want to use another JDBC-compliant database, contact Customer Support Services for additional assistance.

Note: The SQL Server collation sequence default is case-insensitive. To change the collation sequence of an existing repository, see Technical Memo 4749, Changing the Microsoft SQL Server Collation Sequence.

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.
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.
Microsoft SQL Server 2012, 2008, or 2005. To use SQL Server, the appropriate SQL Server JDBC driver must be on the machine or machines that run the WebFOCUS Client and the ReportCaster Distribution Server. The driver varies depending on whether you use 2012, 2008, or 2005 (sqljdbc4.jar for 2012/2008 or sqljdbc.jar for 2005). You can download and install the specific driver from the Microsoft website.
If you are unfamiliar with the JDBC driver and its requirements, information is provided in Additional WebFOCUS Repository Topics and Tasks.
MySQL 5.0. To use a MySQL Server repository, the MySQL driver should be installed on the machine or machines that run the WebFOCUS Client and the ReportCaster Distribution Server. This is typically named mysql-connector-java-nn-bin.jar, where nn is the version number. MySQL Repository Set Up contains information on installing and configuring the MySQL database server and this driver.
Oracle™ 10G, 11G, or 11GR2. To use an Oracle repository, the Oracle JDBC™ Thin Client 9.0.1 driver must be on the machine or machines that run the WebFOCUS Client and the ReportCaster Distribution Server. This is typically named ojdbc6.jar depending on the Java release.
Other JDBC-Compliant Databases. To use other JDBC-compliant databases, you need their JDBC drivers. You must also know the JDBC Path to connect to the database.

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 WebFOCUS Repository Topics and Tasks.

Top of page

Procedure: How to Prepare for a WebFOCUS Repository

For additional background information and sizing guidelines for DB2 on z/OS, see Additional WebFOCUS Repository Topics and Tasks.

Ask your DBA to perform the following tasks:

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.
For SQL Server, the database must use SQL Server authentication rather than Windows authentication, and the user ID must have db_owner rights to the repository database.
If applicable, create a database within your database server for the WebFOCUS repository and ensure the user ID you created is the database owner. You will need the name of this database during the ReportCaster installation.