Installing and configuring the Reporting database

The TrueSight Operations Management Reporting database acts as a central repository for all the event, impact, and performance data for one or multiple Report Engines. The Reporting database can be either Oracle or SQL Server.

The Reporting database works with the Report Engine to compile reports that you can see in TrueSight Smart Reporting. The Report Engine is a Java application that collects event, impact, and performance data from TrueSight Infrastructure Management Server. , and compiles the data. The Report Engine periodically summarizes performance data, and calculates impact metrics using the events data.

The TrueSight Smart Reporting repository uses the Reporting database to store data. You must install the Reporting database before you install TrueSight Smart Reporting.

To install the Oracle database

  1. Install the Oracle database. For more details, see the Oracle manuals on the Oracle web site (https://www.oracle.com/index.html).

  2. Create the Oracle database instance. For more details, see the Oracle manuals on the Oracle web site (https://www.oracle.com/index.html).

  3. Create table spaces and user for the Report Engine.
    See Creating-tablespaces-and-user-on-the-Oracle-database-for-the-Report-Engine for instructions.
  4. Create table spaces and user for TrueSight Smart Reporting.
    See Creating-tablespaces-and-user-on-the-Oracle-database-for-TrueSight-Smart-Reporting for instructions. 

Note: Avoid an error when the Oracle server and client are installed on the same computer

An error might occur when the Oracle server is installed on the same computer with Oracle client because of incorrect sequence of the Oracle path in the PATH variable. To avoid this issue, set the client entry before the Oracle server entry in the path variable. For example:

PATH : D:\oracle\product\11.2.0\client_1\bin;D:\oracle\product\11.2.0\db_1\bin;

To install the SQL Server database

  1. Install the SQL Server database. For more details, see the SQL Server manuals on the Microsoft site (https://www.microsoft.com/en-in/).
  2. Create the SQL Server database and user.

    NoteSelect the appropriate collation character set according to your server locale.


    See Creating-filegroups-and-user-on-the-SQL-Server-database-for-the-Report-Engine for instructions.
    For TrueSight Smart Reporting, you can create the SQL Server database user during the installation.
  3. (Optional) To configure the installed  Report Engine  to enable Transport Layer Security (TLS), you must first disable the encryption switch on the SQL Server database by doing the following:

    1. Log in to the computer where the Microsoft SQL Server is installed.
    2. Open the SQL Server Configuration Manager.
    3. Navigate to SQL Server Network Configuration > Protocols for <SQL Instance>.
    4. Right-click Protocols for <SQL Instance> and select Properties. The Properties dialogue box is opened.
    5. Click the Flags tab, and set the Force Encryption Flag value to No.
    6. Restart the SQL server instance.

 

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