Viewing assistance

For a better view of the table, press F to view the page in full screen mode. To return to the normal view, press Esc.

The following table lists various user accounts that are created and used by TrueSight Server Automation - Data Warehouse.

User accounts
created or used/
Account Type

Purpose

Is the default password set?


Change in default password required?

Privileges

Account created by

Password
storage location

Encryption
mechanism

blauth

OS

Runs the authentication serviceNANAOwns the blauthserver filesProduct installerNANA

DWAdmin

Application


Administration taskNANA

Administrator user for the portal

Can log in to TrueSight Server Automation - Data Warehousefor administration; however, cannot see any data in the reports

Product installerNANA

Any TrueSight Server Automation - Data Warehouse user

Application

User

No

NA

Can use the reporting functionality.

TrueSight Server Automation

NA

NA

TSSADW_DW

Database (SQL Server)

Owns the warehouse database schema

Yes

Change according
to your database policy

  • Is owner (dbo) of the reports database
  • Is the default database, TSSADW_DW_DB
  • Executes ETL jobs (using JDBC connectivity) by reading data from the TrueSight Server Automation database across the database link

Database creation script

NANA

TSSADW_ETL_MASTER

Database (SQL Server)

Owns the ETL master schemaYesChange according
to your database policy
  • Is owner (dbo) of the ETL master repository database
  • Is the default database, TSSADW_ETL_MASTER_DB
  • Uses JDBC connectivity for ETL job execution
Database creation scriptNANA

TSSADW_ETL_WORK

Database (SQL Server)

Owns the ETL work schemaYesChange according
to your database policy
  • Is owner (dbo) of the ETL work repository database
  • Is the default database, TSSADW_ETL_WORK_DB
  • Uses JDBC connectivity for ETL job execution
Database creation scriptNANA

TSSADW_DW

Database (Oracle)

Owns the warehouse database schema

Yes

Change according
to your database policy

  • Is owner of the reports database objects.
  • Executes ETL jobs (using JDBC connectivity) by reading data from the TrueSight Server Automation database across the database link.

Database creation script

NANA

TSSADW_ETL_MASTER

Database (Oracle)

Owns the ETL master schemaYesChange according
to your database policy
  • Is owner of the ETL master repository objects.
  • Uses JDBC connectivity for ETL job execution
Database creation scriptNANA

TSSADW_ETL_WORK

Database (Oracle)

Owns the ETL work schemaYesChange according
to your database policy
  • Is owner of the ETL work repository objects
  • Uses JDBC connectivity for ETL job execution
Database creation scriptNANA

Upgrade Assistance

The BMC Assisted Migration Offering (AMIGO) program is designed to assist customers with the planning of product upgrades to a newer version – “Success through proper planning”.
Explore AMIGO Program ›
Was this page helpful? Yes No Submitting... Thank you