Running ETL using TrueSight Server Automation jobs

A script is available for you to download and use to create a TrueSight Server Automation Network Shell Script Job for running ETL from TrueSight Server Automation. The script, which is called run_etl_from_tssa.nsh, is included in the content_installer.zip file, which is located in the <TSSA-DWInstallationDirectory>/bsa/content_installer directory. When you extract the contents of the content_installer.zip file and run the content installer, the script is added to TrueSight Server Automation as the Run ETL from TSSA Script Network Shell script. 

You can use the Run ETL from TSSA script to create a Network Shell Script Job that you can use to run ETL on specified servers. You can execute the job for a one-time run or you can create a schedule for the job. The job performs the same task as the run_etl command (see Running-ETL-using-an-NSH-script).

You can schedule ETL runs for multiple sites in a batch job. For more information, see Scheduling-ETL-for-multiple-sites.

This topic describes how to create a Network Shell Script Job for the Run ETL from TSSA script, including the flags and parameters.

To create a Network Shell Script Job for the run_etl_from_tssa.nsh script

1. In the TrueSight Server Automation console, navigate to the following directory: Depot/TSSA Reports Scripts/Run ETL from TSSA
   
2. Select Run ETL From TSSA Script.
3. Create a NSH Script Job for the Run ETL From TSSA Script script. 
   The details about parameters and flags that you can set are included in the table in this topic. For information about creating a Network Shell Script Job, see Creating Network Shell Script Jobs in the TrueSight Server Automation documentation.
4. Create a schedule for the job if you want to run ETL on a schedule. 

5. When you create a Network Shell Script Job, you specify the parameters and flags to be used when the job runs. 

   If you do not want to use an optional parameter, ensure that you have removed the flag as well as the value in the Parameters panel. For example, if you do not want the script to run with the RPT_PROP parameter, remove the -f flag and the property file name.
   If you do not remove the flag for an unused parameter, the script returns an error. 

   Using existing jobs

   If you want to run ETL or archive data by using the existing TrueSight Server Automation jobs, the following fields need to be modified:

   Script name	Field/Parameter
   run_archival_from_tssa	ETL_HOME, Target Server
   Run ETL From TSSA Script	ETL_HOME, Target Server

   The following table lists the parameters and flags that you can specify in the Parameters panel of the job creation wizard.