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. You can use the set_etl_cutoff.nsh script to limit the amount of data transferred during that run. Subsequent ETL runs do not take as long, because these are incremental runs and smaller amounts of data are being transferred to the reports warehouse.

  • Use the set_etl_cutoff.nsh script, to specify the start date after which data needs to be transferred in ETL runs.
     If you want to limit the amount of data that is transferred during the ETL process, run this script before you run ETL.
  • Use the run_etl_from_om.nsh script to create a 

    The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

     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*