Configuring TrueSight Server Automation - Data Warehouse

Configure TrueSight Server Automation - Data Warehouse to specify the database and primary site details for retrieving data from TrueSight Server Automation.

Prerequisites

Make sure that the following requirements are met:

• If you are using an SQL Server database, make sure that the data warehouse database user has the sysadmin privilege to create a database link between TrueSight Server Automation - Data Warehouse and TrueSight Server Automation. For information about how to verify user privileges, see Database links in the Microsoft documentation.

• To access the console, JavaScript must be enabled in your web browser.

  Steps to enable JavaScript in the Internet Explorer:

  1. Click Tools > Internet Options. 
  2. On the Security tab, click the Custom level button. 
  3. Navigate to Scripting > Active scripting, and select the Enable option. 

  Steps to enable JavaScript in Mozilla:

  1. Click Tools > Internet Options.
  2. On the Content tab, select the Enable JavaScript check box. 

  Steps to enable JavaScript in Google Chrome:

  1. Click Settings.
  2. Under Privacy and security, click Site Settings.
  3. Under Additional permissions, click JavaScript and enable it.

To configure TrueSight Server Automation - Data Warehouse

Do the following:

1. Use the following URL to open the login page of the TrueSight Server Automation - Data Warehouse console:
   https://<

   Unknown macro: confluence_display. Click on this message for details.

   The [confluence_display] macro is not in the list of registered macros. Verify the spelling or contact your administrator.

   _hostname>:<portNumber>/tssa-dw
   

2. In the User Name and Password fields, enter the DWAdmin credentials. DWAdmin is the TrueSight Server Automation - Data Warehouse administrator. By default, the password is hidden. To view the password, click .
3. Click LOG IN.

4. On the Database Prerequisites tab, select one of the following options:

   • If you are installing TrueSight Server Automation - Data Warehouse for the first time, select Fresh install - Use new TSSA-DW Warehouse, and do the following:
     
     
     
     
     • If you have already created new databases and users, click Next.
     • If the databases and users are not created, do the following to create them:
       
       1. Click Download the scripts to download the database and user creation scripts.
       2. Run the scripts to create databases and users. For instructions, see Setting-up-the-databases-for-TrueSight-Server-Automation-Data-Warehouse.
       3. Resume the configuration process.
   • If you want to create a standby node for disaster recovery, select Disaster Recovery Install - Setup additional TSSA-DW node using existing or standby warehouse database, and do the following:
     
     1. Copy the bds.properties file from the primary TrueSight Server Automation - Data Warehouse server (path: <tssadw_installation_directory>/shared/ConfigurationManagement/) to the secondary TrueSight Server Automation - Data Warehouse server (path: <tssadw_installation_directory>/migrationData/)
     2. Open the copied bds.properties file and update the BSA_DATABASE_HOSTNAME, BSA_DATABASE_PORT, BSA_DATABASE_NAME_SID, BSA_DATABASE_USER and BSA_DATABASE_PASSWORD parameters as per the the standby node details for the database server. The database password must be specified in the blenc (BLencrypt) format. To obtain the password in the blenc format, do the following:
        1. Navigate to the <tssadw_installation_directory>/bin directory and run the following command:
           (Windows) <tssadw_installation_directory>\bin\blenc.exe <password>
           (Linux) <tssadw_installation_directory>/bin/blenc <password>
        2. Copy the encrypted password after BLencrypt in the output and assign to the BSA_DATABASE_PASSWORD parameter. 
        3. Save the bds.properties file. 
     3. Click Validate. The specified database connections are validated. 
     4. After successful validation, click Next.

5. On the Warehouse Database tab, provide the following information and click Next.

   Note

   • If you select Disaster Recovery Install - Setup additional TSSA-DW node using existing or standby warehouse database option in step 4, all the fields in this page are auto-populated.
   • For a fresh installation you need to enter the fields manually. Refer the following table for a description of these field definitions.

   Field definitions
   
   

6.  On the Primary Site tab, provide the following information.
7. Click Finish. The Last Task Details page displays the status and details of the last configuration or reconfiguration task that was run through the console.
8. Click Configuration to activate the ETL Management menu.