Deployment use cases

TrueSight Network Automation - Data Warehouse is installed on a server in your environment, which is called the application server. This server is shown as TrueSight Network Automation – Data Warehouse in the architecture diagram. TrueSight Network Automation - Data Warehouse can be located on the same server as TrueSight Network Automation. However, BMC recommends that you install the two products on separate computers to improve performance.

The extract, transform, and load (ETL) engine transfers and transforms data from the TrueSight Network Automation sites and populates the data warehouse. The database can reside on the same server as the TrueSight Network Automation database. The database server points to the application server for the ETL process. The application server and database server can reside on the same computer. However, BMC recommends that you use different computers to improve performance.

TrueSight Network Automation - Data Warehouse deployments can be local (single site) or centralized (multi-site). The following sections explain these scenarios.

Single-site deployment

In single-site deployment, data comes from a single Network Automation site. A single Network Automation database populates the reports data warehouse. Consider the size of your environment and performance factor and choose one of the following set ups that you would want to deploy.

Sample set up for small-sized environments

This type of set up is recommended for small-sized environments. In the following set up (shown in the diagram):

• The Network Automation application server is located on a separate computer.

• The TrueSight Network Automation - Data Warehouse and Network Automation databases are located on the Network Automation application server.

  Note

  This diagram assumes that Network Automation is using the embedded PostgreSQL as the database that is shipped with the product. For other types of databases and in relatively larger set ups, you might consider locating the TrueSight Network Automation - Data Warehouse and Network Automation databases on a separate computer.

Sample set up for medium-sized environments

This type of set up is recommended for medium-sized environments. In the following set up (shown in the diagram):

• The Network Automation application server connects to an external database. 
• The TrueSight Network Automation - Data Warehouse application server connects to an external database.

Multi-site deployment

In a multi-site deployment, multiple Network Automation sites populate the reports data warehouse. You can view data for one or more Network Automation sites.

After the initial TrueSight Network Automation - Data Warehouse installation, you can add, enable, disable, or delete sites by using the Site Manager utility.

You can run extract, transform, load (ETL) for the TrueSight Network Automation - Data Warehouse sites either from the Task Scheduler or from the command line.

The following set up shows a multi-site deployment:

In this type of set up:

• Each TrueSight Network Automation - Data Warehouse application server connects to a separate external database.

  Note

  You can locate the databases for all of the Network Automation application servers in a multi-site environment on the same computer. In addition, you can locate the TrueSight Network Automation - Data Warehouse database on the same computer as the common database server for all of the Network Automation application servers.

• The TrueSight Network Automation - Data Warehouse application server connects to an external database.