Managing the warehouse database

The reports data warehouse are set up during configuration. After configuration, you can make changes to your reports data warehouse.

You can use the TrueSight Server Automation - Data Warehouse console to modify the reports data warehouse parameters.

To modify the reports data warehouse database parameters

  1. Launch 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
    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 .

    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. From the Configuration menu, select Database Details.
  3. Click the Modify button in the Warehouse Database row.
  4. On the Modify Warehouse Database Details page, modify the parameters:

    Field definitions

    FieldDescription
    Host NameHost name or IP address of the reports data warehouse database server
    Port

    Port number on which the reports data warehouse database server listens

    SID (Oracle) or Database Name (SQL Server)Service ID or name for the reports data warehouse
    User NameReports data warehouse user name
    PasswordPassword for the reports data warehouse user
    Confirm PasswordConfirmed password for the reports data warehouse user
  5. Click UpdateThe Last Task Details page confirms whether the details were modified successfully.

    Note

    Click Reset to revert to the previous settings.


  6. Modify the datasource password in TrueSight Server Automation - Data Warehouse

    1. Log in to the system where the TrueSight Smart Reporting - Platform is installed, and restart TrueSight Smart Reporting - Platform.

      • (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 TrueSight Smart Reporting - Platform: ./shutdown.sh
        3. Start TrueSight Smart Reporting - Platform: ./startup.sh
    2. Log in to 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
      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 .

      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.

      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 .

      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   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. Make the required changes in the provided fields.
      For example, if you are changing the password, do the following:
      1. In the Password field, click the Click here to change password link
      2. Add the changed password in the text field.
    7. Click Test Connection. If the details are correct, a connection success message appears.
    8. Click Save.


  7. (For UNIX ) Navigate to the $BDS_HOME directory and run the following syntax:
    ./blreports restart

    (For Windows) Restart the Web server service and Authentication Service for reports. 

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

Comments