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 therecommended 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:
- 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.
- From the command line, navigate to the following directory: BDS_HOME/shared/odi/bin
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
sswitch 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_etlcommand for each site. For more information, see Managing sites.
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).