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.

To install the Oracle database

Do the following:

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).

   Note

   While creating the Oracle database instance, specify the following character sets: 

   • Database Character Set - AL32UTF8
   • National Character Set - UTF8
   • National Character Set for Oracle 12c - AL16UTF16

3. Create table spaces and user for the Report Engine.

   See Creating tablespaces and user on the Oracle database for Report Engine for instructions.

4. (Optional) If you are installing TrueSight Smart Reporting, create table spaces and user for TrueSight Smart Reporting.

   See Creating tablespaces and user on Oracle database for TrueSight Smart Reporting for instructions.

To install the SQL Server database

Do the following:

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.
   
   

   Note

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

   See Creating database, filegroup, and user on SQL Server for Report Engine for instructions. If you are installing TrueSight Smart Reporting, you can create an SQL Server database user while installing TrueSight Smart Reporting.