Performing the initial ETL run

Before using

MultiExcerpt named 'Product_Name' was not found

The multiexcerpt named 'Product_Name' was not found. Please check the page name and MultiExcerpt name used in the MultiExcerpt Include macro., you must start the ETL process to transfer data from the 

MultiExcerpt named 'BladeLogic' was not found

The multiexcerpt named 'BladeLogic' was not found. Please check the page name and MultiExcerpt name used in the MultiExcerpt Include macro. database to the reports data warehouse. The initial ETL run can take a long time because it is performing a full data load.

After you install 

MultiExcerpt named 'Product_Name' was not found

The multiexcerpt named 'Product_Name' was not found. Please check the page name and MultiExcerpt name used in the MultiExcerpt Include macro. at the primary 

MultiExcerpt named 'BladeLogic' was not found

The multiexcerpt named 'BladeLogic' was not found. Please check the page name and MultiExcerpt name used in the MultiExcerpt Include macro. site, you can run ETL to transfer data from the primary site to the reports warehouse.

The instructions in this topic describe how to run ETL from the command line. You can also create a 

MultiExcerpt named 'BladeLogic' was not found

The multiexcerpt named 'BladeLogic' was not found. Please check the page name and MultiExcerpt name used in the MultiExcerpt Include macro. Network Shell Script Job to run ETL. BMC recommends that you create a job for running ETL on a regular basis. For more information, see Running ETL using BMC Server Automation 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 BDS_HOME/shared/odi/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  

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

   nsh ./run_etl.nsh -s 1  

   The s switch represents the site ID.

This command uses standard values for the command arguments. For detailed instructions about running ETL and a description of the command arguments, see Running ETL using an NSH script.

To transfer data from other sites, first add those sites if necessary, and then re-run the run_etl command for each site. For more information, see Adding sites.

Where to go from here

Adding sites