An ETL (Extract, Transform and Load) task is a process that extracts data from a source, such as a database or data file, transforms them in an appropriate format (if necessary), and then loads them into the BMC TrueSight Capacity Optimization Data Warehouse, automatically cataloging new entities.
For more information, refer to the following sections:
The ETL tasks page lets you manage the tasks responsible for extracting data from all the available sources and feeding it into the BMC TrueSight Capacity Optimization Data Warehouse.
ETL tasks feed BMC TrueSight Capacity Optimization with data for systems and business drivers. Data is extracted from one or more sources, converted into an internal format, loaded into the BMC TrueSight Capacity Optimization Data Warehouse, and then cataloged.
The ETL engine is a core part of BMC TrueSight Capacity Optimization and its management is restricted to administrators. You can assign individual users the roles required to administer ETL tasks by allowing the accounts to perform the
WEB_ADMIN_EDIT activities. You can also use Access Groups and Task Groups to further restrict access to ETL tasks. For more information about users, roles and access groups, refer to Users.
Every ETL task has the following characteristics:
ETL tasks are composed of multiple modules that handle specific operations:
There are various extractor modules bundled with BMC TrueSight Capacity Optimization, organized in macro-categories:
All available ETL tasks are displayed in the summary table. For more information, refer to Managing ETL and System tasks.
ETL tasks table
For more information about working with ETLs, see the following topics: