Out-of-the-box ETLs

BMC Helix Continuous Optimization provides a set of out-of-the-box (OOTB) extractors that you can use for data collection. You must configure these ETLs and run them to collect data. These ETLs need to be run on their respective, compatible scheduler, which is installed within an ETL engine. Some of these OOTB ETLs are used to extract data from infrastructure hosted on public clouds like the AWS and GCP whereas other ETLs are used to extract data from your on-premises infrastructure.

Following table provides links to pages with information about how to configure and run these ETLs for data collection. It also mentions the scheduler that is compatible with the respective ETL.

Related topics

Important

Data sourceETL nameETL usageCompatible scheduler
Amazon Web ServicesAmazon Web Services - AWS API ExtractorImports data from your AWS cloud resources.Cloud ETL Engine, Remote ETL Engine
BMC Helix Operations ManagementBMC Helix Operations Management ExtractorExtracts performance and configuration data of devices monitored by the PATROL Agent in BMC Helix Operations Management.Cloud ETL Engine
Google Cloud Platform ServicesGoogle Cloud Platform - GCP API ExtractorImports data from your Google Cloud Platform resources.Cloud ETL Engine, Remote ETL Engine
IBM CloudIBM Cloud - IBM Cloud API Extractor for Classic InfrastructureImports data from your IBM cloud resources.Cloud ETL Engine, Remote ETL Engine
Microsoft Azure Cloud ServicesMicrosoft Azure - Azure API ExtractorImports data from your Microsoft Azure resources.Cloud ETL Engine, Remote ETL Engine
Gateway Server

BMC - TrueSight Capacity Optimization Gateway VIS files parser

Loads daily performance and configuration metrics from a running Gateway Server instance. It can also be used for loading recovery data from a running Gateway Server instance.

Remote ETL Engine

TrueSight Operations ManagementBMC - TrueSight Operations Management 10.7/11.0/11.3 extractorExtracts performance and configuration data from TrueSight Operations Management version 10.7 or later for Standalone, KVM, Solaris, and AIX platforms.Remote ETL Engine
BMC - TrueSight Operations Management 10.7/11.0/11.3 Generic extractorExtracts performance and configuration metrics from TrueSight Operations Management version 10.7 or later for platforms that are not supported by the BMC - TrueSight Operations Management 10.7/11.0/11.3 extractor.Remote ETL Engine
BMC AtriumBMC - Atrium CMDB extractor

Extracts service-system and application-system relationships from the Atrium CMDB database in your on-premises data center.

Remote ETL Engine

BMC DiscoveryBMC Discovery 11.x ExtractorConnects to the BMC Discovery service to retrieve the discovered data center inventory, configuration, and relationship data.Remote ETL Engine
VMware vCenterVMware - vCenter and ESX Server History ExtractorExtracts historical data from vCenter and ESX servers. This extractor requires you to increase the vCenter statistics collection level.Remote ETL Engine
VMware - vCenter Extractor ServiceEnables you to configure the continuous polling and collection of data from a VMware environment.Remote ETL Engine
Red Hat Enterprise VirtualizationRed Hat Enterprise Virtualization - Extractor serviceImports data from a RHEV environment using the REST API exposed by the RHEV Manager.Remote ETL Engine
NutanixNutanix - Prism API Extractor for AHVImports data from the Nutanix Acropolis hypervisor entities.Remote ETL Engine
OpenStackOpenStack - OpenStack API Extractor Service

Integration with OpenStack is supported through this extractor that imports OpenStack entities into BMC Helix Continuous Optimization.

Remote ETL Engine

VMware
vCloud Director
VMware - Cloud Director 9.x/10.x ExtractorExtracts vCloud infrastructure and services data from the VMware vCloud Director. Remote ETL Engine
VMware - vCloud Infrastructure extractorExtracts vCloud infrastructure data from VMware vCloud Director.Remote ETL Engine
VMware - vCloud Services extractorExtracts vCloud services data from VMware vCloud Director.Remote ETL Engine
Oracle Enterprise
Manager
Oracle - Enterprise Manager extractorExtracts data from Oracle Enterprise Manager.Remote ETL Engine
Generic


 



Generic - CSV columnar file parser

Imports data from columnar CSV files.Remote ETL Engine

Generic - CSV file parser

Imports data from regular CSV files.Remote ETL Engine
Generic - Columnar Database extractorExtracts generic data from columnar databases.Remote ETL Engine
Generic - Columnar database extractor (Java)

Extract generic data from columnar databases using Java.

Remote ETL Engine

Generic - Database extractor

Extracts data through SQL queries.

Remote ETL Engine

Generic - Database extractor (Java)Extract generic data using a SQL query.Remote ETL Engine
Generic - Domain extractor importer

Extracts domains and imports them into BMC Helix Continuous Optimization.

Remote ETL Engine

Generic - General Text Log Parser

Parses general text logs into BMC Helix Continuous Optimization.

Remote ETL Engine

Generic - NCSA log parser

Parses web server (Apache and IIS) log files.Remote ETL Engine
Generic - Object Relationship CSV Parser

Parses custom relationships among entities in BMC Helix Continuous Optimization.

Remote ETL Engine

Generic - Object relationship SQL extractor

Extracts custom relationships among entities in BMC Helix Continuous Optimization.

Remote ETL Engine

Generic - Tag CSV file parserEnables you to manage the tags for entities that are imported by other ETLs.Remote ETL Engine


Out-of-the-box ETLs by BMC partners

Some OOTB ETLs are provided by these BMC partners - Sentry and Moviri. The following topics give details about these ETLs:


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

Comments