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 Open link (https://www.oracle.com/index.html).
  2. Create the Oracle database instance. For more details, see the Oracle manuals on the  Oracle web site Open link  (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 Open link  (https://www.microsoft.com/en-in/).

  2. Create the SQL Server database and user.

    Note

    Select 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.
Was this page helpful? Yes No Submitting... Thank you

Comments