Configuring TrueSight Server Automation - Data Warehouse by using the console

Configure databases, repositories, and the primary site by using the console.

Before you begin

Before you start configuring the product, ensure that the following requirements are met:

  • If you are deploying with the SQL Server database, ensure that the data warehouse database user have sysadmin privileges 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 for your web browser.

     Click here to see the steps to enable JavaScript for Microsoft 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. 
     Click here to see the steps to enable JavaScript for Mozilla.
    1. Click Tools > Internet Options.
    2. On the Content tab, select the Enable JavaScript check box. 

To configure the product by using the TrueSight Server Automation - Data Warehouse console

  1. Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
    https://<TrueSight Server Automation - Data Warehouse hostname>:<portNumber>/tssa-dw
    The default port number is 9443.
  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 Type tab, view the database type that you are using and click Next.

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

    (For a new empty data warehouse)

    • If you have created new databases and users, select the New databases/users option and click Next.
    • If you have not created new databases and users, click the Download the scripts link to download the database and user creation scripts.
      Ensure that you set up the database and restart the configuration process. For instructions, see Setting up the databases .

    (For existing BMC Decision Support for Server Automation warehouse)

    • Select the Existing databases/users used for BDSSA option and click Next.

  6. On the ETL Master Repository tab, provide the following information and click Next.

    FieldDescription
    Host Name

    Host name or IP address of the database server that hosts the ETL master repository schema

    Ensure that:

    • You do not use the localhost value in this field.

    • If you are using an SQL Server and databases are created on a named instance, provide the host name in the Host Name field and a valid port number of the named instance in the Port field.

    PortPort number for the database server that hosts the ETL master repository schema
    SID (Oracle) or Database Name (SQL Server)Service ID or Service name for the ETL master repository
    User NameUser name for the ETL work repository
    Password and Confirm Password

    Password for the ETL master repository user

    Note: Do not use the following special characters:

    • Ampersand (&)
    • Double quotes (" ")
    • Pipe (|)
    • Less than sign (<)
    • Greater than sign (>)
    • Single quotes (' ')
    • Forward slash (/)
    • Semicolon (;)

    If you use special characters, the configuration fails and you have to reconfigure the database schema.

  7. On the ETL Work Repository tab, provide the following information and click Next

    Note: Using existing BMC Decision Support for Server Automation database

    If you are using the existing BMC Decision Support for Server Automation database, all the fields in this page are auto-populated, except the Password field.


    FieldDescription
    Host Name

    Host name or IP address of the database server that hosts the ETL work repository schema

    Ensure that:

    • You do not use the localhost value in this field.

    • If you are using an SQL Server and databases are created on a named instance, provide the host name in the Host Name field and a valid port number of the named instance in the Port field.

    PortPort number for the database server that hosts the ETL work repository schema
    SID (Oracle) or Database Name (SQL Server)Service ID or Service name for the ETL work repository
    User NameUser name for the ETL work repository
    Password and Confirm Password

    Password for the ETL work repository user

    Note: Do not use the following special characters:

    • Ampersand (&)
    • Double quotes (" ")
    • Pipe (|)
    • Less than sign (<)
    • Greater than sign (>)
    • Single quotes (' ')
    • Forward slash (/)
    • Semicolon (;)

    If you use special characters, the configuration fails and you have to reconfigure the database schema.

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

    Note: Using existing BMC Decision Support for Server Automation database

    If you are using the existing BMC Decision Support for Server Automation database, all the fields in this page are auto-populated, except the Password field.

    Field definitions

    FieldDescription
    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 BMC Decision Support for Server Automation 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 using an SQL Server and databases are created on a named instance, provide the host name in Host Name field and a valid port number of the named instance in the Port 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 NameUser name for the data warehouse user
    Password and Confirm Password

    Password for the data warehouse user

    Note: Do not use the following special characters:

    • Ampersand (&)
    • Double quotes (" ")
    • Pipe (|)
    • Less than sign (<)
    • Greater than sign (>)
    • Single quotes (' ')
    • Forward slash (/)
    • Semicolon (;)

    If you use special characters, the configuration fails and you have to reconfigure the database schema.

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

    Note: Primary Site information for existing BMC Decision Support for Server Automation users.

    If you have more than one TrueSight Server Automation sites configured and you want to use the existing database, you need to configure the passwords for the databases of all sites except the Primary Site. The Primary Site information is auto-populated in the Primary Site tab. You can configure the password of the other sites by using the Configure Password link in Configuration > Database Details page.

    FieldDescription
    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 using an SQL Server and databases are created on a named instance, provide the host name in the Host Name field and a valid port number of the named instance in the Port 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

    User name for the TrueSight Server Automation database user

    Password and Confirm Password

    Password for the TrueSight Server Automation database user

    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.

  10. Click Finish to display the Last Task Details page. This displays the status and details of the last configuration or reconfiguration task that was run through the console.

  11. Click Configuration to activate the ETL Management menu.

How to videos

Configuring TrueSight Server Automation by using the console on Windows (3:22)

https://youtu.be/bWrXkqRWsVw 

Configuring TrueSight Server Automation by using the console on Linux (3:41)

https://youtu.be/J3kIC6UDx_s

Was this page helpful? Yes No Submitting... Thank you

Comments

  1. Matthew Ragland

    The restart the RSCD agent link yields "Page not found"

    Aug 26, 2019 09:34
  2. Gerad Cruz

    How do we move to a different DB server using different ports if as is documented here "Note: Using existing BMC Decision Support for Server Automation database. If you are using the existing BMC Decision Support for Server Automation database, all the fields in this page are auto-populated, except the Password field." The new DB server uses different ports. We need a way to update the port

    Mar 03, 2020 09:45
    1. Bipin Inamdar

      If you have Old BDSSA setup up and running, you can use reconfigure with updated DB server,port and other details. Then you can use existing option while installing TSSA-DW. Or you can use old port, old db server details by use existing option in TSSA-DW and then later you can reconfigure from TSSA-DW portal with new db server, port details.

      Mar 04, 2020 02:43
  3. Jeff Piontek

    In regards to this step in Before you begin: "If you are deploying with the SQL Server database, ensure that the data warehouse database user have sysadmin privileges to create a database link between TrueSight Server Automation - Data Warehouse and TrueSight Server Automation."

    Does the data warehouse database user refer to the user TSSADW_DW of the TSSADW_DW_DB (assuming default DB and user names)? Does the configuration step use Transact SQL to establish the DB link, where the ALTER ANY LINKED SERVER permission may be adequate? If sysadmin is required, must it be maintained after completing the configuration step? We don't want to grant any higher permissions than necessary, so I'm just trying to clarify.

    Mar 06, 2020 11:03