In this section:
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
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.
For more information about repositories, see Additional WebFOCUS Repository Topics and 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.
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:
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.
Note: Database collation must be case sensitive for WebFOCUS.