Installing and configuring the TrueSight Smart Reporting repository database 1

TrueSight Smart Reporting

TrueSight Smart Reporting can be used with one of the following databases:

  • PostgreSQL
  • Oracle
  • SQL Server

You must install the database before you install TrueSight Smart Reporting.

To install the Postgre SQL Server database

See the PostgreSQL documentation (https://www.postgresql.org/docs/) for information about installing the PostgreSQL database.

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

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 instance.
  3. (Optional) To configure Transport Layer Security (TLS), you must first disable the encryption switch on the SQL Server database. Do 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*