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.

Running ETL

The first time that you run extract, transform, and load (ETL) after installing the product, it populates the empty reports data warehouse and can take some time. The amount of the data transferred during the first ETL run depends on the number of months that you specify while configuring the primary site for the ETL cutoff period (see Primary-Site-tab).  

Subsequent ETL runs do not take as long, because these are incremental runs and smaller amounts of data are being transferred to the reports data warehouse.

  • Use the run_etl_from_om.nsh script to create a BMC Server Automation Network Shell Job that runs ETL. This is the recommended method of running ETL.
  • Use the run_etl.nsh script to run ETL in scheduled runs or directly from the command line.

The following topics describe how to use the ETL process:

 

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