In this section: |
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.
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®, Informix, Sybase, Teradata®, 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: If your WebFOCUS installation uses a SQL Server, the database must be case-sensitive. The default for creation is case-insensitive, but this can be changed before or after creation.
Review the information below and decide on the database server to use:
If you are unfamiliar with the JDBC driver and its requirements, information is provided in Additional WebFOCUS Repository Topics and Tasks.
SQL Server 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 2012, 2008, and 2005:
A list of valid network protocols for the SQL Server engine is displayed in the right pane.
A message is displayed, which indicates that the MSSQLSERVER service must be restarted before the change is applied.
Other databases for which ReportCaster can be used include Sybase SQL Anywhere (Versions 12 and 12.5), Informix (Version 11.5), and Teradata (Versions 12 and 13).
For more information about repositories, see Additional WebFOCUS Repository Topics and Tasks.
How to: |
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.
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:
You can optionally create tablespaces for the repository. For sizing guidelines, see Sizing Guidelines.
WebFOCUS |