Storage - All-in-One Extractor Service
Use the Storage All-in-One ETL for BMC Helix Continuous Optimization to poll and collect configuration and performance data from several storage systems all at once. The ETL uses the Storage - All-in-One Extractor Service task to collect all the metrics required for performing critical capacity optimization tasks, such as: analysis, trending, simulation and analytic modeling.
To collect data by using the Storage All-in-One ETL 1.14.00 for BMC Helix Continuous Optimization, perform the following tasks:
I. Complete the preconfiguration tasks.
II. Configure the ETL.
III. Run the ETL.
Step I. Complete the preconfiguration tasks
Ceph Storage
Dell EMC Isilon
Dell EMC SC Series
Dell EMC Unity (REST)
Dell EMC PowerStore (REST)
Dell EMC PowerVault (REST)
Dell EMC ScaleIO/Dell EMC PowerFlex (REST)
Dell EMC VMAX (WBEM)
Dell EMC VMAX/PowerMax (REST)
Dell EMC XtremIO
HPE Primera (WBEM)
Huawei OceanStor
IBM Spectrum Scale
IBM DS888x
Hitachi E, G Series (REST)
Hitachi GUM (REST)
NetApp E-Series REST API
NetApp SolidFire
Pure Storage REST API
Scality RING (Scality Supervisor API)
Deploying the ETL module
Complete the following steps to deploy the ETL Module:
- Navigate to Administration > SYSTEM > Maintenance.
- Verify the installation status of the already uploaded packages. If their status is "READY" or "RUNNING", wait for the installation to complete before proceeding.
- At the bottom of the Maintenance page, locate the Upload patch or additional package file section.
- Click Browse.
- Locate and select the ETL installation package.
- Click Upload.
- Read the Overview and click Next to continue.
- Read and accept the End User License Agreement.
- Select the server on which the operation must be executed; that is the server on which the package will be saved. Click Proceed to continue.
- A successful installation will result in a green line in the Additional Packages table.
Once the Storage All-in-One ETL is installed, the Storage Engine and Storage Intelligence rows appear in the Additional Packages tab:
Step II. Configure the ETL
You must configure the ETL to connect to the required storage system for data collection. ETL configuration includes specifying the basic and optional advanced properties. While configuring the basic properties is sufficient, you can optionally configure the advanced properties for additional customization.
A. Configuring the basic properties
Some of the basic properties display default values. You can modify these values if required.
To configure the basic properties:
- In the Helix Continuous Optimization console, navigate to Administration > ETL & SYSTEM TASKS > ETL tasks.
- On the ETL tasks page, under the Last run tab, click Add > Add ETL. The Add ETL page displays the configuration properties. You must configure properties in the following tabs: Run configuration, Entity catalog, and ETL additional settings.
- On the Run configuration tab, select Storage - All-in-One Extractor Service from the ETL Module list. The name of the ETL is displayed in the ETL task name field. You can edit this field to customize the name.
- Click the Entity catalog tab, and select one of the following options:
Shared Entity Catalog:
Select if ETLs access the same entities.
- From the Sharing with Entity Catalog list, select the entity catalog name that is shared between ETLs.
- Private Entity Catalog: Select if this is the only ETL that extracts data.
Click the Connection Settings tab, and configure the following properties:
Property
Description
Storage Solution
Select the storage system for which you wish to collect capacity information. Select Other Storage Solution to collect capacity information about any other storage solution supported by the Storage-All-in-One ETL. In this case, you will have to manually enter the name of the Si (Storage Intelligence) file to be used.
Other Storage Solution
Name of the Storage Intelligence file (without extension) to be used. This field should only be specified if the Storage Solution property is set to Other Storage Solution.
Hostname
Hostname or IP address of the storage solution.
Port
Port number used to connect to the storage solution.
Connect As
Password to connect to the storage solution.
Transport Protocol
Transport protocol used to connect to the storage solution (HTTP or HTTPS).
- Click Save. You are returned to the Last run tab under the ETL tasks page.
- Validate the results in simulation mode: In the ETL tasks table under ETL tasks > Last run, locate your ETL (ETL task name), click
to run the ETL.
- OK: the ETL executed without any error in simulation mode.
- WARNING: The ETL execution returned some warnings in simulation mode. Check the ETL log.
- ERROR: The ETL execution returned errors and was unsuccessful. Edit the active Run configuration and try again.
- Switch the ETL to production mode: Perform the following steps:
- In the ETL tasks table under ETL tasks > Last run, click the ETL under the Name column.
- In the Run configuration table in the ETL details page, click
to edit the active Run configuration.
- In the Edit run configuration page, navigate to the Run configuration expandable tab and set Execute in simulation mode to No.
- Click Save.
- Validate the results in simulation mode: In the ETL tasks table under ETL tasks > Last run, locate your ETL (ETL task name), click
- Locate the ETL in the ETL tasks table and click
to run it, or schedule an ETL run.
After you run the ETL, or schedule the ETL for a run, it will extract the data from the source and transfer it to BMC Helix Continuous Optimizationdatabase. You can see the entity hierarchy in the left Navigation pane, under Workspace.
Step III. Run the ETL
After you configure the ETL, you can run it to collect data. You can run the ETL in the following modes:
- A: Simulation mode: Only validates connection to the data source, does not collect data. Use this mode when you want to run the ETL for the first time or after you make any changes to the ETL configuration.
- B: Production mode: Collects data from the data source.
A. Running the ETL in the simulation mode
To run the ETL in the simulation mode:
- In the Helix Continuous Optimization console, navigate to Administration > ETL & System Tasks, and select ETL tasks.
- On the ETL tasks page, click the ETL. The ETL details are displayed.
- In the Run configurations table, click Edit
to modify the ETL configuration settings.
- On the Run configuration tab, ensure that the Execute in simulation mode option is set to Yes, and click Save.
- Click Run active configuration. A confirmation message about the ETL run job submission is displayed.
- On the ETL tasks page, check the ETL run status in the Last exit column.
OK Indicates that the ETL ran without any error. You are ready to run the ETL in the production mode. - If the ETL run status is Warning, Error, or Failed:
- On the ETL tasks page, click
in the last column of the ETL name row.
- Check the log and reconfigure the ETL if required.
- Run the ETL again.
- Repeat these steps until the ETL run status changes to OK.
- On the ETL tasks page, click
B. Running the ETL in the production mode
You can run the ETL manually when required or schedule it to run at a specified time.
a. Running the ETL manually
- On the ETL tasks page, click the ETL. The ETL details are displayed.
- In the Run configurations table, click Edit
to modify the ETL configuration settings. The Edit run configuration page is displayed.
- On the Run configuration tab, select No for the Execute in simulation mode option, and click Save.
- To run the ETL immediately, click Run active configuration. A confirmation message about the ETL run job submission is displayed.
When the ETL is run, it collects data from the source and transfers it to the BMC Helix Continuous Optimization database.
b. Scheduling the ETL run
By default, the ETL is scheduled to run daily. You can customize this schedule by changing the frequency and period of running the ETL.
To configure the ETL run schedule:
- On the ETL tasks page, click the ETL, and click Edit. The ETL details are displayed.
- On the Edit task page, do the following, and click Save:
- Specify a unique name and description for the ETL task.
- In the Maximum execution time before warning field, specify the duration for which the ETL must run before generating warnings or alerts, if any.
- Select a predefined or custom frequency for starting the ETL run. The default selection is Predefined.
- Select the task group and the scheduler to which you want to assign the ETL task.
- Click Schedule. A message confirming the scheduling job submission is displayed.
When the ETL runs as scheduled, it collects data from the source and transfers it to the BMC Helix Continuous Optimization database.
Step IV. Post-configuration steps
Reconciling data
If you used the same Shared Entity Catalog while creating your ETL tasks, data will be automatically reconciled since the ETL tasks are using the same lookup details. If you used a Private Entity Catalog or a different entity catalog, you will have to reconcile data. The procedure is as follows:
- Create the new entity catalog:
- In the Administration tab, click ETL & System Tasks >Entity catalogs
- Click Add entity catalog
- Name your entity catalog and eventually provide a description
- Click Save.
- Configure both ETL tasks to use this entity catalog:
- In the Administration tab, click ETL & System Tasks > ETL tasks. Click the link of the ETL task for which you wish to set the entity catalog
- Click the Stop button to stop the service execution; then click the
button available in the Run configuration section.
- In the Entity Catalog section:
- Select the Shared Entity Catalog radio button
- From the Sharing with Entity Catalog pull-down list, select the entity catalog previously created (in our example: EMC)
- Click Save.
- Start the ETL.
- Resume the procedure for the second ETL task.
- Perform the reconcile operation:
- In the Administration tab, click ETL & System Tasks >Entity catalogs
- Click the entity catalog previously created (in our example: EMC)
- Click the Reconcile entities button
- Perform the entity reconciliation:
- Select the Datasource for which you wish to compare the Lookup fields
- Compare entities by Lookup fields and select the look fields
- Click Search to determine the entities that can be reconciled
- Either select the entities to be reconciled and click Reconcile selected rows or click Reconcile all.
- Verify in your workspace that all the selected entities are properly reconciled. Only one instance should be created.