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
- Install the Oracle database. For more details, see the Oracle manuals on the Oracle web site (https://www.oracle.com/index.html).
Create the Oracle database instance. For more details, see the Oracle manuals on the Oracle web site(https://www.oracle.com/index.html).
To install the SQL Server database
- Install the SQL Server database. For more details, see the SQL Server manuals on the Microsoft site (https://www.microsoft.com/en-in/).
- Create the SQL Server database instance.
- (Optional) To configure Transport Layer Security (TLS), you must first disable the encryption switch on the SQL Server database. Do doing the following:
- Log in to the computer where the Microsoft SQL Server is installed.
- Open the SQL Server Configuration Manager.
- Navigate to SQL Server Network Configuration > Protocols for <SQL Instance>.
- Right-click Protocols for <SQL Instance> and select Properties. The Properties dialogue box is opened.
- Click the Flags tab, and set the Force Encryption Flag value to No.
- Restart the SQL server instance.