JasperReports Server (CABI) database repository creation during installation

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

During the setup of CA Business Intelligence (CABI) JasperReports Server, the installer manages the creation of the underlying database repository. This article clarifies when the structure is created and the prerequisites for database connectivity.

Environment

14.5 Identity Suite

Resolution

The JasperReports Server (CABI) installer is designed to create the required database structure automatically during the installation process. Manual pre-creation of tables and schemas is not required, provided the connection details are valid.

1. Database Connection Setup During the installation, you will be prompted for the following connection details:

• Database Type (e.g., Oracle, SQL Server)
• Database Host and Port
• Administrative User and Password (required to create the database/schema)

2. Repository Naming After establishing a connection, the installer will request a name for the repository database. By default, this is configured as: jasperserver

3. Required Permissions The most common cause of installation failure is insufficient database permissions. The account provided must have the authority to:

• Create databases/schemas
• Create tables, views, and indexes
• Assign permissions to the repository user

Additional Information

For a detailed list of required privileges, refer to the TIBCO JasperReports Server Database Privileges Guide.