Managing and maintaining ETL and System Tasks

The ETL & System Tasks section in the Administration tab of BMC Helix Continuous Optimization 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 Optimizer task
  • Configuring the Data Mart Materializer task
  • Configuring the Task chain
  • Configuring the FileSystem Cleaner task
  • Configuring the Component Status Checker task
  • Configuring the Repository Cleaner task
  • Configuring the Golden Producer task
  • Configuring the Report Executor task
• Maintaining ETL tasks
  • Overview of the ETL workflow
  • 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
    • 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
• Adding external database connections