BMC Mainframe CDB Extractor
The BMC Helix Continuous Optimization for Mainframes ETL collects data from your mainframe infrastructure, including CPCs, LPARs, z/OS images, user-defined jobs, and applications.
Before you begin
Before you configure and run this ETL to collect mainframe data, make sure that the following tasks are completed:
Task | Details | Reference |
|---|---|---|
1 | Install the following BMC AMI Capacity Management products:
| |
2 | Subscribe to BMC Helix Continuous Optimization. | |
3 | Install the remote ETL Engine. | |
4 | Configure the CDB Automator to populate UIE data into a staging database. | |
5 | Install the BMC Helix Continuous Optimization for Mainframe add-on package. |
To configure and run the ETL
Before you configure BMC Helix Continuous Optimization for Mainframes ETL, you should familiarize yourself with the following BMC Helix Continuous Optimization concepts:
- Extract, Transform, and Load (ETL)
- ETL task
- ETL run configuration
For more information, see Managing and maintaining ETL and System Tasks in the BMC Helix Continuous Optimization documentation.
Data from UIE is transferred and populated into a CDB staging database. To get this data into the BMC Helix Continuous Optimization Database, you must:
- Configure the BMC Helix Continuous Optimization for MainframesETL task to pull data from the CDB staging database and populate the data warehouse
- Run the ETL task manually to prepare various system parameters
- Schedule the ETL task to run automatically to keep the data warehouse updated with the latest information
The following topics provide more information about configuring BMC Helix Continuous Optimization for Mainframes: