Setting up the databases for TrueSight Server Automation - Data Warehouse

Before installing TrueSight Server Automation - Data Warehouse, you must set up the required databases, as described in the following topics:

Recommendation

BMC recommends you to use separate database instances for the data warehouse database and the TrueSight Server Automation database.

To use TrueSight Server Automation - Data Warehouse in non-English locales, see To configure TrueSight Server Automation databases for a non-English locale.

For a multi-site deployment of TrueSight Server Automation - Data Warehouse, where a secondary TrueSight Server Automation site uses a different character set, the following setup is supported:

  • Application Server 1 database uses CHAR.
  • Application Server 2 database uses NCHAR.
  • TrueSight Server Automation - Data Warehouse server 1 database uses NCHAR.

TrueSight Server Automation - Data Warehouse server 1 cannot use CHAR because you cannot run ETL from an NCHAR database to a CHAR database.


 

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