Managing and maintaining ETL and System Tasks

The ETL & System Tasks node in the Administration tab of Helix Capacity Optimization Console allows you to create and modify various ETL and System tasks. You can schedule batch connector and other batch jobs to run on a regular basis. You can manage task groups as well.

For more information on administering the ETL and System Tasks, see:

• Adding Task groups
• Maintaining System tasks
  • Configuring the Golden Producer task
  • Configuring the Report Executor task
  • Configuring the Optimizer task
  • Configuring the Virtual Node Linker task
  • Configuring the Data Mart Materializer task
  • Configuring the Task chain
  • Configuring the Queue Waiter task
  • Configuring the FileSystem Cleaner task
  • Configuring the Auto Analyzer task
  • Configuring the Component Status Checker task
  • Configuring the database maintenance tasks
  • Configuring the ER View Materializer task
  • Configuring the Event Aggregator task
  • Configuring the Model Solver task
  • Configuring the Repository Cleaner task
  • Configuring the VMware Automated Reconciliation task
  • Entities Cleaner task
  • Search Index Updater task
  • Hierarchy Manager task
• Maintaining ETL tasks
  • Overview of the ETL workflow
  • Adding and managing data movers
  • ETL configuration macros
  • Working with ETLs
    • Configuring database connection using Perl or Java ETLs
    • Determining how to aggregate data to a given resolution using SQL
    • Determining how to append the output of an ETL to an existing file using FileAppenderA
    • Determining how to extract compressed files
    • Enabling Windows shares mounting
    • Exporting the run configuration of an ETL
    • Gathering ETL logs
    • Handling ETL lookup name
    • Importing and exporting ETL packages
    • Importing macro-events
    • Setting file access for parsers
    • Understanding entity identification and lookup
  • Managing an Open ETL template
    • Column mapping for Open ETL template
• Managing ETL and System tasks
• Adding and managing Entity catalogs
  • Reconciling and managing duplicate entities of a vCenter host or VM
• Adding external database connections