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://<TSSADW_Host_Name>:9443/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.

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

   Warning

   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
   
   

   Field	Description
   Database Character Set	(Only for new TrueSight Server Automation - Data Warehouse configuration) Database character set for the data warehouse. Values can be CHAR or NCHAR based on your TrueSight Server Automation schema. Note: This field does not appear if you are using the existing TrueSight Server Automation - Data Warehouse database.
   Host Name	Host name or IP address of the database server that hosts the data warehouse schema. Ensure that: You do not use the localhost value in this field. If you are deploying with the SQL Server database and databases are created on a named instance, you provide the hostname and valid port number of the named instance instead of <Hostname/NamedInstance> in the Host Name field.
   Port	Port number for the database server that hosts the data warehouse schema.
   SID (Oracle)/ Database Name (SQL Server)	Service ID or Service name for the data warehouse.
   User Name	Name of the data warehouse user.
   Password and Confirm Password	Password for the data warehouse user. Password guidelines Do not use the following special characters: Ampersand (&) Double quotes (" ") Pipe (|) Less than sign (<) Greater than sign (>) Single quotes (' ') Forward slash (/) Semicolon (;) Percentage (%) If you use special characters, the configuration fails and you have to reconfigure the database schema. Note: These fields are visible only when you are performing a fresh installation of TrueSight Server Automation - Data Warehouse.

   Field definitions

   Field	Description
   Database Character Set	(Only for new TrueSight Server Automation - Data Warehouse configuration) Database character set for the data warehouse. Values can be CHAR or NCHAR based on your TrueSight Server Automation schema. Note: This field does not appear if you are using the existing TrueSight Server Automation - Data Warehouse database.
   Host Name	Host name or IP address of the database server that hosts the data warehouse schema. Ensure that: You do not use the localhost value in this field. If you are deploying with the SQL Server database and databases are created on a named instance, you provide the hostname and valid port number of the named instance instead of <Hostname/NamedInstance> in the Host Name field.
   Port	Port number for the database server that hosts the data warehouse schema.
   SID (Oracle)/ Database Name (SQL Server)	Service ID or Service name for the data warehouse.
   User Name	Name of the data warehouse user.
   Password and Confirm Password	Password for the data warehouse user. Password guidelines Do not use the following special characters: Ampersand (&) Double quotes (" ") Pipe (|) Less than sign (<) Greater than sign (>) Single quotes (' ') Forward slash (/) Semicolon (;) Percentage (%) If you use special characters, the configuration fails and you have to reconfigure the database schema. Note: These fields are visible only when you are performing a fresh installation of TrueSight Server Automation - Data Warehouse.

    

6.  On the Primary Site tab, provide the following information.

   Field	Description
   Host Name	Host name or IP address of the TrueSight Server Automation database server. Ensure that: You do not use the localhost value in this field. If you are deploying with the SQL Server database and databases are created on a named instance, you provide the hostname and valid port number of the named instance instead of <Hostname/NamedInstance> in the Host Name field.
   Port	Port number for the TrueSight Server Automation database server.
   SID (Oracle) or Database Name (SQL Server)	Service ID or service name for the TrueSight Server Automation database.
   User Name	Name of the TrueSight Server Automation database user.
   Password and Confirm Password	Password for the TrueSight Server Automation database user. Note: These fields are visible only when you are performing a new installation of TrueSight Server Automation - Data Warehouse. If you are migrating from BMC Decision Support for Server Automation, these fields are not displayed.
   Site Name	The name with which a TrueSight Server Automation database is referred in TrueSight Server Automation - Data Warehouse.
   ETL Cutoff Period	Number of past months for which you want the data to be transferred from the TrueSight Server Automation database to the data warehouse Minimum value: 3 Maximum value: 36 This field enables you to control the amount of data that is transferred to the reports data warehouse for the first time.

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.