Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Performing the initial ETL run

Before using BMC BladeLogic Decision Support for Server Automation, you must start the ETL process to transfer data from the BMC Server Automation database to the reports data warehouse.

After you install BMC BladeLogic Decision Support for Server Automation at the primary BMC Server Automation site, you can run ETL to transfer data from the primary site to the reports warehouse.

Note

When running ETL for the first time, you can load a limited amount of historical data based on a fixed cut-off date in the past. This limits the amount of historical data that is loaded into the reports warehouse and potentially reduces the duration of the first time ETL run. For information about setting the data transfer cut-off date, see Specifying-ETL-cut-off-dates.

The instructions in this topic describe how to run ETL from the command line. You can also create a BMC Server Automation Network Shell Script Job to run ETL. BMC recommends that you create a job for running ETL on a regular basis.

The initial ETL run can take a long time, because it is performing a full data load. Keep this in mind when deciding whether to run the initial ETL process from the command line or use a BMC Server Automation Network Shell Script Job. For information about how to create a Network Shell Script Job, see Creating Network Shell Script Jobs.

Before running ETL for the first time, ensure that you have assigned appropriate roles to the users (for example, a primary site user must have the GlobalReportAdmins role). For more information, see Managing-access.

To run ETL for the first time

  1. Navigate to the BDSSAInstallationDirectory/etl/bin directory.

  2. On the reports server, from a command line, start the Network Shell and enter the following command:

    ./run_etl.nsh -s 1 -v <blVersion> -d 3 

    Alternatively, from a command line, enter the following command:

    nsh ./run_etl.nsh -s 1 -v <blVersion> -d 3 

    In this command, replace <blVersion> with the version of BMC Server Automation that you use at your primary site.

This command uses standard values for the command arguments. For detailed instructions on running ETL and a description of the command arguments, see Running-ETL.

To transfer data from other sites, you must add those sites if they are not already added, and then re-run the run_etl command for each site. For more information, see Adding-sites.

 

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