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: