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 

Was this page helpful? Yes No Submitting... Thank you

Comments

  1. Matthew Ragland

    The Installing TrueSight Smart Reporting with SQL Server link yields "page not found"

    Aug 26, 2019 09:48
  2. Barry Reilly
    1. On the reports server, from a command line

    eh? how can we be on the report server [tssr] a second server when we have not even gotten to install tssr 20.02 yet,, come on lads wth!

    May 26, 2020 07:38
    1. Sulekha Gulati

      Thank you, Barry for bringing this to our attention. I have updated the steps. Thanks.

      Jul 03, 2020 05:31