Skip to Content

Setting up the TrueSight Smart Reporting repository database

The TrueSight Smart Reporting repository database is the database that TrueSight Smart Reporting uses to store all reports. The repository database can be one of the following:

  • PostgreSQL
  • Oracle
  • SQL Server

You must set up the repository database before you install TrueSight Smart Reporting.

Setting up PostgreSQL Server database as the repository database

Use the the PostgreSQL downloads page (https://www.postgresql.org/download/) to download the PostgreSQL database installer, and then install the database as the repository database. Installation instructions for each installer are available on the page from where you download the installer.

Setting up Oracle as the repository database

You can use the existing database instance of TrueSight Server Automation - Data Warehouse as the repository database. Create the tablespace and database user that you must provide when you install TrueSight Smart Reporting. To know more about creating a tablespace and user, see Creating tablespaces and user on the Oracle database for TrueSight Smart Reporting.

Warning

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;

Setting up SQL Server as the repository database

You can use the existing database instance of TrueSight Server Automation - Data Warehouse, and do not need a separate instance for TrueSight Smart Reporting.

The TrueSight Smart Reporting installer creates the required database and schema in the same instance. Do not create the database and schema manually.

 

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

TrueSight Smart Reporting for Server Automation 19.01