Using a separate BMC Helix Innovation Suite database for reporting

The BMC Helix ITSM: Smart Reporting and BMC Helix Dashboards applications use the platform-fts or platform-user pods to perform various operations on the BMC Helix Innovation Suite database to display reports.

If you experience any database performance or crucial database transaction issues, you should use a separate BMC Helix Innovation Suite database for the reporting operations. 

You can configure the platform-sr pod to access this new database so that the reporting transactions are diverted to the new database.

Using a separate BMC Helix Innovation Suite database for reporting reduces the transactional load on the primary BMC Helix Innovation Suite, thereby improving database performance.

Related topics

Setting-up-a-Microsoft-SQL-Server-database

Setting-up-an-Oracle-database

Setting-up-a-PostgreSQL-database

The following image shows the pod operations with the BMC Helix Innovation Suite databases:

Separate reporting DB.png


Before you begin

  • Make sure that your deployment size is Medium or Large.
    You cannot use a separateBMC Helix Innovation Suite database for reporting with the Compact and Small deployment sizes.
    The platform-sr pod is deployed in medium, large, and extra-large deployment size environments.
  • Review the database requirements.

Task 1: To create a separate BMC Helix Innovation Suite database

Create a live replica of your existing BMC Helix Innovation Suite database in read-only mode.

Task 2: To configure and use the separate database for reporting

  1. In the HELIX_ONPREM_DEPLOYMENT pipeline, in the Build History section, select the last build, and click Rebuild.
  2. In the PRODUCT-DEPLOY section, select the HELIX_GENERATE_CONFIG and HELIX_PLATFORM_DEPLOY options.

  3. In the DATABASE_REGISTRY_STORAGE_PASSWORDS_SECRETS_DETAILS section, specify values for the following parameters:

    Parameter

    Description

    PLATFORM_SR_DB_JDBC_URL

    Specify the URL in the following format:
    jdbc:<DB driver>://<Database host name:<Database port>/<Database name>
    Example for PostgreSQL database:
    jdbc:postgresql://<Database host name:<Database port>/<Database name>

    PLATFORM_SR_DB_USER

    Specify the BMC Helix Innovation Suite for reporting database user.

    PLATFORM_SR_DB_PASSWORD

    Specify the BMC Helix Innovation Suite for reporting database password.

  4. In the CUSTOMER-INFO section, specify the DEPLOYMENT_MODE parameter value as SERVICE.
  5. Click Rebuild.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*