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.
To configure TrueSight Server Automation - Data Warehouse
Do the following:
- Use the following URL to open the login page of the TrueSight Server Automation - Data Warehouse console:
https://<TrueSight Server Automation - Data Warehouse_hostname>:<portNumber>/tssa-dw
- 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 .
- Click LOG IN.
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:
- Click Download the scripts to download the database and user creation scripts.
- Run the scripts to create databases and users. For instructions, see Setting up the databases for TrueSight Server Automation - Data Warehouse.
- 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:
- 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/)
- Update the copied bds.properties file with the preferred database connection details.
- Click Validate. The specified database connections are validated.
- 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:
On the Warehouse Database tab, provide the following information and click Next.
Note: Using existing TrueSight Server Automation - Data Warehouse database
If you are using the existing TrueSight Server Automation - Data Warehouse database, all the fields in this page are auto-populated.
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.
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.
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.
Click Configuration to activate the ETL Management menu.
Comments
Log in or register to comment.