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 Open link  (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 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 TrueSight Smart Reporting. 

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

Upgrade Assistance

The BMC Assisted Migration Offering (AMIGO) program is designed to assist customers with the planning of product upgrades to a newer version – “Success through proper planning”.
Explore AMIGO Program ›
Was this page helpful? Yes No Submitting... Thank you