Changing the database server

If you move the reports data warehouse to a different database server, you must configure the connection string parameters such as host name, port, and instance name to connect TrueSight Server Automation - Data Warehouse to the new server.

The configuration steps vary depending on the following scenarios:

Scenario 1: Moving the data warehouse

If you want to move the data warehouse to a different database server, do the following:

  1. Back up the data warehouse with schema.
  2. Restore the backed up data warehouse on the new database server.

  3. Reconfigure the database details.

    Do the following:

    1. Launch the TrueSight Server Automation - Data Warehouse console.

      Perform the following steps to access the 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
      2. In the User Name and Password fields, enter the TrueSight Server Automation - Data Warehouse administrator credentials.
        Default user name: DWAdmin
        By default, the password is hidden. To view the password, click ViewPassword.png.
      3. In Site, select a site. The Primary Site is the default site.
      4. In Authentication Method, select a authentication method. SRP is the default authentication method.
      5. Click LOG IN.
    2. Click Configuration > Database Details.
    3. In the Database Details section, click Reconfigure.

    4. Provide information on the Warehouse Database tab and click Next. Enter details of the restored reports data warehouse. The Warehouse Database tab enables you to configure the following parameters for the TrueSight Server Automation - Data Warehouse reports data warehouse:

      Field

      Description

      Database Character Set

      Values can be CHAR or NCHAR based on your TrueSight Server Automation schema. This field is disabled.

      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

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


    5. Click Finish.
      The Last Task Details page lists the tasks that are run during the reconfiguration process and their status.

  4. Update the data warehouse details in .

    Do the following:

    1. Log in to the system where the  is installed, and restart .

      Perform the following steps:
      • (Windows) Open the Windows services and restart the following service: TrueSight Smart Reporting - Platform
      • (Linux)
        1. Change to the following path: /data1/TrueSightSmartReporting/appserver/bin
        2. Stop : ./shutdown.sh
        3. Start : ./startup.sh

    2. Log in to the TrueSight Server Automation - Data Warehouse console. 

      To log in as the DWAdmin user, do the following:
      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
      2. In the User Name and Password fields, enter the TrueSight Server Automation - Data Warehouse administrator credentials.
        Default user name: DWAdmin
        By default, the password is hidden. To view the password, click ViewPassword.png.
      3. In Site, select a site. The Primary Site is the default site.
      4. In Authentication Method, select a authentication method. SRP is the default authentication method.
      5. Click LOG IN.
      6. Click Reports to launch the TrueSight Smart Reporting - Platform Home page.
      To log in as a reporting user, do the following:
      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
      2. In the User Name and Password fields, enter the user credentials. By default, the password is hidden. To view the password, click ViewPassword.png.
      3. In Site, select a site. The Primary Site is the default site.
      4. In Authentication Method, select a authentication method. SRP is the default authentication method.
      5. Click LOG IN.
      6. In the Roles window, select the role you want to use and click OK. Through role-based access control (RBAC), you can be granted multiple roles, but you can use only one role at a time.
    3. In the left navigation bar, expand image2019-3-12_7-25-33.png  and go to Administration > Admin console.
    4. Click Data Sources and then click the TrueSight Server Automation - Data Warehouse datasource.
    5. Click Connection Settings.
    6. Specify new values for the updated fields.
      • For SQL Server database:
        • The database host name
        • The database name and port
        • User name and password
      • For Oracle database
        • The database host name
        • The database port
        • The service name
        • User name and password
    7. Click Test Connection. If the details are correct, a connection success message appears.
    8. Save the changes.

  5. Run the ETL as per the schedule.

Scenario 2: Moving the data warehouse and TrueSight Server Automation site databases

If you want to move the data warehouse and TrueSight Server Automation site databases to a different database server, do the following:

  1. Back up the TrueSight Server Automation site databases and restore them on the new database server.

  2. Update the site database details.

    Do the following:
    1. On the TrueSight Server Automation - Data Warehouse console, navigate to Configuration > Database Details.
    2. Under Site Details, click edit_icon.pngunder the Modify column corresponding to the site database to be reconfigured.
    3. Change the required details, such as host name, port, and site ID.
    4. Click Update.
    5. On the Last Task Details page, verify the task status.
    6. If you want to reconfigure other sites, repeat these steps.
  3. Back up the data warehouse and restore it on a new database server.
  4. Reconfigure the database details.
    Do the following:
    1. Launch the TrueSight Server Automation - Data Warehouse console.
      Perform the following steps to access the 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
      2. In the User Name and Password fields, enter the TrueSight Server Automation - Data Warehouse administrator credentials.
        Default user name: DWAdmin
        By default, the password is hidden. To view the password, click ViewPassword.png.
      3. In Site, select a site. The Primary Site is the default site.
      4. In Authentication Method, select a authentication method. SRP is the default authentication method.
      5. Click LOG IN.
    2. Click Configuration > Database Details.
    3. In the Database Details section, click Reconfigure.
    4. Provide information on the Warehouse Database tab and click Next. Enter details of the restored reports data warehouse. The Warehouse Database tab enables you to configure the following parameters for the TrueSight Server Automation - Data Warehouse reports data warehouse:
      Field
      Description
      Database Character Set
      Values can be CHAR or NCHAR based on your TrueSight Server Automation schema. This field is disabled.
      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
      User 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.

    5. Click Finish.
      The Last Task Details page lists the tasks that are run during the reconfiguration process and their status.
  5. Update the data warehouse details in .
    Do the following:
    1. Log in to the system where the  is installed, and restart .
      Perform the following steps:
      • (Windows) Open the Windows services and restart the following service: TrueSight Smart Reporting - Platform
      • (Linux)
        1. Change to the following path: /data1/TrueSightSmartReporting/appserver/bin
        2. Stop : ./shutdown.sh
        3. Start : ./startup.sh
    2. Log in to the TrueSight Server Automation - Data Warehouse console.
      To log in as the DWAdmin user, do the following:
      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
      2. In the User Name and Password fields, enter the TrueSight Server Automation - Data Warehouse administrator credentials.
        Default user name: DWAdmin
        By default, the password is hidden. To view the password, click ViewPassword.png.
      3. In Site, select a site. The Primary Site is the default site.
      4. In Authentication Method, select a authentication method. SRP is the default authentication method.
      5. Click LOG IN.
      6. Click Reports to launch the TrueSight Smart Reporting - Platform Home page.
      To log in as a reporting user, do the following:
      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
      2. In the User Name and Password fields, enter the user credentials. By default, the password is hidden. To view the password, click ViewPassword.png.
      3. In Site, select a site. The Primary Site is the default site.
      4. In Authentication Method, select a authentication method. SRP is the default authentication method.
      5. Click LOG IN.
      6. In the Roles window, select the role you want to use and click OK. Through role-based access control (RBAC), you can be granted multiple roles, but you can use only one role at a time.
    3. In the left navigation bar, expand image2019-3-12_7-25-33.png  and go to Administration > Admin console.
    4. Click Data Sources and then click the TrueSight Server Automation - Data Warehouse datasource.
    5. Click Connection Settings.
    6. Specify new values for the updated fields.
      • For SQL Server database:
        • The database host name
        • The database name and port
        • User name and password
      • For Oracle database
        • The database host name
        • The database port
        • The service name
        • User name and password
    7. Click Test Connection. If the details are correct, a connection success message appears.
    8. Save the changes.
  6. Run the ETL for all the sites as per the schedule.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*