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 or creating a new repository. The
ReportCaster tables in WebFOCUS 8 are now part of the WebFOCUS repository,
and a database repository must store ReportCaster scheduling data.
If you want to use the Report Library, the database can be any supported
database with an available JDBC driver.
Depending on the platform used, the
WebFOCUS Repository can be stored in a Derby, Microsoft SQL Server,
Oracle, Db2, MySQL®, or PostgreSQL database. Information for JDBC driver
versions for these supported JDBC-compliant databases can be found
at the following link:
WebFOCUS 8.1.x
Client Supported RDBMS and JDBC Drivers
x
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 WebFOCUS 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.
-
Microsoft SQL Server 2014, 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 2014, 2012, 2008, or 2005 (sqljdbc4.jar for 2014/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.
Note:
- The Microsoft SQL Server collation must be set to case-sensitive
for the WebFOCUS database. Case-insensitive collation is not supported.
- The SQL Server collation sequence default is case-insensitive.
SQL Server 2014, 2012, 2008, and 2005 have
TCP/IP disabled by default. Since ReportCaster requires TCP/IP,
you must perform the following steps to enable TCP/IP in SQL Server:
- Open the SQL Server
Configuration Manager.
- Under the SQL Server
Network Configuration select Protocols for MSSQLSERVER.
A
list of valid network protocols for the SQL Server engine is displayed
in the right pane.
- Select TCP/IP from
the list of available protocols.
- Right-click TCP/IP and
select Enable from the context menu.
A
message is displayed, which indicates that the MSSQLSERVER service
must be restarted before the change is applied.
- Restart the MSSQLSERVER
service.
-
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.
Note:
- The collation for MySQL must be set to case sensitive for the
WebFOCUS database. Case-insensitive collation is not supported.
- The default character set and collation for MySQL is latin1
and latin1_swedish_ci, so non-binary string comparisons are case
insensitive, by default.
- For use with WebFOCUS, the collation needs to be set as latin1_general_cs
or latin1_swedish_cs, depending on the character set required.
- WebFOCUS Releases 8.0.x and 8.1.x do not support the MySQL utf8
encoding character set.
-
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.
-
PostgreSQL. Java 1.7 or higher
is required when using a PostgreSQL database for the WebFOCUS repository.
This is a requirement of the PostgreSQL JDBC driver, as it is not
compatible with Java 1.6.
For more information about repositories,
see Additional WebFOCUS Repository Topics and Tasks.
xWebFOCUS Repository Pre-Installation Tasks
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.
x
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.
-
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.
You can optionally create tablespaces
for the repository. For sizing guidelines, see Sizing Guidelines.
Note: Database
collation must be case sensitive for WebFOCUS.