Performing the initial ETL run

After you install and configure TrueSight Server Automation - Data Warehouse for the primary TrueSight Server Automation site, you must start the ETL process to transfer data from the TrueSight Server Automation database to the reports data warehouse. ETL populates the empty reports data warehouse with data from one or more TrueSight Server Automation sites.

To prepare for the first ETL run, perform the reports data warehouse sizing exercise by using the sizing tools recommended by BMC. After the sizing exercise is complete, ensure the following requirements:

• The required disk space is allocated for the reports data warehouse.
• CPUs are allocated for the database server.
• Database parameters are set to the correct values (see Recommendations for the Oracle processes parameter and the Microsoft SQL Server documentation for SQL Server parameter recommendations).

Before running ETL for the first time, ensure that you have assigned appropriate roles to the reporting users. For example, a primary site reporting user must have the GlobalReportAdmins role. 

The instructions in this topic describe how to run ETL from the command line. You can also create a Network Shell Script Job in TrueSight Server Automation to run the ETL. 

To run the ETL for the first time

Do the following:

1. Log in to the system where TrueSight Server Automation - Data Warehouse is installed.
   
   • (Windows) Log in as an administrator.
   • (Linux) Log in as a root user.
2. From the command line, navigate to the following directory: BDS_HOME/shared/odi/bin

3. Start the Network Shell, and enter the following command:

   ./run_etl.nsh -s 1  

   Alternatively, enter the following command. This command starts the Network Shell and runs ETL.

   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 Managing sites.

4. Create a job for running ETL on a regular basis. For more information, see Running ETL using TrueSight Server Automation jobs.

How to video

This video demonstrates how to run the ETL for the first time on Linux (1:52).

https://youtu.be/WurxBxKtXLw